PHP MYSQL
(quick guide & example)
id title text
INTEGER, PRIMARY KEY VARCHAR TEXT
<form method="post"> CONTENT ID <input type="hidden" name="id"> TITLE <input type="text" name="title"> TEXT <textarea name="txt"></textarea> <input type="submit" value="Save"> </form>
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
REPLACE SQL $stmt = $pdo->prepare("REPLACE INTO `contents` (`id`, `title`, `text`) VALUES (?,?,?)");
EXECUTE SQL $stmt->execute([$_POST["id"], $_POST["title"], $_POST["txt"]);
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
FETCH $id = 123; $stmt->execute([$id]); $content = $stmt->fetch();
SELECT SQL $stmt = $pdo->prepare("SELECT * FROM `contents` WHERE `id`=?");
<h1> <?=$content["title"]?> </h1> <p> <?=$content["text"]?> </p>