| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/onesolution.com.hk/support/ |
Upload File : |
<?php require("checkuser.php"); ?>
<?
$staffid = $_POST['staffid'];
$projectname = htmlspecialchars($_POST['projectname'], ENT_QUOTES);
$projectdesc = htmlspecialchars($_POST['projectdesc'], ENT_QUOTES);
$creationby = $_SESSION['userid'];
$creationdate = date("Ymdgis");
$updatedby = $_SESSION['userid'];
$updateddate = date("Ymdgis");
include("configure.php");
$sql = "insert into PM_PROJECT_HDR ";
$sql .= "(staffid, projectname, projectdesc, status, creationby, creationdate) ";
$sql .= "values ($staffid, '$projectname', '$projectdesc', 1, '$creationby', '$creationdate')";
echo $sql;
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
$sql = "SELECT max(projectid) as maxprojectid ";
$sql .= "FROM PM_PROJECT_HDR ";
$sql .= "where staffid = ". $staffid ." ";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$projectid = $row{'maxprojectid'};
}
header("Location: projectlist.php");
?>