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));
This is Mukesh Jakhar. I’m a professional web developer with 3+ years experience. I am always ready for freelance work and i am writing blogs in my free time. I love to learn new technologies and share with others.
I founded PHPKIDA in September 2015. The focus of this website to provide web development tutorials of PHP, WordPress, CodeIgniter, Jquery, MySQL, HMTL, CSS etc and sharing solution to problems which i already solved.