| Server IP : 172.64.80.1 / Your IP : 172.70.127.234 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admin_student/siwes/ |
Upload File : |
<?php
session_start();
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
extract($_POST);
$db=db_connect();
$eAddress = str_replace("'", "''", $eAddress);
$placementName = str_replace("'", "''", $placementName);
$companyName = str_replace("'", "''", $companyName);
//$pass1=md5($pass1);
$sql_aa = "INSERT INTO `fedpoly`.`siwesbiodata` (`sn`, `matNo`, `fromYear`, `toYear`, `bankName`, `AccountNo`, `eAddress`, `eeMail`, `ePhoneNo`, `nationality`, `placementName`, `companyName`)
VALUES (NULL, '$matNo', '$fromY', '$toY', '$bankName', '$acctNo', '$eAddress', '$eeMail', '$ePhoneNo', '$nationality', '$placementName','$companyName')";
$sql_a=$db->query($sql_aa);
// $result = mysql_query($sql);
if ($sql_a) {
header('location:siwesBiodata.php?id=2');
}else {
$sql_bb = "UPDATE `fedpoly`.`siwesbiodata` SET `fromYear` = '$fromY', `toYear` = '$toY', `bankName` = '$bankName', `AccountNo` = '$acctNo', `eAddress` = '$eAddress', `eeMail` = '$eeMail', `ePhoneNo` = '$ePhoneNo', `nationality` = '$nationality', `placementName` = '$placementName',`companyName` = '$companyName' WHERE `siwesbiodata`.`matNo` = '$matNo'";
$sql_b=$db->query($sql_bb);
if ($sql_b) {
header('location:siwesBiodata.php?id=1');
//echo $matNo;
}else{
header('location:siwesBiodata.php?id=3');
}
}
?>