- Data Integrity using MySQL and PHP
This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.
http://www.abriasoft.com/view_contrib.php?internalid=4
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Data Integrity Using MySQL and PHP (Part 2)
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.
http://www.abriasoft.com/view_contrib.php?internalid=5
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Database Normalization And Design Techniques
One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. This 6-page article describes the data relationships and the normalization of data using a simple example.
Price: Free
http://www.phpbuilder.com/columns/barry20000731.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Descriptions of Common Data Types
This is a short reference to common data types of MySQL database, a shorter version of the one found in the MySQL manual.
Price: Free
http://www.thickbook.com/extra/php_datatypes.phtml
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Doing Simple DB Abstraction in PHP
This tutorial explains the need for database abstraction in PHP, and shows how to create your own database API that can be to used with different types of databases. The tutorial uses a PHP PostgreSQL API as an example.
http://www.phpdeveloper.org/tutout.php?num=12
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Interfacing With MS Access 97\+
Here, you will learn how to create an MS Access database and interface with it using PHP on Windows platform. Main topics include: Creating an Access database, Setting up an ODBC Connection, and Interfacing with database.
Price: Free
http://www.phpbuilder.com/columns/siddarth20000228.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Introduction to Database Abstraction with PHPLib
This tutorial introduces the use of database abstraction as a solution for the troublesome database migration. Many database wrappers exist and arguably the most widely used one comes as part of the PHPLib library. This 3-page tutorial explains how to create a generic wrapper which can be applied to any database using PHPLibs database abstraction layer.
Price: Free
http://php.vamsi.net/article/2/1
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Joining tables
Joining two or more tables is something that everyone that uses a RDBMS needs to learn how to do at some point. This tutorial covers Primary keys and Forgiun keys as well.
Version: 1.0
http://www.kill-9.dk/ttl_sql_join.php
(Rating: 0.00 Votes: 0)
Rate It
Review It
|
