<?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>
