<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 08/04/2017
 * Time: 9:36 AM
 */
$matNo=0;
$k=0;
$d=0;
require_once('../connect.php');
$db=db_connect();
$sql=$db->query("select * from biodata_2016_2017  where formNo<>'1'");
 //echo $sql_count=$sql->rowCount();

while ($row=$sql->fetch(PDO::FETCH_BOTH)) {
    $matNo = $row['matNo'];
  //  echo '==>';
     $dept=$row['course'];
   // echo '<hr>';

     $levelID=$row['levelID'];
$sql_all=$db->query("select * from coursereg where matNo='$matNo'");
    // $sql_all->rowCount().'____________';
while ($row_all=$sql_all->fetch(PDO::FETCH_BOTH)) {
     $courseTitle=$row_all['courseTitle'];
     $courseCode1=$row_all['courseCode'];
    $f=$levelID-1;
    $sql_code=$db->query("select * from coursepool where courseTitle='$courseTitle' and dept='$dept' and (levelID='$levelID' or levelID='$f') ");
    $sql_code_fetch=$sql_code->fetch(PDO::FETCH_BOTH);
    $courseCode=$sql_code_fetch['courseCode'];
    if ($courseCode==''){
        $courseCode='pending';
    }
  // $sql_update=False;
    if ($courseCode<>$courseCode1) {
echo $matNo;
        echo '==>';
        echo $dept;
        echo '==>';
        echo $courseTitle;
        echo '==>';
        echo $courseCode1;
        echo '==>';
        echo $courseCode;

      $sql_update=$db->query("UPDATE coursereg SET courseCode='$courseCode', status=1 where  matNo='$matNo' and courseTitle='$courseTitle'");
        $sql_update=$db->query("UPDATE biodata_2016_2017 SET formNo='1' where  matNo='$matNo'");
        if ($sql_update) {
            $d += 1;
        }
    }else{
       // $sql_update=$db->query("UPDATE coursereg SET  status=1 where courseCode=$courseCode1 and matNo='$matNo' and courseTitle='$courseTitle'");
        $sql_update=$db->query("UPDATE biodata_2016_2017 SET formNo='1' where  matNo='$matNo'");
    }
    echo '<br>';
}
    $k+=1;
    echo '<br>';
    if ($k==100){
        die('end');
    }

}
echo $k;
echo $d;
?>