Tutorials by ONLamp.com
Normalizing data into a database saves you time and trouble representing information, but actually displaying and reporting that information is trickier.
May 8,
2009
Today Views:
1 Total Views:
1,171
Many SQL queries misuse their FROM clauses. Misuse them? That's right. Stephane Faroult explains this common mistake and demonstrates how two types of subqueries can improve performance and reliability.
May 5,
2009
Today Views:
1 Total Views:
1,458
How well are your database tables communicating with one another? This week John Paul discusses three key relationships: one to one, one to many, and many to many.
April 28,
2009
Today Views:
1 Total Views:
1,655
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools.
April 27,
2009
Today Views:
1 Total Views:
1,064
Well-factored applications separate data storage, manipulation, and display. For PHP programmers, PHP 5 and PEAR make that easier than ever.
November 12,
2008
Today Views:
1 Total Views:
1,199
One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP. This week, learn how to count results, handle errors, and handle picky details.
August 7,
2008
Today Views:
1 Total Views:
999
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use it. John Coggeshall explains how to change tables, select only the data you want, and delete rows from MySQL.
August 5,
2008
Today Views:
1 Total Views:
1,009
PHP is an easy language for doing practical things immediately. The easiest ways to begin aren't always the best ways to stay productive, though. PHP's support for object orientation requires a little more learning and a little more discipline, but it has many benefits for larger projects.
June 27,
2008
Today Views:
1 Total Views:
968
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains how to make the most of the SQL SELECT statement across multiple tables.
June 19,
2008
Today Views:
2 Total Views:
925
Building and bundling web applications hasn't exactly grown easier over the years. This is especially true if you customize your projects for different clients. Don't go crazy with manual solutions--automate them.
June 5,
2008
Today Views:
1 Total Views:
631
