<?php /* TODO: Add code here */ require_once '../lib/global.php'; $conn = new DbHelper("pg_newsclass"); $id = $_GET['id']; $type = $_GET['type']; $name = mysql_escape_string(stripslashes($_GET['name'])); if ($_GET['type'] == 1) { $conn->update($id, "name='{$name}'"); } if ($_GET['type'] == 2) { if ($conn->delete($id) > 0) { echo "true"; } else { echo "false"; } } if ($_GET['type'] == 3) { $conn->insert('name', "'{$name}'"); } echo "OK!"; echo "<script type='text/javascript' src='../js/common.js'></script><script>GotoOtherPage('EditNewsType.php','游戏类型修改成功!')</script>";
/** * Save the rectangle into the database */ public function save() { return $this->isValid() && DbHelper::insert(array(self::DB_COL_TOP_A => (int) $this->topA, self::DB_COL_LEFT_A => (int) $this->leftA, self::DB_COL_TOP_B => (int) $this->topB, self::DB_COL_LEFT_B => (int) $this->leftB), self::DB_TABLE); }
<body> <?php require_once '../lib/global.php'; $content = mysql_escape_string(stripslashes($_POST['FCKeditor1'])); $title = mysql_escape_string(stripslashes($_POST['title'])); $author = mysql_escape_string(stripslashes($_POST['author'])); $clazz = mysql_escape_string(stripslashes($_POST['clazz'])); $tags = mysql_escape_string(stripslashes($_POST['tag'])); $clicktimes = mysql_escape_string(0); $commentnum = mysql_escape_string(0); $scores = mysql_escape_string(0); $addtime = mysql_escape_string(date("Y-m-d H:i:s")); $picurl = mysql_escape_string('testurl'); $newsDbHelper = new DbHelper("pg_news"); $newsDbHelper->insert('title,content,classid,date,picurl,tags,author,clicktimes,commentnum,scores', "'{$title}','{$content}','{$clazz}','{$addtime}','{$picurl}','{$tags}','{$author}','{$clicktimes}','{$commentnum}','{$scores}'"); echo "<script type='text/javascript' src='../js/common.js'></script><script>GotoOtherPage('addnews.php','添加新闻成功!')</script>"; /*echo "<script>alert('新闻内容是:$sValue')</script>"; echo "<script>alert('新闻标题是:$title')</script>";*/ ?> </body>