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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<?php include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) { header("Location: login.php"); exit; } require("configure.php"); $menuid = htmlspecialchars($_POST["menuid"],ENT_QUOTES); $menutitleen = htmlspecialchars($_POST["menutitleen"],ENT_QUOTES); $seotitleen = htmlspecialchars($_POST["seotitleen"],ENT_QUOTES); $seodescen = htmlspecialchars($_POST["seodescen"],ENT_QUOTES); $seokeyen = htmlspecialchars($_POST["seokeyen"],ENT_QUOTES); $menutitletc = htmlspecialchars($_POST["menutitletc"],ENT_QUOTES); $seotitletc = htmlspecialchars($_POST["seotitletc"],ENT_QUOTES); $seodesctc = htmlspecialchars($_POST["seodesctc"],ENT_QUOTES); $seokeytc = htmlspecialchars($_POST["seokeytc"],ENT_QUOTES); $menutitlesc = htmlspecialchars($_POST["menutitlesc"],ENT_QUOTES); $seotitlesc = htmlspecialchars($_POST["seotitlesc"],ENT_QUOTES); $seodescsc = htmlspecialchars($_POST["seodescsc"],ENT_QUOTES); $seokeysc = htmlspecialchars($_POST["seokeysc"],ENT_QUOTES); $nowdate = date("Y-m-d H:i:s"); //print_r($_POST);
// Modify $sql = "update menu set menutitleen='$menutitleen', menutitletc='$menutitletc', menutitlesc='$menutitlesc', seotitleen='$seotitleen', seotitletc='$seotitletc', seotitlesc='$seotitlesc', seodescen='$seodescen', seodesctc='$seodesctc', seodescsc='$seodescsc', seokeyen='$seokeyen', seokeytc='$seokeytc', seokeysc='$seokeysc', modifyday='$nowdate', cmsloginid='".$_SESSION['cmsloginid']."' "; $sql .= " where menuid=". $menuid ." "; mysql_query($sql);
if( mysql_errno() > 0 ){ echo 'Modify Menu Error:<br />'. mysql_error() .'<br />SQL: '. $sql; exit; }
mysql_close($dbh);
header("Location: menu_index.php?msg=Modify Successful"); ?>
|