<?php

include('headMain.php');
?>
<table width="100%" cellspacing="5" cellpadding="3">
          <tr>
            <td align="center"><!-- InstanceBeginEditable name="EditRegion3" -->
      <?php
		 if (isset($_SESSION['sName'] )){
			echo 'The Admin user Editing is: '.$_SESSION['sName'];
			echo'<br />';
			require_once('../connect.php');
			if(isset($_GET['formEmail'])){
			$changeEmail = $_GET['formEmail'];
			$changeFormNo = $_GET['formNo'];
			$sql = "SELECT * FROM realdata WHERE email='$changeEmail' and formNo='$changeFormNo'";
			$result = $db->query($sql);
			$num = $result->rowCount();
                $result_fetch=$result->fetch(PDO::FETCH_BOTH);
				if ($num=1){
                   echo  $pNum=$result_fetch['usernamea'];
                   echo  $pNum=$result_fetch['formNo'];
//                    die();
					echo '<p style="font-weight:bold">'.$result_fetch['names'].'</p>';
					echo '<p style="font-weight:bold">'.$result_fetch['email'].'</p>';
					echo '<p style="font-weight:bold">TYPE THE CORRECT NAMES BELOW:  </p>';
				?>
					<form action="changeName_process.php?ch_name=<?php echo $result_fetch['names']?>" method="post">
						<input type="text" name="new_name" required="required" id="txtRound" size="200" value="<?php echo $result_fetch['names'];?>"/>
						<input type="submit" name="button" id="button" value="Change"/>
				      <input type="hidden" name="hEmail" id="hEmail" value="<?php echo $changeEmail ;?>" />
				      <input type="hidden" name="formNoChange" id="formNoChange" value="<?php echo $changeFormNo;?>" />
					</form>
				<?php }
			}
			if(isset($_GET['ch_name'])){
				$formEmail= $_POST['hEmail'];
				$formNoChange= $_POST['formNoChange'];
//                $formNo=$_GET['formNo'];
                $names=$_POST['new_name'];
                $names=str_replace("'","''",$names);
				$oldnames=$_GET['ch_name'];
				echo 'The Names of the Candidate '.$oldnames.' has been changed to : ';
//				$sqla = "UPDATE stddata SET names = '$names' WHERE formNo = '$formNo'";
				$sqla = "UPDATE stddata SET names = '$names' WHERE email = '$formEmail' and formNo='$formNoChange'";
				$resulta = $db->query($sqla);
//				$sqlb = "UPDATE realdata SET names = '$names' WHERE formNo = '$formNo'";
			echo	$sqlb = "UPDATE realdata SET names = '$names' WHERE email = '$formEmail' and formNo='$formNoChange'";
				//echo $formNo;
				$resultb = $db->query($sqlb);

                //================================Consultant tables======================
                $dbC = db_con_connect();
                $array = explode(" ", $names);
                    $name0=$array[0];
                    $name1=$array[1];

                if ($array[2]<>''){
                    $name2=$array[2];
                }
                else{
                    $name2=$array[2];
                }
               echo  $sqlc = "UPDATE stdprofile SET names = '$names', surname='$name0', firstname='$name1', othername='$name2' WHERE email = '$formEmail' and stdid='$pNum'";
                $asp_che = $dbC->query($sqlc);
               echo $sqld="UPDATE payment_log SET candname='$names' WHERE stdid='$pNum'";
                $asp_ched = $dbC->query($sqld);

                die();
                //============================End Consultant Tables=========================

				echo $names;
				echo '<br />
				<a href="nameUpdate.php">Back...</a>';
			}
		}else{
			echo 'Un-Authorized Access....';
			
		}

	  ?>

		<br />
<a href="logout.php">Log Out </a>
<!-- InstanceEndEditable --></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>