PHP Code to Connect Mysql Database

Php mysql connectivity code.............


Write below code in connect.php file


<?Php
ob_start();
$host="localhost:3307"; // Host name
$username="root"; // Mysql username
$password="sa"; // Mysql password
$db_name="dbname"; // Database name
$tbl_name="login"; // Table name
?>

include your connect file in page


include ("config.php");
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

execute your query

$quer2=mysql_query("SELECT * FROM village");
$noticia2 = mysql_fetch_array($quer2);

and that's it .....
www.indbricks.com