PHP Tutorials » PHP with MySQL

Categories

August 21, 2008
Reporting and handling errors in PHP

Classes and Object-Oriented Programming in PHP

PHP Image manipulation with GD2

An Introduction to PHP

August 20, 2008
Working with dates and times in PHP

PHP Syntax

Support this site

Place a link to The Rough Guide on your own webpage

Text link

Sponsored Links :

An introduction to MySQL with PHP

What is MySQL? What can I do with it?
Setting up and Connecting to MySQL with PHP

Setting up and Connecting to MySQL
Using PHPMyAdmin to manage your MySQL data

PHPMyAdmin - MySQL Administration Software
Column and Data Types in MySQL

Data formats in MySQL - VARCHAR, INT, BOOL etc.
Querying Information from MySQL Tables with SELECT

An introduction to MySQL Queries using PHP
Updating, Inserting and Deleting data with MySQL

Using MySQL's UPDATE, INSERT and DELETE keywords
Autoincrement and Table Indexes
Using Multiple MySQL Tables with Unique IDs, Joins and Normalization

Normalization using Unique IDs
Generating Reports using MySQL’s Aggregate Functions - Sum(), Max(), Min() and more

Aggregate functions and Statistical analysis
Creating a Simple Comments and Login System using MySQL and PHP

A simple, fully usable application!
Creating a secure login system, and deleting comments
Security Issues : Cleaning up User Data in MySQL

How to ensure your User Data remains "safe"