Hi guys in last tutorial we was discuss on PDO query statements such as SELECT Query, INSERT Query, UPDATE Query and DELETE Query like that in this tutorial we will discuss on how to execute all PDO queries with prepared statements.
Note : For PDO connection file click here.
A prepared statement is a similar SQL statements, it’s feature used to execute the SQL statements.
Here write the code of fetch data from users table using prepared statement PHP PDO.
$statement = $DBH->prepare("SELECT * FROM `users` WHERE id = ?"); $statement->execute(array($uid")); $row = $statement->fetch();
Here write the code of insert data into users table using prepared statement PHP PDO.
$query = $DBH->prepare("INSERT INTO `users` (name, username, email) values (?, ?, ?)"); $query->execute(array($name, $username, $email));
Here write the code of update data into users table using prepared statement PHP PDO.
$query = $DBH->prepare("UPDATE `users` SET `name` = ?, `email` = ? WHERE `id` = ?"); $query->execute(array($name, $email, $uid));
My name is Mukesh Jakhar and I am a Web Application Developer and Software Developer, currently living in Jaipur, India. I have a Master of Computer Application in Computer Science from JNU Jaipur University. I loves to write on technology and programming topics. Apart from this, I love to travel and enjoy the beauty of nature.