Skip to Content
Beginning PHP 5.3
book

Beginning PHP 5.3

by Matt Doyle
October 2009
Beginner
836 pages
19h 37m
English
Wrox
Content preview from Beginning PHP 5.3

Chapter 14. Manipulating MySQL Data with PHP

This is the third and final chapter on the topic of building database-driven PHP applications. In Chapter 12 you came to grips with the basics of MySQL and relational databases, and learned how to use PDO (PHP Data Objects) to connect to MySQL databases from PHP. Chapter 13 explored the concept of retrieving data from a database within your PHP scripts; you learned in detail how to create SELECT queries, and you wrote a simple record viewer for displaying details of members in a book club database.

In this chapter, you look at how to alter the data in a MySQL database using PHP. This involves:

  • Inserting new records into tables using INSERT statements

  • Changing field values within records with UPDATE statements

  • Deleting records using DELETE statements

You explore these three operations in detail, and learn how to perform them from within your PHP scripts.

Once you understand how to manipulate data in a MySQL database, you build an application to allow new members to register for your book club database and log in to a members-only area of your Web site, and write some PHP code that you can use to log each member's page views in the members' area. Finally, you extend the member record viewer you created in Chapter 13 to allow you to edit and delete member records.

Inserting Records

You learned how to use SQL to add records to a table in Chapters 12 and 13. Remember that you can insert a row of data with:

INSERT INTO table VALUES ( value1, value2 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

PHP 5 Unleashed

PHP 5 Unleashed

John Coggeshall
PHP 7: Real World Application Development

PHP 7: Real World Application Development

Doug Bierer, Altaf Hussain, Branko Ajzele

Publisher Resources

ISBN: 9780470413968Purchase book