Connect to MySQL Database

[Killsoft69]

MySQL is a database that goes hand-in-hand with PHP.
This is for People here who dont know how to connect to MySQL.
You will need it in many PHP development situations.

<?php
 $dbserver = "localhost";
//if you do not know your database server then try localhost
//You can find information of your mysql database at the PhpMyAdmin Panel

 $dbusername = "dbusername";
 $dbname = "dbname";
 $dbpass = "dbpassword";

 $connect = mysql_connect($dbserver,$dbusername,$dbpass); //Connects
 $selectdb = mysql_select_db($dbname); \\Selects desired DataBase
 
 if(!$connect || !$selectdb){ //If one or both of the mysql functions fail
  die("Cannot connect: " . mysql_error()); //Display error
 }
else{ //If no errors occur
  echo "You have connected to a database!";
}
?>

HTML portion of webpage that uses MySQL data

<?php mysql_close(); //disconnect ?>

Hope this was helpful

[killer7k]

Welcome to The Forum & Have a look Here

Thanks !

[dclamp]

welcome to vbf! We have lots of examples of MySQL code here on the forums.

[Killsoft69]

> We have lots of examples of MySQL code here on the forums.

Yeah, I guess I should looked for tutorials on the same subject before I posted mine.