<?php
include("admin.php"); //登陆验证
include("fckeditor.php"); //fck编辑器
$sBasePath=$_SERVER['PHP_SELF'];
$sBasePath=dirname($sBasepath);
$ed= new FCKeditor('content');
$ed->BasePath=$sBasePath;
if($_POST['fenlei']&&$_POST['content']){
mysql_query("INSERT INTO `".$ad."news` (`id` ,`title` ,`fenlei` ,`fenlei1` ,`text` ,`content` ,`laiyuan` ,`yuedu` ,`time` )
VALUES (NULL , '{$_POST['title']}', '{$_POST['fenlei']}', '{$_POST['fenlei1']}', '', '{$_POST['content']}', '{$_POST['laiyuan']}', '', NOW( ) );");
echo"<script language=javascript>
alert( \"添加信息成功!\" );
location.href = \"add_news.php\"
</script>";
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>科目管理</title>
<link href="main.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</head><body>
<p> </p>
<form name="PosForm" method="post" action="" style="margin:0">
<table width="100%" border="0" cellspacing="1" cellpadding="5">
<tr>
<td height="25" class="td_title"> 家长频道添加</td>
</tr>
<tr>
<td height="23" class="td_content"><p>资讯分类:
<select name="fenlei1" id="fenlei1">
<option value="上海">上海</option>
<option value="广东">广东</option>
<option value="广西">广西</option>
<option value="云南">云南</option>
<option value="湖南">湖南</option>
<option value="浙江">浙江</option>
<option value="安徽">安徽</option>
</select>
<input name="fenlei" type="hidden" id="fenlei" value="南来北往">
<br><br>资讯标题:
<input name="title" type="text" id="title" size="50">
<br>
<br>
资讯内容:<?php $ed->Create(); ?>
<br><br>
<input name="Submit" type="submit" class="input_1" value="确定添加">
</p></td>
</tr>
</table>
<br>
</form>
</body>
</html>抓过字符长度 变量都存在的 就不是上次变量未定义的问题。。 数据库(
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`fenlei` varchar(15) NOT NULL,
`fenlei1` varchar(20) NOT NULL,
`text` varchar(10) NOT NULL,
`content` longtext NOT NULL,
`laiyuan` varchar(100) NOT NULL,
`yuedu` int(20) NOT NULL,
`time` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=80";
include("admin.php"); //登陆验证
include("fckeditor.php"); //fck编辑器
$sBasePath=$_SERVER['PHP_SELF'];
$sBasePath=dirname($sBasepath);
$ed= new FCKeditor('content');
$ed->BasePath=$sBasePath;
if($_POST['fenlei']&&$_POST['content']){
mysql_query("INSERT INTO `".$ad."news` (`id` ,`title` ,`fenlei` ,`fenlei1` ,`text` ,`content` ,`laiyuan` ,`yuedu` ,`time` )
VALUES (NULL , '{$_POST['title']}', '{$_POST['fenlei']}', '{$_POST['fenlei1']}', '', '{$_POST['content']}', '{$_POST['laiyuan']}', '', NOW( ) );");
echo"<script language=javascript>
alert( \"添加信息成功!\" );
location.href = \"add_news.php\"
</script>";
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>科目管理</title>
<link href="main.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</head><body>
<p> </p>
<form name="PosForm" method="post" action="" style="margin:0">
<table width="100%" border="0" cellspacing="1" cellpadding="5">
<tr>
<td height="25" class="td_title"> 家长频道添加</td>
</tr>
<tr>
<td height="23" class="td_content"><p>资讯分类:
<select name="fenlei1" id="fenlei1">
<option value="上海">上海</option>
<option value="广东">广东</option>
<option value="广西">广西</option>
<option value="云南">云南</option>
<option value="湖南">湖南</option>
<option value="浙江">浙江</option>
<option value="安徽">安徽</option>
</select>
<input name="fenlei" type="hidden" id="fenlei" value="南来北往">
<br><br>资讯标题:
<input name="title" type="text" id="title" size="50">
<br>
<br>
资讯内容:<?php $ed->Create(); ?>
<br><br>
<input name="Submit" type="submit" class="input_1" value="确定添加">
</p></td>
</tr>
</table>
<br>
</form>
</body>
</html>抓过字符长度 变量都存在的 就不是上次变量未定义的问题。。 数据库(
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`fenlei` varchar(15) NOT NULL,
`fenlei1` varchar(20) NOT NULL,
`text` varchar(10) NOT NULL,
`content` longtext NOT NULL,
`laiyuan` varchar(100) NOT NULL,
`yuedu` int(20) NOT NULL,
`time` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=80";
如果想在查询时区分字段值的大小写,则:字段值需要设置BINARY属性
CREATE TABLE T(
A VARCHAR(10) BINARY
);
2、mysql_query("INSERT INTO `".$ad."news`... 中 $ad 在何处定义的?请确认组装后的表名存在
3、sql语句宜写作
"INSERT INTO `{$ad}news` (`id` ,`title` ,`fenlei` ,`fenlei1` ,`text` ,`content` ,`laiyuan` ,`yuedu` ,`time` )
VALUES (NULL , '$_POST[title]', '$_POST[fenlei]', '$_POST[fenlei1]', '', '$_POST[content]', '$_POST[laiyuan]', '', NOW( ) )"
这样清楚点
4、请确认插入的数据中的特殊字符已被转义
5、插入是否成功请用 mysql_affected_rows 函数判断
6、mysql_query('insert ...') 的返回值反映sql指令的正确性当然,首先要确认两地的php环境的配置差异不会对此操作有负面影响
echo $sql;//输出看看有没有结果?
斯蒂芬', '', '', NOW( ) )
斯蒂芬 ', '', '', NOW( ) )试试看。