Introduction
Hi guys. In this article we are going to understand the database select
statement using PHP. The SELECT statement is used to select data from a
database.
Select Data From a Database Table
In this section we going to work with the select statement to fetch data
from the database.
Syntax
SELECT column_name(s) FROM table_name
PHP script for Fetching up data from table
<html>
<body
bgcolor="pink">
<center>
<h3>
Select data from database table PBL !
<h3>
<hr>
<?php
$con
= mysql_connect("localhost","root","");
if
(!$con)
{
die('Could
not connect: '
.
mysql_error());
}
mysql_select_db("dwij",
$con);
$result = mysql_query("SELECT
* FROM PBL");
while($row
= mysql_fetch_array($result))
{
echo
$row['FirstName']
. "
" .
$row['LastName'];
echo
"<br />";
}
mysql_close($con);
?>
</center>
</body>
</html>
Save it as select.php.
Output
To run the code, Open the XAMPP server and start the services like Apache and
MySQL. Open the browser type:
http://localhost/yourfoldername/select.php
![selct1.gif]()
Elaboration of the preceding script:
- The mysql_query() function stores the data returned in the $result variable.
- The mysql_fetch_array() function to return the first row from the recordset as an array.
- Each call to mysql_fetch_array() returns the next row in the recordset.
- To print the value of each row, we use the PHP $row variable ($row['FirstName'] and $row['LastName']).
Select data from database table PBL In HTML
Table
PHP Script
<html>
<body
bgcolor="pink">
<center>
<h3>
Select data from database table PBL In HTML Table!
<h3>
<hr>
<?php
$con
= mysql_connect("localhost","root","");
if
(!$con)
{
die('Could
not connect: '
.
mysql_error());
}
mysql_select_db("dwij",
$con);
$result = mysql_query("SELECT
* FROM PBL");
echo
"<table
border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row
= mysql_fetch_array($result))
{
echo
"<tr>";
echo
"<td>"
.
$row['FirstName']
.
"</td>";
echo
"<td>"
.
$row['LastName']
.
"</td>";
echo
"</tr>";
}
echo
"</table>";
mysql_close($con);
?>
</center>
</body>
</html>
Save it as
shtml.php.
Output
To run the code, Open the XAMPP server and start the services like Apache and
MySQL. Open the browser type:
http://localhost/yourfoldername/shtml.php
![selct2.gif]()
Thanks !