Videos ➤ PHP ➤ Miscellaneous ➤ PDO Prepared Statements PHP Tutorial

PDO Prepared Statements PHP Tutorial

Name: PDO Prepared Statements PHP Tutorial
Uploaded: 2015-01-26T17:02:55+00:00
Description: Watch PDO Prepared Statements PHP Tutorial video in the Miscellaneous subsection of the PHP section. Learn PHP with Adam Khoury.

Published : January 26, 2015
Last Edited : November 24, 2025
Author : Adam Khoury

Learn to create PDO Prepared Statements and quickly discover its key benefits. In the very next video tutorial you can learn to create prepared statements using mysqli. Prepared statements work for Both the PDO and mysqli extensions in PHP.

<?php
$db = new PDO('mysql:host=localhost;dbname=db_name', 'db_user', 'db_password');
// :username, :gender, :country are named placeholders in the SQL syntax below
$sql = "INSERT INTO people (username, gender, country) VALUES (:username, :gender, :country)";
$stmt = $db->prepare($sql);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':gender', $gender);
$stmt->bindParam(':country', $country);

$username = 'Beth';
$gender = "f";
$country = "Canada";
$stmt->execute();

$username = 'Sandeep';
$gender = "m";
$country = "India";
$stmt->execute();

echo "Prepared statements have been executed";
$db = null;
?>