select in php using mysql | Sharp Tutorial

PHP Introduction

Working with Forms

PHP with MySQl

Advanced PHP

Object Oriented PHP

select from mysql using php

Using PHP we can fetch data from database by firing select query. To display the selected data we will use html table here, the database connection will be created like as before examples.

PHP page to get data from database and display in html table

 <html>
 <body bgcolor="gray">
 <center>
 <table style="width:80%; background-color:yellow;" border="5">
 <th>Roll No</th>
 <th>Name</th>
 <th>Course</th>
 <?php

  $host="localhost";
  $dbuser = "root";
  $password = ""; // change password as per your database.
  $dbname=     "sharp_tutorial";
  $conn = mysqli_connect($host, $dbuser, $password,$dbname);
  $query=" select * from student ";
  $data=mysqli_query($conn,$query);
  if(mysqli_num_rows($data) > 0) {
   while($row= mysqli_fetch_assoc($data)) {
   echo"<tr>";
   echo "<td>". $row['rollNo']. "</td>";
   echo "<td>". $row['sname']. "</td>";
   echo "<td>". $row['course']. "</td>";
   echo"</tr>";
  }
}
?>
</table>
<center></body>
</html>

Above program Displays the all records from student table as following to filter the records where clause can be used.

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

select from mysql using php

PHP page to get data from database and display in html table

Video/ C Introduction