PHP mysqli_fetch_array() Function Part – 2

TechVidvan Team
2 years ago
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'];