Структура базы данных
База данных: json Таблица: Данные json Поле: идентификатор, кунчи, json
PHP-коды
halaman/beranda.php
JSON
JSON Server
halaman/olah.php
prepare('insert into jsonData (kunci, json) values (:kunci, :json)')->execute([
':kunci' => $_POST['kunci'],
':json' => $_POST['json']
]);
header('Location: ' . $_POST['kunci']);
halaman/tampil.php
query('select json from jsonData where kunci = "' . $routes[1] . '"');
$hasil = '';
while ($row = $data->fetch()) {
$hasil = $row['json'];
}
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET, POST");
header('Content-Type: application/json');
echo $hasil;
halaman/ubah.php
prepare('update jsonData set json = :json where kunci = :kunci')->execute([
':json' => $_POST['json'],
':kunci' => $routes[1]
]);
}
.htaccess
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]
.htaccess
0 && $routes[2] == 'ubah') {
include 'halaman/ubah.php';
} elseif (strlen($routes[1]) > 0) {
include 'halaman/tampil.php';
}
Оригинал: “https://dev.to/mzaini30/source-code-of-json-server-app-written-in-php-2o3h”