PHP 5 MYSQL select data from table
How to retrieve data from table
After inserting data into table we will use SELECT statement extract data from the table.
Syntax
SELECT * FROM table_name;
Another syntax
SELECT field1, field2... FROM student;
- You can specify one or more in a single SELECT statement.
- You can use * to retrieve all the field.
Complete example of SELECT data FROM table
<?php
$host = 'localhost';
$user = 'root';
$password = "";
$db_con = mysql_connect($host, $user, $password);
if($db_con)
{
echo "Connected successfully<br>";
}
else
{
echo "fail";
}
$b = mysql_select_db("my_db1");
$data = "select *from student";
$data1 = mysql_query($data,$db_con)or die(mysql_error());
while($row = mysql_fetch_array($data1))
{
echo "------------------------<br>";
echo $row['id']."<br>";
echo $row['name']."<br>";
echo $row['branch']."<br>";
echo "------------------------";
echo "<br>";
}
mysql_close();
?>
Output
Connected successfully
------------------------
1
Brown
Ece
------------------------
------------------------
2
xyz
ma
------------------------
------------------------
3
harry
cse
------------------------
------------------------
1
Brown
Ece
------------------------
------------------------
2
xyz
ma
------------------------
------------------------
3
harry
cse
------------------------
mysql_fetch_array() function is used to assign an entire row to an associative array by default. However, you can specify the type of array mapping (associative, numerically indexed).
Another example
<?php
$host = 'localhost';
$user = 'root';
$password = "";
$db_con = mysql_connect($host, $user, $password);
$b = mysql_select_db("my_db1");
$data = "select name, branch from student";
$data1 = mysql_query($data,$db_con)or die(mysql_error());
while($row = mysql_fetch_array($data1))
{
echo $row['name']."<br>";
echo "<br>"."<br>";
}
mysql_close();
?>
Explanation
$row is an array type variable that store the all the data of table, you can access data using field value as key as above shown in example.
