exec('CREATE TABLE IF NOT EXISTS `user`(
id INTEGER AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(255),
email VARCHAR(255),
created_at TIME,
status VARCHAR(30)
);');
echo "TABLE CREATED (IF NOT EXISTS)
";
// CREATE USER
$createUser = $pdo ->exec('INSERT INTO user VALUES(
null,
"danielvici223",
"daniel@danielvici.com",
"11:00:00",
"active"
);');
echo "USER CREATED
";
// update haben wir nicht gemacht
// DELETE USER
$deleteUser = $pdo ->exec('DELETE FROM user WHERE id=1');
// pagination <- keine was das ist?
echo "USER 1 DELETED
";
} catch (PDOException $e) {
echo "". $e ."";
}
?>