Most Popular Scripts | PHP | Tutorials & Tips | Database-Related

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!

Mysql provide blob type for storing data, if you looking a way to export your blob data into a file (picture) maybe this tutorial will help.

In this tutorial I will show you how you can create a simple PHP script to execute MySQL batch files.

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

This article provides tutorial notes on connecting PHP scripts to MySQl servers. Topics include creating database connection objects; executing INSERT INTO, SELECT, and UPDATE statements from PHP scripts.

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema.

A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.

A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.

If you are the root user then it will display all the databases on the server, but if your not the root user then it will show all the databases that your user has permissions for. It's a really fun to play around with and can be expanded in a variety of ways. It's explained in the comments.

This tutorial will explain the basics of core databases in SQL without complicating with mySQL. Will show you the how to create and view databases in the system and how to create and run sql scripts in the monitor and phpMyAdmin further tutorials will go into the basics of tables following with advanced tutorials.

This is a small tutorial detailing how to connect to mySQL. It is easy to follow and can be pulled right of the site. Ideal for newcomers to PHP that want to look at connecting to databases.

This is the Full chapter 6 from the recently published book 'Mastering phpMyAdmin for Effective MySQL Management'. The Chapter 'Changing Table Structure' give a great step by step guide with diagrams. Publshed in HTML for your enjoyment.

This tutorial will teach you how to deal with special characters like HTML tags, white space etc. from a user submitted form and database output.

This article will briefly describe how to compile PHP with ORACLE 8i support. The author writes "when i try to compile php with oracle support on Solaris 2.6 i got lots of problems. after tedious search in internet i have found solution. I have following configuration: ORACLE 8.1.6; PHP 4.0.6; Apache 1.3.19 (Already Installed)."

PEAR's DB classes are one of the database abstraction layers. This article takes a look at some traditional database access methods and then compare them with the method employed by PEAR.

This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input.

In this Part 2 of the article "Building Next/Prev Buttons for Query Results," you will be shown a sample code designed to work in most instances (with minor changes).

This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.

Many devs using MySQL have fallen in love with PHP. Jason Gilmore explains why they're the perfect couple. This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.