How to Read and Select Data in PHP MySQL
by TechVidvan Team
Program 1
<html>
<body>
<center>
<pre>
<?php
$servername="localhost";
$username="root";
$password="";
$dbname="Library";
$mycon=mysqli_connect($servername,$username,$password,$dbname);
if($mycon->connect_error)
die("Connection failed....");
else
{
echo "Connection success......";
$sql="select * from student";
// mysqli_query($mycon,$sql);
$record=$mycon->query($sql);
if(mysqli_num_rows($record)>0)
{
// print_r($record);
echo "<br>";
while($row=mysqli_fetch_assoc($record))
{
echo $row['sid']." ".$row['sname']." ".$row['course']."<br>";
}
}
else
echo "No Record found";
}
?>
</pre>
</center>
</body>
</html>
Tags: how to read and select data in php mysqlPHPphp mysql select dataphp practicalphp programselect data in php mysql
TechVidvan Team
TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.
