Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
A Gentle Introduction to SQL
August 28, 2006 at 4:44 pm (access, db2, mimer, mysql, oracle, postgresql, sql, sqlite, sqlserver)
How (Not) To: MySQL Connection Management in PHP
August 14, 2006 at 5:57 pm (howto, mysql, php)
This article is intended to highlight various basic topics concerning proper methods of handling connections to MySQL databases in PHP, guidelines for caching dynamic content, and a technique called “lazy loading”.
Creating a Membership System with PHP and MySQL
June 23, 2006 at 5:00 pm (membership system, mysql, php)
Nice tutorial on using PHP and MySQL to create a user based login system for your website.
Password hashing using PHP and MySQL
June 14, 2006 at 11:58 pm (coldcase, mysql, password, php)
This article will explain what a hash is, why you want to use them instead of storing real passwords in your applications, and give you some examples of how to implement password hashing in PHP and MySQL.
Simple Optimization for PHP and MySQL
June 14, 2006 at 11:51 pm (coldcase, mysql, optimization, php)
Here is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing to survive the digg-effect.
How to: Apache/Perl/MySQL/PHP for windows
June 14, 2006 at 12:29 pm (apache, coldcase, howto, mysql, perl, php, tutorial)
Excellent tutorial on how to set up Apache Perl MySQL and PHP working and talking to each other on Windows. Step by step easy to follow instructions.
Creating a MySQL connection with PHP/AJAX
June 14, 2006 at 12:28 pm (ajax, coldcase, mysql, php)
The first article in a series of articles leading to the development of a fully functional dynamic web events application using AJAX/PHP/MYSQL.
PHP and MySQL coding tips — Basic Fundamentals
June 14, 2006 at 2:12 am (digg, mysql, php)
I thought it would be good to create a thread with a lot of my common PHP and MySQL coding tips that I mention in other topics on here all the time. These are valuable things that I've learned during 1 year with PHP and MySQL. I believe these are good do's and don'ts, that most experienced coders would agree with, and not just my opinions.


