Referential Integrity with MySQL
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.
MySQL Tutorials
Access a MySQL Database Using PDO
This tutorial will show you how to access a mysql database using the PHP Data Objects interface, also known simply as PDO. One big advantage of using PDO versus other methods is the use of prepared statements which offers much better security than the mysql or mysqli libraries. Also PDO can connect to several different … Read more
Editing MySQL Data Using PHP
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.
When Case Mysql
When working with MySQL, the CASE statement can be a powerful tool for customizing the results of a query based on specific conditions. Here, I will delve into the intricacies of the CASE statement in MySQL and provide insights based on personal experience. The Basics of the CASE Statement The CASE statement in MySQL allows … Read more
Which Table Does Mysql Store Password
Hello! Today, we’ll delve into the fascinating realm of MySQL databases to uncover the mystery of where MySQL passwords are actually stored. As someone who loves technology and has a keen interest in MySQL, I find this subject incredibly compelling. So, let’s begin our exploration! When it comes to securing passwords in a MySQL database, … Read more