Follow Us!

Access a MySQL Database Using PDO

Posted by on Nov 2, 2010 in Database Tutorials, MySQL Tutorials, PHP Tutorials, Web Development Tutorials | 2 comments

This tutorial will show you how to access a mysql database using the PHP Data Objects interface, also known simply as PDO. One big...

Read More

Referential Integrity with MySQL

Posted by on Dec 3, 2009 in Database Tutorials, MySQL Tutorials | 15 comments

Referential Integrity is when the rows from one table are “cross-referenced” and verified with those in another table. This tutorial will walk you through using MySQL to enforce this rule.

Read More

Editing MySQL Data Using PHP

Posted by on Mar 13, 2009 in Database Tutorials, MySQL Tutorials, PHP Tutorials, Web Development Tutorials | 65 comments

We have had a few tutorial that show how to display and add data to a MySQL database. Now I am going to show you how to edit a row in your database. In previous examples we setup a table whcih contains: ID, FName, LName and PHON. We will be retreiving the data, making changes, then updating the row in the database. This tutorial is design for the user to update there own information so we will only be editing row for this user.

Read More