PHP PDO Insert Tutorial Example - DEV Community
Mon Aug 21 2023 20:17:45 GMT+0000 (Coordinated Universal Time)
Saved by
@mvieira
<?php
$host = 'localhost';
$db = 'demos';
$user = 'root';
$password = '';
$dsn = "mysql:host=$host;dbname=$db;charset=UTF8";
try {
$conn = new PDO($dsn, $user, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
} catch (PDOException $e) {
echo $e->getMessage();
}
$data = [
'title' => 'test title',
'content' => 'test content'
];
$sql = 'INSERT INTO posts(title, content) VALUES(:title, :content)';
$statement = $conn->prepare($sql);
$statement->execute($data);
echo "Post saved successfully!";
content_copyCOPY
https://dev.to/codeanddeploy/php-pdo-insert-tutorial-example-1kjd
Comments