怎么做论坛网站调查页面（表单提交数据库）

<div class=”vipxybd”><form method=”post” action=”sjjs.php”>
<table width=”600″ height=”369″ class=”sctb”>

<tr>
<td height=”45″ align=”center” style=”font-weight:400;font-size:16px;”>客服小调查：VIP学员<span style=”color:#F00;”> {$_G[member][username]} </span>您好</td>
</tr>
<tr>
<td height=”45″ align=”center” style=”font-weight:400;font-size:16px”>请问您是通过什么途径来到学做网站论坛的？</td>
</tr>
<tr>
<td width=”580″ height=”217″ align=”center”>
<p class=”xzk”>
<span><input type=”radio” name=”searchlx” value=”百度”>百度</span>
<span><input type=”radio” name=”searchlx” value=”360搜索”>360搜索</span>
<span><input type=”radio” name=”searchlx” value=”搜狗”>搜狗</span>
<span><input type=”radio” name=”searchlx” value=”谷歌”>谷歌</span>
<span><input type=”radio” name=”searchlx” value=”其它”>其它搜索</span>
<span><input type=”radio” name=”searchlx” value=”网站链接”>其它网站链接</span>
</p>
<p style=”margin-top:20px;”>
<textarea name=”sousuci” id=”sousuci” placeholder=”这里填写您搜索的关键词或者其它网站网址，并注明是手机还是PC。例如：手机百度搜索“怎么做网站”……”></textarea></p></td>
</tr>
<tr>
<td height=”50″ align=”center”>
<input name=”uid” type=”hidden” value=”{$_G[member][uid]}”>
<input type=”submit” name=”button” id=”button” value=”提交” style=”width:200px !important;”>
</td>
</tr>
</table>
</form></div>

<?php
//先连接数据库
//代码来源：学做网站论坛https://www.xmy7.com/
$sousuleixing=$_POST[“searchlx”];
$sousuci=$_POST[“sousuci”];
$nowtimes=date(‘Y-m-d H:i:s’,time());
define(“DB_HOST”,”localhost”);
define(“DB_USER”,”数据库用户名”);
define(“DB_PWD”,”数据库密码”);
define(“DB_NAME”,”数据库名”);
$conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die(“连接服务器出错：”.mysql_error());
@mysql_select_db(DB_NAME) or die(“连接数据库出错：”.mysql_error());
@mysql_query(‘SET NAMES GB2312’);

$sql = “UPDATE pre_common_member SET sousuleixing=’”.$sousuleixing.”‘,sousuci=’”.$sousuci.”‘,nowtimes=’”.$nowtimes.”‘ WHERE uid=’”.$uid.”‘”;

mysql_query($sql,$conn);//执行SQL

$r=mysql_query($sql,$conn);
if($r){
echo “<script charset=’GB2312’>alert(‘Ok, thanks!’);location.replace(document.referrer);</script>”;
}else{
echo “<script charset=’GB2312′>alert(‘Error!’);location.replace(document.referrer);</script>”;
}

mysql_close($conn);
?>

<?php
$uid=$_POST[“uid”];
$sousuleixing=$_POST[“searchlx”];
$sousuci=$_POST[“sousuci”];
define(“DB_HOST”,”localhost”);
define(“DB_USER”,”数据库用户名”);
define(“DB_PWD”,”数据库密码”);
define(“DB_NAME”,”数据库名”);
$conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die(“连接服务器出错：”.mysql_error());
@mysql_select_db(DB_NAME) or die(“连接数据库出错：”.mysql_error());
@mysql_query(‘SET NAMES utf8’);

$sql = “UPDATE pre_common_member SET sousuleixing=’”.$sousuleixing.”‘,sousuci=’”.$sousuci.”‘ WHERE uid=’”.$uid.”‘”;

echo ‘<div class=”hyshuju”>
<h2>反馈信息</h2>
<ul>
<div class=”xxtitle”>
<li class=”clearfix”>
<span class=”bianhao1″>编号</span>
<span class=”bianhao2″>会员名</span>
<span class=”bianhao3″>会员ID</span>
<span>注册时间</span>
<span class=”bianhao4″>搜索类型</span>
<span>搜索词</span>
<span>反馈时间</span>
</li></div>’;
$result = mysql_query(“select * from pre_common_member where sousuleixing <> ” ORDER BY nowtimes DESC limit 0,500″);//获取最新500条数
$i=1;
while($row = mysql_fetch_array($result))//转成数组，且返回第一条数据,当不是一个对象时候退出
{
echo ‘
<li class=”clearfix”>
<span class=”bianhao1″>’.$i++.'</span>
<span class=”bianhao2″>’.$row[‘username’].'</span>
<span class=”bianhao3″>’.$row[‘uid’].'</span>
<span>’.date(“Y-m-d H:i:s”, $row[‘regdate’]).'</span>
<span class=”bianhao4″>’.$row[‘sousuleixing’].'</span>
<span>’.$row[‘sousuci’].'</span>
<span>’.$row[‘nowtimes’].'</span>
</li>’;
}
echo ‘</ul>
</div>’;

mysql_close($conn);
?>