A Gentle Introduction to SQL

Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.

read more | digg story

How (Not) To: MySQL Connection Management in 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”.

read more | digg story

Creating a Membership System with PHP and MySQL

Nice tutorial on using PHP and MySQL to create a user based login system for your website.

read more | digg story

Password hashing using PHP and MySQL

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.

read more | digg story

Simple Optimization for PHP and MySQL

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.

read more | digg story

How to: Apache/Perl/MySQL/PHP for windows

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.

read more | digg story

Creating a MySQL connection with PHP/AJAX

The first article in a series of articles leading to the development of a fully functional dynamic web events application using AJAX/PHP/MYSQL.

read more | digg story

PHP and MySQL coding tips — Basic Fundamentals

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. 🙂

read more | digg story