Program 1
<html>
<body>
<center>
<pre>
<?php
$mycon=$mycon=mysqli_connect("localhost","root","","Library") or die("Connection not success");
$sql="select * from studentdata";
$record=$mycon->query($sql);
$n=mysqli_num_rows($record);
//echo "Total Record: ".$n;
echo "Using Array Function<br>";
//$row=mysqli_fetch_array($record,MYSQLI_ASSOC);
// $row=mysqli_fetch_array($record,MYSQLI_NUM);
// $row=mysqli_fetch_array($record,MYSQLI_BOTH);
$row=mysqli_fetch_array($record);
print_r($row);
echo $row[0]." ".$row[1]." ".$row[2]." ".$row[3]." ".$row[4];
echo $row['sid']." ".$row['sname']." ".$row['phy']." ".$row['chem']." ".$row['math'];
//mysqli_fetch_assoc()
// mysqli_fetch_row()
// mysqli_fetch_array()
// mysqli_fetch_all()
// mysqli_fetch_field()
// echo "Using Index<br>";
// echo $row[0]." ".$row[1]." ".$row[2]." ".$row[3]." ".$row[4];
// echo "<br>";
// echo "Using Column Name<br>";
// echo $row['sid']." ".$row['sname']." ".$row['phy']." ".$row['chem']." ".$row['math'];
// if($n>0)
// {
// while($row=mysqli_fetch_array($record))
// {
// //echo $row[0]." ".$row[1]." ".$row[2]." ".$row[3]." ".$row[4];
// echo $row['sid']." ".$row['sname']." ".$row['phy']." ".$row['chem']." ".$row['math'];
// echo "<br>";
// }
// }
// else
// echo "<font color=red size=5>No Record found</font>";
$mycon->close();
?>
</tr>
</pre>
</center>
</body>
</html>
