Scripts are listed afer popularity. To display the scripts in alphabetical order please click here
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Random MySQL result-set
This is an easy to learn database related tutorial which teaches you how to produce a result set of random rows from a table. The only thing is that you have to initialize the variables at the beginning of the script.
Multicolumn Output from a Database with PHP
Multicolumn Output from a Database with PHP is a tutorial which teaches displaying multicolumn output results from a database with using some PHP code function.
Formatting Date/Time value
Formatting date/time value is an article showing the date and time functions of MySQL assuming that you have the common date/time data storing format ie-Time stamp column in the table. The author differentiate the use of PHP and MySQL functions and gives examples.
Count and display the number of rows in a mysql database table
This tutorial code helps to count the amount of entries or records in a MySQL database table and outputs the total number of records.
ODBC Socket Server
This tutorial teaches about complete configuration of your machines for ODBC socket server which can MS Access and PHP work together. The author finds the alternative for ODBC bridge and easysoft as ODBC socket server.
Alternating Row Colors
This simple tutorial tell the readers how to alternate the colour of the rows in a table, it also discusses on how to create a table and connecting the database.
PHP4 Session Handler using ADODB
PHP4 Session Handler using ADODB is a tutorial that teaches the users how to handle sessions with ADODB by using php4. This article is useful for the beginners and webmasters.
Preparation for using LDAP to SQL
Preparation for using LDAP to SQL is a tutorial for getting relational data from a hierarchical structure. The author used PHP for tackling this difficulty to query and provide snap shots regularly.
Slash 'em: The War Against Magic Quotes
Slash 'em: The War Against Magic Quotes is an article which helps you write codes which will work on any web server inspite of any type of configuration.
Database connection in a class of its own
Database connection in a class of its own is a tutorial that discusses about the usage of basic object-oriented techniques which reduces the difficulties of connecting and interacting with a database.
Admin user interface: adding and deleting users
Admin user interface: adding and deleting users is a tutorial that tells the users how to add and delete users with admin interface by using php.
SQL execution time
SQL execution time is a tutorial that explains how to show overall time spent for executing PHP code and the time spent for executing SQL queries and show the percentage of time overall for MySQL only. The author gives some codes and functions for doing this.
Creating dynamic Web sites with PHP and MySQL
Creating dynamic Web sites with PHP and MySQL is a tutorial aimed at developers who are new to PHP and MySQL. This narrates how to create dynamic websites with PHP and MySQL in a easy way.
Beginning MySQL Tutorial
Beginning MySQL Tutorial is an article which helps to know the basic operations of the MySQL server. This also teaches to set up the server for consequential manipulation and execute basic commands.
Tips on Writing Portable SQL Code
Tips on Writing Portable SQL Code is a tutorial which teaches the author's experiences with multiple database systems from Mac to the current oracle, Access, Foxpro, MySQL and MS SQL Server. The author focus on PHP and how ADODB gives the solution.
Script Web databases quickly with PHP scripting language
This is an article that discusses about PHP script and how it is flexible and works with databases like Informix, Microsoft SQL Server, mSQL, MySQL, ODBC, Oracle and Sybase. The author concludes that PHP is the ideal tool for handling databases in your Web development.
PHP MySQL Tutorial
PHP MySQL Tutorial is a lesson article about using PHP programming language and MySQL. It teaches how to make a guestbook, forms, and CMS.
PHPLIB and multiple databases
PHPLIB and multiple databases is a tutorial that teaches the users how to make an extension to PHPLIB and to access multiple databases by using php.
MySQL Table Joins
This article discusses about the join command of MySQL. This can develop access and modify data across various tables.
Microsoft Access Database ODBC and PHP
Microsoft Access Database ODBC and PHP is a tutorial to know about the Microsoft Access Database ODBC and PHP and connections between PHP and ODBC. The author teaches for preparing databases and how to configure our ODBC sources with some codes and functions.
Building Next/Prev Buttons for Query Results
Building Next/Prev Buttons for Query Results is a tutorial which tells the users how to create next and previous buttons for query result by using php.
Accessing a Microsoft SQL Server database from PHP running under Linux
Accessing a Microsoft SQL Server database from PHP running under Linux is a tutorial that explains the users how to connect and access an ms SQL server from php installed on a unix box.
Displaying Data In a MySQL Database
It is an easy to learn tutorial in which the author discusses about the process of displaying the data in the database and the method of generating a table for database and the method of inserting data into the database table.
SQL Database Function Wrappers
SQL Database Function Wrappers is a tutorial that explains the users how to create functions that will eliminate some unwanted redundancy while transacting with database by using php.
PHP and Writing to MySQL Databases
This tutorial describes how to write PHP programmes to access MySQL databases with some code functions, examples and some sites for reference.
Access Granted is an article that explains the basics of popular MySQL database and MySQL grant tables which are an integral part of the server security system.
MySQL and PHP
In this article, the author describes how to access MySQL database using PHP and gives some code functions for illustrating the same.
The MySQL Grant Tables
The MySQL Grant Tables is an article that explains the process in which the MySQL server accepts or cancells the user privileges, and highlights the newest five tables that provides this control.
Coding Ground - PHP and MySQL tutorial
Coding Ground - PHP and MySQL tutorial that provides users with the method of creating dynamic webpages using PHP and MySQL. Users are also provided with the details of creating databases and tables to recieve and store input data.
Oracle vs. MySQL: loading the data
This is an useful article that relates the efficiency of both Oracle and MySQL database in loading data from text files. This user guide brings out the advantages of MySQL database over the Oracle database.
Printing leaf items
Printing leaf items is an article which explains what is leaf items? how many leaf items are here? how to store informations in the tree structure using MySQL database with some simple programmes.
Using PHP with ODBC
From this article you can learn the usage of PHP's open database connectivity functions in getting connected with MS SQL server database to retrieve the necessary data.
Database Abstraction with PEAR
Database Abstraction with PEAR is a tutorial which teaches a method of coding that lets you to concentrate on coding and PEAR includes a database abstration class that you can use in your scripts. This article focus on PEAR for database abstration.
PHP with mySQL introduction
PHP with MySQL introduction is a tutorial that teaches basic MySQL interaction by making a link database. The author gives some simple code for this for easy understanding. This article is useful for new PHP programmers to understand what is happening while interaction.
ODBC with PHP: Tips and Hints on Windows
ODBC with PHP: Tips and Hints on Windows is a tutorial that teaches the users how to setup and handle ODBC from a PHP perspective.
Are PHP and MySQL the Perfect Couple?
Are PHP and MySQL the Perfect Couple? is a tutorial that teaches the users about the use of php and mysql. More tips are provided for the users to learn.
Browse Pages: 1