1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

<?php require("configure.php"); ?>
<?
$archivedate        = $_POST["archivedate"];

//$archivedescen        = $_POST["archivedescen"];
$archivedescen     = preg_replace("/'/","\'",$_POST["archivedescen"]);
//$archivedesctc        = $_POST["archivedesctc"];
$archivedesctc     = preg_replace("/'/","\'",$_POST["archivedesctc"]);
//$archivedescsc        = $_POST["archivedescsc"];
$archivedescsc     = preg_replace("/'/","\'",$_POST["archivedescsc"]);


$sql = "select max(archiveid) as maxid ";
$sql .= "from archive";
$result=mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$archiveid = $row{maxid}+1;

$sql = "insert into archive (archiveid, archivedate, archivestatus, archivedescen, archivedesctc, archivedescsc) values ('$archiveid', '$archivedate', '1', '$archivedescen', '$archivedesctc', '$archivedescsc')";
//echo $sql;
mysql_query($sql);
mysql_close($dbh);

header("Location: archiveindex.php?msg=Add Successful");
?>