Database Related Tutorials - LearnPHP.org
SQL stands for Structured Query Language and is used to pull information from databases.
March 11,
2008
Today Views:
1 Total Views:
106
Because SQL is based on relational algebra, it should come as no surprise that the standard contains several set-oriented operators. In that spirit, it's time we take a look at the UNION operator.
March 11,
2008
Today Views:
1 Total Views:
91
MySQL doesn't have a Fetch Array function. mysql_fetch_array is actually a PHP function that allows you to access data stored in the result returned from a successful mysql_query.
March 10,
2008
Today Views:
2 Total Views:
125
GUI-based database management tools are great, but it's also important to understand the broad strokes of directly manipulating database structure. In this week's aboutSQL, John Paul Ashenfelter describes how to use SQL to define the database, its component tables, and other artifacts.
March 7,
2008
Today Views:
2 Total Views:
131
You have seen two types of MySQL queries thus far: the query which we used to create a table and the query we used to insert data into our newly created table. The query in this lesson is SELECT, which is used to get information from the database, so that its data can be used in our PHP script.
March 7,
2008
Today Views:
1 Total Views:
129
In the last aboutSQL column, John Paul Ashenfelter introduced the Data Definition Language (DDL) and how to create database containers. This week, he moves on to creating tables and populating them with data.
March 6,
2008
Today Views:
2 Total Views:
139
If we wanted to select only certain entries of our table, then we would use the keyword WHERE.
March 5,
2008
Today Views:
1 Total Views:
119
Most database products support ANSI-SQL for manipulating data, but there is far more variance in the details of how DDL is implemented. John Paul Ashenfelter discusses data types for different SQL platforms.
March 5,
2008
Today Views:
1 Total Views:
123
It would be nice to be able to make MySQL results easier to read and understand. A common way to do this in the real world is to order a big list of items by name or amount. The way to order your result in MySQL is to use the ORDER BY statement.
March 4,
2008
Today Views:
2 Total Views:
105
Here are eight tips for enhancing Web database applications by using PHP and MySQL.
March 3,
2008
Today Views:
1 Total Views:
146
