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
|
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
header("Location: login.php");
exit;
}
foreach ($arraylangcode as $langcode => $langname) {
$content[$langcode] = preg_replace("/'/", "\'", $_POST["content_".$langcode]);
$content[$langcode] = str_replace("<br />","",$content[$langcode]);
}
$sql2 = "update rolling_text set sort = sort + 1 where deleted = ?";
if (!($sth2 = $dbh->prepare($sql2))) {
throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
}
if (!$sth2->execute(array("0"))) {
throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
}
$sql = "insert into rolling_text (content_en, content_tc, content_sc, sort, createdate, createby, lastupdate, lastupby) values (?, ?, ?, ?, ?, ?, ?, ?)";
if (!($sth = $dbh->prepare($sql))) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
$parameters = array($content["en"], $content["tc"], $content["sc"], "1", $nowdate, $_SESSION['cmsloginid'], $nowdate, $_SESSION['cmsloginid']);
if (!$sth->execute($parameters)) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
$dbh = null;
header("Location: rolling_text_index.php?msg=新增成功");
?>
|