最近开始学习一下php,通过视频和资料实现了一个简单的数据库操作——留言板。
1.连接数据库 conn.php
<?php
/*
* Created on 2014-6-5
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
$conn = @ mysql_connect("localhost:8806","root","");
mysql_select_db("bbs",$conn);
mysql_query("set names 'GBK' ");
?>
2.添加数据到数据库 add.php
<pre class="php" name="code"><?php
/*
* Created on 2014-6-5
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include("conn.php");
if($_POST['submit']){
$sql = "insert into message(id,user,title,content,lastdate)".
"values('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql);
echo "发表成功";
}
?>
<form action="add.php" method="post">
用户:<input type="text" name="user"></input></br>
标题 :<input type="text" name="title"></input></br>
内容:<textarea name="content"></textarea></br>
<input type="submit" name="submit" value="发布留言"/>
</form>
3.显示数据库中的所有数据 list.php
<?php
/*
* Created on 2014-6-5
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include("conn.php");
?>
<table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef">
<?
$sql = "select * from message";
$query = mysql_query($sql);
while($row= mysql_fetch_array($query)){
?>
<tr bgcolor="#eff3ff">
<td>标题:<?=$row[title]?> 用户:<?=$row[user]?></td>
</tr>
<tr bgColor="#ffffff">
<td>内容:<?=$row[content]?></td>
</tr>
<?
}
?>
</table>