$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