Reader Level:
Articles

Select Statement With PHP Script

By Deepak Dwij on January 08, 2012
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.
  • 0
  • 0
  • 6048

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 !

Article Extensions
Contents added by non lor on Sep 04, 2012
Contents added by rinkal patel on Jul 03, 2012
Deepak Dwij

Patience creates a creativity in itself & time to achieve your desired goals. I m very much passionate about playing cricket !!!

COMMENT USING

Trending up