以前记得玩ASP+ACCESS的时候，就是弄blog和通过简单实例，慢慢慢慢学会了倒腾简单的ASP+ACCESS程序。
现在转到了PHP+MYSQL，这么着也得稍微了解点PHP+MYSQL编程啊，虽然目前修改下模板什么的问题不大，但是还是希望能够了解下PHP+MYSQL编程，自己写个在线电话号码本用用也不错，呵呵
转悠了下还真不好找这种简单的，这不，找到了，就贴上来放着，高手略过啊。
这是一个PHP+MYSQL的留言本的实例：
1、head.php
<head> <meta http-equiv = "Content-Type" content = "text/html; charset = gb2312"> <title></title> <b><a href = "add.php"> 添加留言</a> | <a href = "list.php"> 浏览留言</a><b> <hr size = 1> </head>
这个大家基本可以忽略不计了吧。
2、conn.php 重要的数据库连接的文件。
<?php
$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");
mysql_select_db("bbs", $conn);
mysql_query("set names 'GBK'"); //使用GBK中文编码;
function htmtocode($content) { //将中php的空格换行改成html模式
$content = str_replace("\n", "<br>", str_replace(" ", " ", $content));
return $content;
}
?>主要是这个数据库连接的基本格式：
$conn = @ mysql_connect(“主机名”, “用户名”, “密码”) or die (“链接错误”); 链接不上mysql则显示“链接错误”
mysql_select_db(“数据库名”, $conn);
php链接到mysql中的选择语句解决中文乱码mysql_query(“set names ‘GBK’”);
3、add.php 向数据库添加留言记录
<?php
include("conn.php");
include("head.php");
if($_POST['submit']){
$sql = "insert into message (id, user, title, content, lastdate) " .
"values ('', '$_POST[user]', '$_POST[title]', '$_POST[content]', now())";
echo "<script language=\"javascript\">alert('添加成功');history.go(-1)</script>";
//输出“添加成功” 并且返回上一个页面
}
mysql_query($sql);
?>
<script type = "text/javascript">
function CheckPost()
{
if(myform.user.value == "")
{
alert("请填写用户名");
myform.user.focus();//光标移到user
return false;
}
if(myform.title.value.length < 2)
{
alert("标题不能少于2个字符");
myform.title.focus();
return false;
}
if(myform.content.value == "")
{
alert("请填写留言内容");
myform.content.focus();
return false;
}
}
</script>
<form action = "add.php" method = "post" name = "myform" onsubmit = "return CheckPost()">
用户:<input type = "text" size = "10" name = "user"/><br>
标题:<input type = "text" size = "10" name = "title"/><br>
内容:<textarea name = "content" cols = "60" rows = "10"></textarea><br>
<input type = "submit" name = "submit" value = "发布留言"/>
</form>4、list.php 就是显示留言和分页了
<?php
include("conn.php");
include("head.php");
$pagesize = 5;
$url = $_SERVER["REQUEST_URI"];
//print_r($url);echo "<br/>";
$url = parse_url($url);//print_r($url);echo "<br/>";
$url = $url[path];//echo print_r($url);echo "<br/>";
$numq = mysql_query("SELECT * FROM `message`");
$num = mysql_num_rows($numq);
// echo $num;
// $num = mysql_num_fields($numq);
// echo $num;
if($_GET[page]){
$pageval = $_GET[page];
$page = ($pageval - 1) * $pagesize;
$page.=',';
}
if($num > $pagesize){
if($pageval <= 1) $pageval = 1;
$temp = $num / $pagesize;
if($num % $pagesize != 0) $temp++;
if($pageval >= $temp - 1){
echo "共 $num 条".
" <a href = $url?page=".($pageval - 1).">上一页</a>";
}
else if($pageval >= 2){
echo "共 $num 条".
" <a href=$url?page=".($pageval - 1).">上一页</a> <a href = $url?page=".($pageval + 1).">下一页</a>";
}
else{
echo "共 $num 条".
" <a href = $url?page=".($pageval + 1).">下一页</a>";
}
echo "<hr>";
}
?>
<table width = 500 border = "0" align = "center" cellpadding = "5" cellspacing = "1" bgcolor = "#add3ef">
<?
$sql = "select * from message limit $page $pagesize";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)){
?>
<tr bgcolor = "#eff3ff">
<td>标题：<?= $row[title]?> </td>
<td>用户：<?= $row[user] ?> </td>
</tr>
<tr bgcolor = "#ffffff">
<td>内容：<?= htmtocode($row[content]) ?></td>
<td></td>
</tr>
<?
}
?>
</table>这个就是千辛万苦找来的最简单的PHP+MYSQL实例了，够简单吧。
