echo $e->getMessage();
}
//INSERT A VALUE
$db->exec("INSERT INTO user (email, password) VALUES ('".getFakeEmail()."','".rand(1,100)."')");
//INSERT WITH PLACEHOLDER
$stmt = $db->prepare("INSERT INTO user (email, password) VALUES (?, ?)");
$stmt->execute(array(
getFakeEmail(),
rand(1,100))
);
//INSERT WITH BIND
$stmt = $db->prepare("INSERT INTO user (email, password) VALUES (:email, :password)");
$stmt->bindParam(':email', getFakeEmail(), PDO::PARAM_STR);
$stmt->bindParam(':password', rand(1,100), PDO::PARAM_STR);
$stmt->execute();
//SELECT ALL
$stmt = $db->query('SELECT * FROM user');
$rows = $stmt->fetchAll();
foreach ($rows as $row) {
echo $row['id'] . ' - ';
echo $row['email'] . ' - ';
echo $row['password'] . '<br><br>';
}
function getFakeEmail() : string
{
CREATE TABLE IF NOT EXISTS user (
id int(11) NOT NULL auto_increment,
username char(100) NOT NULL,
email char(100) NOT NULL,
password char(32) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY email (email)
);';
$db->exec($createTableQuery);
$db->exec("INSERT INTO user (username, email, password) VALUES ('Nicola', '*****@*****.**','".rand(1,100)."')");
} catch(PDOException $e) {
echo $e->getMessage();
}
//INSERT A VALUE
$db->exec("INSERT INTO user (username, email, password) VALUES ('".getFakeUserName()."','".getFakeEmail()."','".rand(1,100)."')");
function getFakeEmail() : string
{
return 'user'.rand(1,1000).'@email.com';
}
function getFakeUserName() : string
{
return 'user'.rand(1,1000);
}
