How to insert, update, and delete using PDO

Method	Description
exec($sql_statement)	Executes the specified SQL statement and returns the number of affected rows. If no rows were affected, the method returns zero.

       $category_id_q = $db->quote($category_id); 
       $code_q = $db->quote($code); 
       $name_q = $db->quote($name); 
       $price_q = $db->quote($price); 
       $query = "INSERT INTO products 
                 VALUES (categoryID, productCode, productName, listPrice) 
                 ($category_id_q, $code_q, $name_q, $price_q)"; 
       $insert_count = $db->exec($query);
      

      $product_id_q = $db->quote($product_id);
      $price_q = $db->quote($price); 
      $query = "UPDATE products SET listPrice = $price_q 
                WHERE productID = $product_id_q"; 
      $update_count = $db->exec($query);
      

       $product_id_q = $db->quote($product_id); 
       $query = "DELETE FROM products WHERE productID = $product_id_q"; 
       $delete_count = $db->exec($query); 
      

      <p>Insert count: <?php echo $insert_count; ?></p>
      <p>Update count: <?php echo $update_count; ?></p>
      <p>Delete count: <?php echo $delete_count; ?></p>
      

Description

• To execute an INSERT, UPDATE, or DELETE statement, you use the exec() method of the PDO object with the SQL statement as the argument.
• The exec() method returns a value that represents the number of rows that were affected, and this value can be assigned to a variable.