| Server IP : 172.64.80.1 / Your IP : 172.70.50.62 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/admin_main/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: adisa
* Date: 2016-03-24
* Time: 06:01 PM
*/
session_start();
$userLogin=$_SESSION['sName'];
extract($_POST);
require_once('../connect.php');
$db=db_connect();
if($fromTXT>$toTXT){
echo '<hr><div align="left"><a href="javascript:history.go(-1)"> Go to Previous page</a></div>';
die("Date From Cannot be Less than Date To<hr>");
}
$sql="select * from report_setting where username='$userLogin'";
$sql_exe=$db->query($sql);
$sql_count=$sql_exe->rowCount();
if ($sql_count==1) {
$aspoa = "UPDATE `report_setting` SET `from_v` = '$fromTXT',`to_v` = '$toTXT' WHERE `report_setting`.`username` = '$userLogin'";
//die($aspoa);
}else{
$aspoa="INSERT INTO `report_setting` (`sn`, `from_v`, `to_v`, `username`, `dateReg`) VALUES (NULL, '$fromTXT', '$toTXT', '$userLogin', CURRENT_TIMESTAMP)";
// die($aspoa);
}
$result = $db->query($aspoa);
if ($result){
header('location:'.'report_range.php?id=1');
}else{
header('location:'.'report_range.php?id=2');
}
?>