PDA

Click to See Complete Forum and Search --> : Connect to MySQL Database


Killsoft69
May 4th, 2008, 01:16 PM
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
May 4th, 2008, 02:03 PM
Welcome to The Forum & Have a look Here (http://www.vbforums.com/forumdisplay.php?f=82)

Thanks !

dclamp
May 4th, 2008, 03:06 PM
:wave: welcome to vbf! We have lots of examples of MySQL code here on the forums.

Killsoft69
May 5th, 2008, 10:33 AM
> 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. :blush: