Database Related Tutorials - LearnPHP.org
A look at what's going on behind the scenes when you perform a "join" in MySQL. John Paul Ashenfelter uses the cross join as an example of how joins work in general.
March 20,
2008
Today Views:
2 Total Views:
106
Before you can do anything with MySQL in PHP you must first establish a connection to your web host's MySQL database. This is done with the MySQL connect function.
March 20,
2008
Today Views:
2 Total Views:
112
In the last column, John Paul Ashenfelter showed you how to use inner joins and cross joins. This week he tackles outer joins.
March 19,
2008
Today Views:
1 Total Views:
85
A MySQL table is completely different than the normal table that you eat dinner on. In MySQL and other database systems, the goal is to store information in an orderly fashion. The table gets this done by making the table up of columns and rows.
March 18,
2008
Today Views:
2 Total Views:
104
The exploration into JOIN statements continues with a look at INNER JOIN, the most commonly used SQL join.
March 17,
2008
Today Views:
1 Total Views:
102
When data is put into a MySQL table it is referred to as inserting data. When inserting data it is important to remember the exact names and types of the table's columns.
March 17,
2008
Today Views:
2 Total Views:
112
This week, John Paul Ashenfelter looks at the "self-join," a tool that is particularly useful in certain situations, such as when you have a normalized database table that needs to be flattened.
March 14,
2008
Today Views:
1 Total Views:
108
In this tutorial I will show you how to use basic database manipulation features in PHP.
March 13,
2008
Today Views:
1 Total Views:
133
So far we have seen a couple different uses of PHP's mysql_query function and we'll be seeing more of it as nearly all MySQL in PHP is done through the MySQL Query function.
March 13,
2008
Today Views:
2 Total Views:
112
Subqueries are extremely useful in web-based database applications where you need to combine two queries and manually put them together to achieve a desired result. Subqueries allow SQL to do all of the heavy lifting!
March 12,
2008
Today Views:
3 Total Views:
121
