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
44
45
46
47
48
49
|
<?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"); $carlistid = htmlspecialchars($_POST["carlistid"],ENT_QUOTES); $carid = htmlspecialchars($_POST["carid"],ENT_QUOTES); $carlisttitleen = htmlspecialchars($_POST["carlisttitleen"],ENT_QUOTES); $carlisttitlesc = htmlspecialchars($_POST["carlisttitlesc"],ENT_QUOTES); $carlistdepen = htmlspecialchars($_POST["carlistdepen"],ENT_QUOTES); $carlistdepsc = htmlspecialchars($_POST["carlistdepsc"],ENT_QUOTES); $carlistworkplaceen = htmlspecialchars($_POST["carlistworkplaceen"],ENT_QUOTES); $carlistworkplacesc = htmlspecialchars($_POST["carlistworkplacesc"],ENT_QUOTES); $carlistnum = $_POST["carlistnum"]; $carlistreldate = htmlspecialchars($_POST["carlistreldate"],ENT_QUOTES); $carlistdescen = preg_replace("/'/","\'",$_POST["carlistdescen"]); $carlistdescsc = preg_replace("/'/","\'",$_POST["carlistdescsc"]); $carlistdegen = htmlspecialchars($_POST["carlistdegen"],ENT_QUOTES); $carlistdegsc = htmlspecialchars($_POST["carlistdegsc"],ENT_QUOTES); $carlistexpen = htmlspecialchars($_POST["carlistexpen"],ENT_QUOTES); $carlistexpsc = htmlspecialchars($_POST["carlistexpsc"],ENT_QUOTES); $carlistwagen = htmlspecialchars($_POST["carlistwagen"],ENT_QUOTES); $carlistwagsc = htmlspecialchars($_POST["carlistwagsc"],ENT_QUOTES); $carlistmailto = htmlspecialchars($_POST["carlistmailto"],ENT_QUOTES); $nowdate = date("Y-m-d H:i:s"); //print_r($_POST);
// Modify $sql = "update career_list set carlisttitleen='$carlisttitleen', carlisttitlesc='$carlisttitlesc', carlistdepen='$carlistdepen', carlistdepsc='$carlistdepsc', carlistworkplaceen='$carlistworkplaceen', carlistworkplacesc='$carlistworkplacesc', carlistnum='$carlistnum', carlistreldate='$carlistreldate', carlistdescen='$carlistdescen', carlistdescsc='$carlistdescsc', carlistdegen='$carlistdegen', carlistdegsc='$carlistdegsc', carlistexpen='$carlistexpen', carlistexpsc='$carlistexpsc', carlistwagen='$carlistwagen', carlistwagsc='$carlistwagsc', carlistmailto='$carlistmailto', modifyday='$nowdate', cmsloginid='".$_SESSION['cmsloginid']."' "; $sql .= " where carlistid=". $carlistid ." "; mysql_query($sql);
if( mysql_errno() > 0 ){ echo 'Modify 职位空缺项目 Error:<br />'. mysql_error() .'<br />SQL: '. $sql; exit; }
mysql_close($dbh);
header("Location: careerlist_index.php?carid=$carid&msg=修改成功"); ?>
|