Connect to a mysql Database using php

[adam_uk]

<?

$username = "username";
$password ="password";
$db = "db";

$conn = mysql_connect("localhost", "$username", "$password") or die(mysql_error());

mysql_select_db("$db", $conn) or die (mysql_error());


?>

Once you have php,mysql working you can add this to a php file to use the database

you may also need other tools such as phpmyadmin www.phpmyadmin.net to help generate the mysql queries and make/delete/edit/change databases

 

[deadserious]

Nice one! That was a definite needed code snippet around here. ... Thanks for sharing. :D

 

[adam_uk]

surprised it wasnt already here

 

[Phoenix]

I am saving this page in my "Cool Sites" guide :D, cool reference if your in a hurry.