$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'] . '';}
?>
姓名: |
性别:男 女 |
请留言: |