CODE EXAMPLE FOR PHP

php if condition

if(mysqli_num_rows($query_run) > 0)
  {
    //$rowCount=mysqli_num_rows($query_run);
      //$spreadsheet = new Spreadsheet();
      //$sheet = $spreadsheet->getActiveSheet();
      $count=27;

      while($row = mysqli_fetch_array($query_run)){

        

        // echo  $row['hall'] ;
        // echo  $row['regno'] ;
        // echo  $row['session'] ;
        $sheet->setCellValue('A'.$count, $row['hall']);
        $sheet->setCellValue('B'.$count, $row['regno']);
        $sheet->setCellValue('C'.$count, $row['session']);
        $sheet->setCellValue('D'.$count, $row['classroll']);
        $sheet->setCellValue('E'.$count, $row['examroll']);
        $sheet->setCellValue('F'.$count, $row['name']);

        $count++;
      }