<?php
require_once('connect.php');
$db=db_connect();
$cardGet=$db->query("SELECT * FROM ossce_admitted WHERE formNo IN (SELECT regNo FROM ossce_remitaorder WHERE `transApproved` = 'True' AND `paymentType` = 'Acceptance Fee' AND regNo NOT IN (SELECT `formNo` FROM `ossce_realdata`))");
  $numGet=$cardGet->rowCount();

 $i=0;
$kk=0;
//echo $numGet;
//die();
			   if ($numGet>0){

				    while ($row=$cardGet->fetch(PDO::FETCH_BOTH)){
                         $matNo=$row['formNo'];
                        echo '<br>';

                        //if ($k>0) {
                            $cardGet1 = $db->query("select * from ossce_stddata where formNo='$matNo' or jambNo='$matNo'");
                            $cardGet1_fetch = $cardGet1->fetch(PDO::FETCH_BOTH);
                         $cardGet1_num=$cardGet1->rowCount();

                            if ($cardGet1->rowCount() > 0) {

                                $admittedGet = $db->query("select * from ossce_admitted where formNo='$matNo'");
                                $admittedGet_fetch = $admittedGet->fetch(PDO::FETCH_BOTH);
                                if ($admittedGet->rowCount() > 0) {
                                    echo $row['formNo'] . '==>';
                                    echo $names = $cardGet1_fetch['surname'] . ' ' . $cardGet1_fetch['otherNames'];
                                    $names = str_replace("'", "''", $names);
                                    $course = $admittedGet_fetch['course'];
                                    $levelID = $row['levelID'];
                                    $address = $cardGet1_fetch['address'];
                                    $address = str_replace("'", "''", $address);
                                    $state = $cardGet1_fetch['state'];
                                    $lga = $cardGet1_fetch['lga'];
                                    $email = $cardGet1_fetch['email'];
                                    $gsm = $cardGet1_fetch['gsm'];
                                    $ausername = $row['formNo'];
                                    $apassword = $row['formNo'];
                                    $mode = $row['mode'];
                                    $dob = $cardGet1_fetch['dob'];
                                    $sex = $cardGet1_fetch['sex'];

                                    $tt="INSERT INTO `fedpoly`.`ossce_realdata` (`sn`, `formNo`, `matNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `dob`, `gsm`, `sex`, `address`, `email`, `usernamea`, `passworda`, `fresher`) VALUES (NULL, '$matNo', '$matNo', '$names', '$course', '$levelID', '$mode', '$state', '$lga', '$dob', '$gsm', '$sex', '$address', '$email', '$matNo', '$matNo', '5')";

                                     $hh = $db->query($tt);
                                    if ($hh) {
                                        $kk += 1;
                                    }
                                }
                            }else{
                                echo $matNo.'==>'.$row['course'].'==>'.$row['names'].'==>Not in Student data';
                            }



++$i;
					}
}
echo '<br>'.$numGet.'Records Seen<br>';
echo '<br>'.$kk.'Records Moved';
?>