1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<?php require("configure.php"); ?> <? $newsid = $_POST["newsid"]; //$newstitle = $_POST["newstitle"]; $newstitle = htmlspecialchars($_POST["newstitle"],ENT_QUOTES); //$newsdate = $_POST["newsdate"]; $newsdate = htmlspecialchars($_POST["newsdate"],ENT_QUOTES); //$newsdesc = $_POST["newsdesc"]; $newsdesc = preg_replace("/'/","\'",$_POST["newsdesc"]);
$sql = "select max(newsid) as maxid "; $sql .= "from news"; $result=mysql_query($sql); $row = mysql_fetch_array($result,MYSQL_ASSOC); $newsid = $row{maxid}+1;
$sql = "insert into news (newsid, newsdate, newsdesc, newstitle) values ('$newsid', '$newsdate', '$newsdesc', '$newstitle')"; //echo $sql; mysql_query($sql); mysql_close($dbh);
header("Location: newsindex.php?msg=Add Successful"); ?>
|