怎么将数据库取出来的值赋给eWebeditor并提交更新?
偶刚接触php,现在用eWebeditor在线编辑器遇到问题了 请各位大大帮我解决下 谢谢了
<!--这是我的新闻更新页news_edit.php 修改表单部分代码-->
<FORM method="post" name="myform" action="news_editsave.php?id= <?php echo $_GET["nid"];?>">
<?php
if(isset($_GET["action"]) && $_GET["action"]="edit" && $_GET["nid"] ){
$newsid=$_GET["nid"];
$db = new DB;
$db->Conn();
$sqlstr = "select * from t_news where news_id=$newsid" ;
echo $sqlstr;
$result = $db->query($sqlstr);
$arr = mysql_fetch_array($result);
$news_title = $arr["news_title"];
$news_date = $arr["news_date"];
$news_src = $arr["news_src"];
$news_type = $arr["news_type"];
$news_content= $arr["news_content"];
/* 问题1:我在数据库中单独为新闻类别建了张表,页面用下拉框选择,
现在我该如何将数据库中取得的值赋给下拉框<select name="type" size="1">
switch($news_type)
{
case 1: $type = 1;break;
case 2: $type = 2;break;
case 3: $type = 3;break;
case 4: $type = 4;break;
}*/
}
?>
<TABLE border="0" cellpadding="0" cellspacing="0">
<TR align="left">
<TD width="67">标 题: </TD>
<TD width="524"><input type="text" name="title" value="<?php echo $news_title;?>" />(*必填项,不超过100汉字为宜)</TD>
</TR>
<TR align="left">
<TD>发布日期:</TD>
<TD><input type="text" name="news_date" value="<?php echo $news_date;?>" />(*必填,格式1999-1-1)</TD>
</TR>
<TR align="left">
<TD>来 源:</TD>
<TD><input type="text" name="src" value=" <?php echo $news_src;?>" />(可选)</TD>
</TR>
<TR align="left">
<TD>类 型:</TD>
<TD align="left"><select name="type" size="1">
<option value="1">销售快讯</option>
<option value="2">工程动态</option>
<option value="3">媒体报道</option>
<option value="4">综合新闻</option>
</select></TD>
</TR>
<TR align="left">
<TD colspan="2">编辑内容:</TD>
</TR>
<TR>
<TD colspan="2">
//不知道后面取不到值的问题是不是出在这里 我将取出的数据直接赋给value
<INPUT type="hidden" name="content1" value=" <?php echo HTMLSpecialChars($news_content);?>">
<IFRAME ID="editor1" src="./editor/editor.htm?id=content1&style=light" frameborder="0" scrolling="no" width="100%" height="350"></IFRAME> </TD>
</TR>
<TR>
<TD colspan=2 align=right>
<input type=button value=' 后退 ' onclick='history.back()'>
<INPUT type=submit value=" 修改 " name="submit"> </TD>
</TR>
</TABLE>
</FORM>
==============
//news_editsave.php页处理更新
<?php
if(isset($_GET[ "id" ]) && $_GET[ "id" ]) {
$newsid=$_GET["id"];
$titles=$_POST["title"];
$newsdate=$_POST["news_date"];
$newstype=$_POST["type"];
$content=$_POST["content1"]; //问题2:这个好像取不到值 不知道什么原因??
$src=$_POST["src"];
switch($newstype)
{
case 1: $type = 1;break;
case 2: $type = 2;break;
case 3: $type = 3;break;
case 4: $type = 4;break;
}
$db = new DB;
$db->Conn();
if(strlen($titles) >100) {
echo "<script>alert('标题过长!请控制在100个字符以下!')</script>";
echo "<script>window.location.href='news_edit.php?action=edit?&nid=$newsid'</script>";
exit();
}
if($c) {
echo "<script>alert('请输入新闻内容!')</script>";
echo "<script>window.location.href='news_edit.php?action=edit?&nid=$newsid'</script>";
exit();
}
else{
$upsql = "update t_news set news_title='$titles',news_content='$content',news_type='$newstype',news_date='$newsdate',news_src='$src' where news_id=$newsid" ;
//执行时我用echo $upsql; 显示的 news_content="" 为什么没有值呢
我在新增新闻中可以取到值没有问题 为什么这里就取不到值呢?求助?!
if($db->Query($upsql)) {
echo "<script>alert('新闻更新成功!')</script>";
echo "<script>window.location.href='newsmanage.php'</script>";
/**/
}else{
echo "<script>alert('更新失败!')</script>";
echo "<script>window.location.href='newsmanage.php'</script>";
}
$db->close(); }
}
?>