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
26
27
28
29

<?php require("configure.php"); ?>
<?
$faqid                = $_POST["faqid"];
//$faqques            = $_POST["faqques"];
$faqques            = htmlspecialchars($_POST["faqques"],ENT_QUOTES);
//$faqansw            = $_POST["faqansw"];
//$faqansw            = str_replace("'", "\'",$faqansw);
$faqansw             = preg_replace("/'/","\'",$_POST["faqansw"]);
$status                = $_POST["status"];
//$faqquestc            = $_POST["faqquestc"];
$faqquestc            = htmlspecialchars($_POST["faqquestc"],ENT_QUOTES);
//$faqanswtc            = $_POST["faqanswtc"];
//$faqanswtc            = str_replace("'", "\'",$faqanswtc);
$faqanswtc             = preg_replace("/'/","\'",$_POST["faqanswtc"]);


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

$sql = "insert into faq (faqid, faqques, faqansw, status, faqquestc, faqanswtc) values ('$faqid', '$faqques', '$faqansw', '$status', '$faqquestc', '$faqanswtc')";
//echo $sql;
mysql_query($sql);
mysql_close($dbh);

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