SQL In Simple English – Part I

2010-05-26T10:55:28+00:00 June 11th, 2005|MySQL|

This article explains the basics of SQL as a Q&A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful.

SQL In Simple English – Part II

2010-05-26T10:56:03+00:00 June 11th, 2005|MySQL|

This is the second article in this series. If you liked the first one, you will definitely like this one too. This article mainly deals with SQL Joins and SQL subqueries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.

Developing a Login System with PHP and MySQL

2010-05-26T11:02:05+00:00 May 31st, 2005|MySQL, PHP|

Most interactive websites nowadays would require a user to log in into the website’s system in order to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is tailored to the user’s preferences. A basic login system typically contains 3 components...

Showing MySQL Results in Pages

2010-05-26T11:33:17+00:00 April 19th, 2005|MySQL, PHP|

100 results on one page takes too long to load and can also look messy. Lets get started on putting your MySQL Database results on sepearte pages with PHP. I am assuming you have atleast a basic knowledge of PHP and MySQL because this is what you will need to know to understand this tutorial.

How To Backup Your MySQL Database With PHP

2010-05-26T11:38:49+00:00 April 9th, 2005|MySQL, PHP|

If your website some how gets hacked and you lose all your MySQL Database information, I doubt you would be laughing... or smiling... That's why you need to backup your database from time to time so that you can put it back the way it was. Here is a simple script using PHP and MySQL to backup your database!

Using PHP Objects to Access Your Database Tables (Part 2)

2010-05-26T11:39:39+00:00 April 7th, 2005|MySQL, PHP|

This is a follow-up to Using PHP Objects to access your Database Tables (Part 1) in which I showed you how to create a base class to contain all the standard code to access any database table, how to create extensions to this class for each individual table, and how to access these classes from within your PHP scripts.

Using PHP Objects to Access Your Database Tables (Part 1)

2010-05-26T11:39:53+00:00 April 5th, 2005|MySQL, PHP|

This tutorial is intended for developers who have already written code to get data in and out of a MySQL database, but who wish to discover if there are any benefits of adopting an Object Oriented approach. This tutorial will show you how to create an abstract class which can communicate with any database table, and then how to create subclasses containing the implementation details for each individual table within your application.