Tutorials by ONLamp.com
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:
6 Total Views:
11
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:
3 Total Views:
39
Well-factored applications separate data storage, manipulation, and display. For PHP programmers, PHP 5 and PEAR make that easier than ever.
August 1,
2008
Today Views:
2 Total Views:
75
The beauty of LAMP systems is that you can develop them as formally or informally as you like. Unfortunately, when it comes time to plan for disaster recovery, that informality can work against you. Robert Jones presents several guidelines for development and configuration that can make...
July 31,
2008
Today Views:
1 Total Views:
63
Conventional wisdom claims that it's difficult to model hierarchical relationships in relationally minded SQL. Actually, it's easier than you think. Joe Celko explains one method of representing trees in SQL.
July 30,
2008
Today Views:
1 Total Views:
75
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.
July 29,
2008
Today Views:
2 Total Views:
94
Developers often write open source software in public, but what about developers who write about open source software? Do they build tools? How do your favorite books come about?
July 28,
2008
Today Views:
1 Total Views:
70
A new MySQL storage engine allows you to use tables in remote servers as if they were local. Unfortunately, the documentation doesn't explain much more than that.
July 25,
2008
Today Views:
2 Total Views:
65
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.
July 21,
2008
Today Views:
5 Total Views:
53
Managing a database by hand with command-line tools is possible, but it can also be tedious. Some web-based administrative tools are good, but there are advantages to graphical desktop applications, as well.
July 17,
2008
Today Views:
1 Total Views:
63
