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.
Version: 2.00 Platform(s): n/a Updated: Thu Nov 8 2007
MySQL is a very powerful language. Coupled with PHP you can do just about anything you want. This tutorial here will cover "INSERT", "SELECT", "DELETE", "UPDATE" and "RAND".
Version: 1.0 Platform(s): linux, windows Updated: Wed Nov 14 2007
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.
Version: n/a Platform(s): n/a Updated: Sun Feb 18 2007
If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.
Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Thu Jan 25 2007
A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable.
Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Thu Jan 11 2007
If you're using different databases and remote sites to test and/or install scripts. Here is a little class which can prevent some troubles. When connecting a remote mysql_server, it reads a file where all connection items such as host, user.. are stored.
Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Thu Jan 11 2007
This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query.
Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Tue Oct 17 2006
Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN.
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.
This comprehensive mysql tutorials touches on Starting a Session with MySQL,Executing SQL Statements against a MySQL database and demonstrating how a SELECT SQL statement is executed against the selected database. features full code and examples.
Version: n/a Platform(s): linux, windows Updated: Fri Feb 3 2006
Ever see the little errors of unable to find a file that is stored in mysql? Well you can use this tutorial to add a little message so the viewers know whats going on.
Version: 1.0.1 Platform(s): linux Updated: Thu Jun 9 2005
In this tutorial, Timothy shows you how to get started using SQLite starting with how to obtain it and install it and progressing through example usage.
This tutorial shows how to store data into a MySQL database and then retrieve it by using a PHP query. This wil teach you the basics behind the use of PHP with databases.
A VERY good tutorial for beginners who are interested in learning the language quickly.
Version: n/a Platform(s): n/a Updated: Mon May 9 2005
So you've written a great application with PHP and it is up and running smooth. Then, your boss calls and tells you that your company won't be using MySQL anymore. You're moving to Oracle. Your application is dead in the water. You should have used database abstraction.
