🚀 DevOps & SRE Certification Program 📅 Starting: 1st of Every Month 🤝 +91 8409492687 🔍 Contact@DevOpsSchool.com

Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

How to use PDO to update the database?

1) Write the regular update statement and again, instead of values, assign the named placeholders. For example:
[code language=”php”]
$sql = "UPDATE `users`
SET `city`= :city, `phone` = :tel
WHERE `id` = :id";
[/code]

2) Prepare the query:
[code language=”php”]
$query = $dbh->prepare($sql);
[/code]

3) Bind the parameters:
[code language=”php”]
$query -> bindParam(‘:city’, $city, PDO::PARAM_STR);
$query -> bindParam(‘:tel’ , $tel , PDO::PARAM_INT);
$query -> bindParam(‘:id’ , $id , PDO::PARAM_INT);
[/code]

4) Define the bound values:
[code language=”php”]
$tel = ‘3456789012’;
$city = ‘Bokaro’;
$id = 1;
[/code]

5) Execute the query:
[code language=”php”]
$query -> execute();
[/code]

6) Check that the query has been performed and that the database has been successfully updated.
[code language=”php”]
if($query -> rowCount() > 0)
{
$count = $query -> rowCount();
echo $count . " rows were affected.";
}
else
{
echo "No affected rows.";
}
All together now:
$sql = "UPDATE users
SET `city`= :city, `phone` = :tel
WHERE `id` = :id";
$query = $dbh->prepare($sql);
$query -> bindParam(‘:city’, $city, PDO::PARAM_STR);
$query -> bindParam(‘:tel’ , $tel , PDO::PARAM_INT);
$query -> bindParam(‘:id’ , $id , PDO::PARAM_INT);
$tel = ‘11223456789’;
$city = ‘Pune’;
$id = 1;
$query -> execute();
if($query -> rowCount() > 0)
{
$count = $query -> rowCount();
echo $count . " rows were affected.";
}
else
{
echo "No affected rows.";
}
[/code]

Subscribe
Notify of
guest


0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.

0
Would love your thoughts, please comment.x
()
x