我的留言板
$username = isset($_REQUEST[‘username’]) ? $_REQUEST[‘username’] : ”; //姓名
$sex = isset($_REQUEST[‘sex’]) ? intval($_REQUEST[‘sex’]) : 1; //性别
$msg = isset($_REQUEST[‘msg’]) ? $_REQUEST[‘msg’] : ”; //留言
mysql_connect(“127.0.0.1″,”root”,”lzy”); //链接
mysql_select_db(“test”); //选择数据库
if(!empty($username) && !empty($msg))
{
mysql_query(“INSERT INTO msgboard(username,sex,msg) VALUES(‘$username’,’$sex’,’$msg’)”);
}
else
{
echo “输入不正确
“;
}
$source = mysql_query(“SELECT * FROM msgboard ORDER BY id DESC”);
$result = array();
?>
姓名
性别
留言内容
while ($row = mysql_fetch_array($source))
{
echo ‘
‘ . $row[‘username’] . ‘
‘;
echo ‘
‘ . ($row[‘sex’] == 1 ? ‘男’ : ‘女’) . ‘
‘;
echo ‘
‘ . $row[‘msg’] . ‘
‘;
}
?>
姓名:
性别:男
女
请留言: