Monday, November 14, 2011

Code to fetch data from Mysql




$hostname = "localhost";
$db_user = "root";
$db_password = "";
$database = "hinson";
$db_table = "info";
$conn=mysql_connect("$hostname", "$db_user", "$db_password") or die(mysql_error());
mysql_select_db($database,$conn) or die(mysql_error());


$sql="SELECT * FROM info WHERE (email = '$userid')";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);

$rows['username'] is the fetched username from database.
similarly you can use other fetched data.

inrows['username'] username is corresponding field name which you want to fetch.

No comments:

Post a Comment