Top Rated Scripts | PHP | Tutorials & Tips | Database-Related

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 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 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.

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.

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.

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 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.

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.

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.

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

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

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.

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!

PHP supports MySQL prepared statements using the Mysqli (MySQL Improved) extension in PHP 5 via the MySQLi_STMT class. They are fairly easy to use once you get used to the differences from writing raw SQL statements. This tutorial will explain how to use prepared statements.

This tutorial covers the basics of accessing a MySQL database from your PHP script. You will learn how to connect to a MySQL database, and how to execute a SQL statement. The example code will output an HTML table containing the contents of a table in the database.

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem.

This article demonstrates how to concatenate two or more strings and fields in MySQL using the CONCAT() function.

This is a spelling checking script written in PHP/MySQL. It asks the user to input an English word and checks if the spelling is correct. If the spelling is not correct, it offers different suggestions of similar words.

MongoDB is an open source NoSQL database system. Tutorial presents introduction to MongoDB. Free lesson describe how to use document-oriented database system: how to insert, select, update and delete data, use Set and Unset operators.

SQL tutorial video presents the use of aggregate functions: MIN, MAX, AVG, SUM, COUNT, DISTINCT. Free lesson with practical examples describe how to group data using GROUP BY and HAVING clauses.