t;
留言:<textarea name="post_contents" rows="10" cols="50"></textarea>
<input type="submit">
</form>
</body>
</html>
updata.php页面代码如下:
<?
$name=$_POST['user_name'];
$content=$_POST['post_contents'];
$conn=mysql_connect("localhost:6033", "root", "");
mysql_query("set names utf-8"); //解决中文乱码问题
mysql_select_db("guest_book");
$exec="insert into contents (name,content) values ('".$_POST['user_name']."','".$_POST['post_contents']."')";
$result=mysql_query($exec);
?>
index.php页面代码如下:
<?
$conn=mysql_connect ("localhost:6033", "root", ""); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
mysql_query("set names utf-8"); //解决中文乱码问题
$exec="select * from contents"; //sql语句
$result=mysql_query($exec); //执行sql语句，返回结果
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td> 上一页 [1] [2] [3] 下一页
|
