PHP mysqli_fetch_array() Function Part – 2
by TechVidvan Team
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'];
Tags: mysqli_fetch_array() functionmysqli_fetch_array() function in phpPHPphp mysqli_fetch_array() functionphp practicalphp program
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.
