Forums

google php database tutorials. You will learn all you need to do a database over the web. You can also try http://www.lynda.com. They have video tutorials, but you will have to pay for them. You can also check the video section on this site. There might be some there

Lets say you have a database named testdb, with a username of admin and a password of admin1.
With the following PHP code, you can connect to the database, which is required if you want to add or delete stuff in it.

mysql_connect("localhost", "admin", "admin1") or die(mysql_error());

echo "Connection to MySQL established";

mysql_select_db("testdb") or die(mysql_error());

echo "Also connected to the testdb database";

?>

The following code will insert some stuff in the testdb database. Lets say that database has a table in it named tableone.

mysql_query("INSERT INTO tableone (city, country) VALUES('New York', 'USA' ) ") or die(mysql_error());

?>

This (city, country) code means stuff will be inserted in those columns, and the stuff will be ('New York', 'USA').

The line die(mysql_error()); means that it will the mysql error if there is any.

You can find some very handy information here: http://www.tizag.com/mysqlTutorial/

I would look into using a PDO method too – so add that to your search :D