sudo mysql -u root -p
CREATE DATABASE alexbeebee_database;
CREATE TABLE alexbeebee_database.todo_list (
item_id INT AUTO_INCREMENT,
content VARCHAR(255),
PRIMARY KEY(item_id)
);
INSERT INTO alexbeebee_database.todo_list (content) VALUES (“Alex is handsome.”);
SELECT * FROM alexbeebee_database.todo_list;
exit
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
sudo nano /var/www/html/alex.php
<?php
$user = “”;
$password = “”;
$database = “alexbeebee_database”;
$table = “todo_list”;
try {
$db = new PDO(“mysql:host=localhost;dbname=$database”, $user, $password);
echo “<h2>TODO</h2><ol>”;
foreach($db->query(“SELECT content FROM $table”) as $row) {
echo “<li>” . $row[‘content’] . “</li>”;
}
echo “</ol>”;
} catch (PDOException $e) {
print “Error!: ” . $e->getMessage() . “<br/>”;
die();
}
?>