Tutorials by ONLamp.com
PHP makes handling interactive web pages easy--but when you have large forms to fill out, errors to handle, and lots of data to pass back and forth, you can make your life easier by making PHP fill in all the form values for you.
May 13,
2010
Today Views:
1 Total Views:
815
We've spent a fair amount of time discussing how to get data out of MySQL. But can you enter data directly into this database? You can using the INSERT command.
April 21,
2010
Today Views:
2 Total Views:
1,136
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...
April 14,
2010
Today Views:
1 Total Views:
1,167
SQL databases can be filtered by virtually any set of criteria using a single clause. This week, John Paul Ashenfelter shows us how to use the SELECT command to return subsets of data.
April 8,
2010
Today Views:
2 Total Views:
879
John Paul Ashenfelter looks at a specific class of SQL functions that operate on entire columns of data instead of discrete values -- the aggregate functions.
March 18,
2010
Today Views:
1 Total Views:
754
Quick--what's the relationship between the columns of your database? Don't know? Maybe it's time to pull out the information theory book and calculate how much data they store.
March 10,
2010
Today Views:
2 Total Views:
1,037
John Paul Ashenfelter looks at how keys are used to construct relationships between tables in a relational database.
March 9,
2010
Today Views:
1 Total Views:
992
Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means.
March 5,
2010
Today Views:
1 Total Views:
1,111
Luminaries from the open source communities of Perl, Python, PHP, MySQL, Apache, and Linux each presented their take on the current state of their technology and where it is headed.
February 26,
2010
Today Views:
1 Total Views:
1,067
This tutorial explains the basics of setting up OpenBSD as a database server using MySQL/PostgreSQL and PHP.
February 25,
2010
Today Views:
2 Total Views:
1,049
