Using PHP with MySQL

Quick and easy script on how to create a DB link and execute an sql statement

Creating an object oriented MySQL abstraction class

In this tutorial I will show you how you can create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how many query were executed during your PHP script.

Select random records from a MySQL database

Sometimes it could be very helpful to select a record from a table randomly. You can find such solution when you see random partners or randomly selected tutorials. This tutorial shows you how to select records randomly from a MySQL database.

Importing csv data into MySQL with php script

This tutorial will show you how to import csv data into MYSQL with a simple PHP script. Many times you have to write a script because the import function in phpMyAdmin will not import the way you want.

Counting records in PHP/mySQL

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.

How to create a database and an user in cPanel

This tutorial might seem pretty simple and obvious for many advanced webmasters, but some beginners might have some problems. And since I remember I was a bit stuck on this years ago too, why not make things clear for anyone? When do we need to do this? Everytime we install a forum or a CMS that requires an empty database being already created for the install process.

Backup all your databases with one click

This is a script usefull mostly to server admins, which will automatically detect all your mysql databases and backup/compress them.

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution

A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result fields.

Installing phpMyAdmin

This is a guide aimed at getting phpMyAdmin installed on your server in very little time. It covers all the basics, and should get phpMyAdmin running on most servers.

PHP Database Integration With MySQL

One of the defining features of PHP is the versatility it offers for connection to, and manipulation with, databases. In this article, we look at some features of the PHP and MySQL combination. We shall go through the following steps:- Connect to MySQL Database Server Create new Database Select MySQL Database Add data to table Retrieve data Error Handling