NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Data Integrity using MySQL and PHP
25960
Data Integrity using MySQL and PHP
http://www.abriasoft.com/view_contrib.php?internalid=4
While the word "integrity" connotes "wholeness", it's important to understand what it means specifically in the case of relational database design. Failure to ensure data integrity can result in the database returning incorrect results, or in data becoming unretrievable. This is true of all relational databases, not just MySQL. Fortunately, the principles of data integrity are not difficult to understand. How difficult they are to implement in MySQL and PHP will depend in large degree on how many tables and relationships the database has. This article will start with an overview of relational concepts, and then illustrate each of the concepts with simple examples.
PHP > Tips and Tutorials > Database-Related
Oct 15, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Data Integrity using MySQL and PHP: |
|||
Other links at PHP > Tips and Tutorials > Database-Related
In some recent work I needed to have databases created with a back end application. Once the database was created from this online application it was pre filled with tables and data from another script that ran right after the database was made. To create a database with PHP we first need to connect as a user that has the ability to create new databases. Note that we are not connecting to a database but we are connecting to MySQL as a user.
Category:
Abstraction is a technique which simplifies something complex. It does this by removing non-essential parts of the object, allowing us to concentrate on the important parts.
Category:
Learn how to create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how many query were executed during your PHP script.
Category:
This tutorial will provide you with a simple walk-through on how to install ADODB on any system. ADODB is a database abstraction layer library, basically providing OOP support through PHP to connect to a database.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19538
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 227874
Pagerank Statistics
PHP News