Simple PHP MySQL Tutorial with examples like creating a guestbook, contact form, uploading files to database, creating a simple Content Management System (CMS), etc.
Top PHP scripts
1).
Using PHP to search a MySQL database and return paged results Using PHP to search a MySQL database and return paged results is an article for searching and getting results in a MySQL database content. The author gives some sample programmes for this. Knowledge of PHP and MySQL is a must.
2).
Sorting Database Results with PHP This tutorial describes how to show your data from a database and gives the user choice to sort the data by different columns. The author gives some PHP code functions for displaying this easily.
3).
Website Database Basics With PHP and MySQL Website Database Basics With PHP and MySQL is an article that gives solution for making your visitor to search for information on your website and also add to it. For this purpose, the author says that creation of database on a website is necessary.
4).
Creating Next / Previous Buttons with PHP and MySQL Creating Dynamic Next and Previous Buttons with PHP and MySQL is a tutorial that teaches the users how to create dynamic navigation links by using PHP and MySQL.
5).
Alternating row colors with PHP and mySQL Alternating row colors with PHP and mySQL is a tutorial which explains how to alternate table row colours using PHP and MySQL. The author gives some sample code functions for easy understanding.
6).
Static HTML Generation With PHP Static HTML Generation With PHP is a tutorial that teaches to create static html pages with some simple PHP scripts and makes your website run faster and minimize your MySQL
database queries drastically.
7).
Oracle and PHP Oracle and PHP is a tutorial that describes how to utilize the PHP built-in functions to work with an Oracle database with the assumption of Oracle and PHP are installed correctly.
New PHP scripts
1).
SQL Theory & How-To This tutorial discusses the two question ie- how do you build complex queries on the fly according to user input? and how to create powerful, complex queries to take advantages of your table schemas.
2).
So You Want to Use a Database in Your Site? This article discusses about how to use a database in your website. For this purpose, the author uses many sample codes and a simple SQL query interface for easy understanding.
3).
PHP Mysql Tutorial for Beginners Tutorial for beginners in php and mysql that will clearly show them the basics of working with mysql databases and php.
4).
PHP and Mysql for beginners PHP and Mysql for beginners is a tutorial that describes how to create database and adding tables and connecting to MySQL using PHP. This article is very useful for beginners to understand easily.
5).
Web Database Tutorial (PHP & MySQL) Web Database Tutorial (PHP & MySQL) is an article that teaches about the generation of web database programme using PHP and MySQL on a Unix platform or Mac OS X or Linux with the assumption of your system running with Apache web server. Some codes and functions are given for easy understanding.
6).
Uploading, Saving and Downloading Binary Data in a MySQL Database Uploading, Saving and Downloading Binary Data in a MySQL Database is a tutorial that teaches the users how to store binary files in a mySQL database by using php.
7).
Interfacing With MS Access 97 plus Interfacing With MS Access 97+ is a narration of creating an access database to use, setting up an ODBC connection and finally interfacing with database.
