Php PDO: Prepare Statement with Insert and Update

Insert data in books table using Php PDO.
The example below will insert title "Php Pamplates" and author "Kishor" in books table.

Example: Insert query with PDO prepare statement

<?php
       // configuration variables
        $dbhost     = "localhost";
        $dbname     = "mydatabase";
        $dbuser     = "root";
        $dbpass     = "";        
        // database connection
        $connection = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
         
        // new data
        $title = 'Php Pamplates';
        $author = 'Kishor';
        $sql = "INSERT INTO books (title,author) VALUES (:title,:author)";
        $query = $connection->prepare($sql);
        $query->execute(array(':author'=>$author,':title'=>$title));
?>

Now, Update data in books table using Php PDO.
The example below will update title to "Php Books" and author to "Hiren" in books table where id
is 1.

Example: Update query with PDO prepare statement

<?php
        // configuration variables
        $dbhost     = "localhost";
        $dbname     = "mydatabase";
        $dbuser     = "root";
        $dbpass     = "";        
        // database connection
        $connection = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
        // data to be updated in id 1
        $title = 'Php Books';
        $author = 'Hiren';
        $id = 1;
        // query
        $sql = "UPDATE books SET title=?, author=? WHERE id=?";
        $query = $connection->prepare($sql);
        $query->execute(array($title,$author,$id));
         
?>