Tutorials by ONLamp.com
Application upgrades aren't always easier. Throw in a database backend and a schema change, and you're in for a world of hurt -- unless you've planned well. Russell Dyer explores techniques for taking the pain out of upgrading database-backed applications.
February 23,
2010
Today Views:
1 Total Views:
1,057
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.
February 18,
2010
Today Views:
3 Total Views:
1,186
Although there are several tools available to help users efficiently and easily create pivot tables or cross-tabulations, being able to visualize the cross-tabulations in real time is much more useful.
February 16,
2010
Today Views:
1 Total Views:
1,047
The most popular "proper" way to build a web application seems to be to use the Model-View-Controller design pattern. While it sounds complex, the concepts are sound and the ease of development it provides are compelling.
February 11,
2010
Today Views:
2 Total Views:
968
Type; reload web site; eyeball output; fix bugs; repeat--there's a better way to write PHP code! Testing gives you confidence not only that your code works, but also that you can make changes to improve your design and flexibility without breaking behavior.
February 4,
2010
Today Views:
1 Total Views:
939
It's easy to build a small web site by hand, but what happens when non-techies need to make changes? Russell Dyer demonstrates how to design and build a just-simple-enough web site management system that can alleviate your pain.
January 28,
2010
Today Views:
1 Total Views:
1,098
Paul DuBois has selected sample recipes from the hundreds you'll find in his book, MySQL Cookbook. In this first in a three-part series showcasing these sample recipes, find out how to interpret results from summaries and NULL values and how to identify duplicates in a table or record.
January 22,
2010
Today Views:
1 Total Views:
835
Paul DuBois has selected sample recipes from the hundreds you'll find in his book, MySQL Cookbook. In this third and final series of excerpts showcasing these recipes, learn how to compute team standings, how to calculate the differences between...
January 22,
2010
Today Views:
1 Total Views:
1,140
Here are eight tips for enhancing Web database applications by using PHP and MySQL.
January 14,
2010
Today Views:
1 Total Views:
1,429
The JOIN clause is probably one of the most used -- as well as one of the most confusing -- facets of SQL. John Paul Ashenfelter introduces the JOIN clause.
January 6,
2010
Today Views:
1 Total Views:
1,036
