If you want to fetch records from the database then use SELECT statement. In this example, we have used existing database "php_mysql" and "user" database table for select record.
PHP MySQL Fetch Data Example:
If you want to fetch records from the database then use SELECT statement. In this example, we have used existing database "php_mysql" and "user" database table for select record.
Example:
<?php $connection = mysql_connect("localhost", "root", "root"); if (!$connection) { die('PHP Mysql database connection could not connect : ' . mysql_error()); } else{ $db_name = "php_mysql"; mysql_select_db($db_name, $connection); $sql = "select * from user;"; $records = mysql_query($sql, $connection); while($rows = mysql_fetch_array($records)){ echo "User Id : " . $rows['user_id'] . "<br />"; echo "User Name : " . $rows['user_name'] . "<br />"; echo "User Email : " . $rows['user_email'] . "<br />"; echo "User Address : " . $rows['user_address'] . "<br /><br /><br />"; } } mysql_close($connection); ?>
After running this example the output is:
output:
User Id : 1 User Name : brijesh User Email : brijesh@gmail.com User Address : Delhi
[ 0 ] Comments