<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 11/11/2022
 * Time: 12:05
 */
$count1=$count2=$count3=0;
require_once('../connect.php');
$db = db_connect();
$adisa="select * from stddata where upload1=0";
$adisaSQL=$db->query($adisa);
while ($row1=$adisaSQL->fetch(PDO::FETCH_BOTH)) {
    $r1=$r2=$r3=0;
    $formNo = $row1['formNo'];
    $fileName1 = '../olevelScanned/' . $formNo . '_1.jpg';
    $fileName2 = '../olevelScanned/' . $formNo . '_2.jpg';
    $fileName3 = '../olevelScanned/' . $formNo . '_3.jpg';
    if (file_exists($fileName1)){
        $r1 = 1; $count1+=1;
    }
    if (file_exists($fileName2)){ $r2 = 1; $count2+=1;}
    if (file_exists($fileName3)) {$r3 = 1; $count3+=1;}

    $sql = "UPDATE `stddata` SET `upload1` = '$r1',`upload2` = '$r2',`upload3` = '$r3',`olvelcal`=1 WHERE formNo='$formNo'";
    $db->query($sql);
}

echo '<h2>SUMMARY</h2>';
echo $count1 .' O\'level 1 Uploaded Found<hr>';
echo $count2 .' O\'level 2 Uploaded Found<hr>';
echo $count3 .' National Diploma Uploaded Found<hr>';