Conn.php
<?php
/*数据库路径,请自己修改,否则可能运行不正常*/
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("include/#mydb.mdb");
$conn->Open($connstr);
//创建记录集查询
?>
List.php
<?php
include_once("include/conn.php");
$rs = $conn->Execute('SELECT * FROM contents order by id desc');
while(!$rs->EOF)
{
echo "<table><tr><td>留言人ID:<font color='red'>".$rs->Fields['id']->Value ."</font></td>";
echo "<td> 姓名:".$rs->Fields['name']->Value ."</td></tr>";
echo "<tr><td colspan='2'>留言:".$rs->Fields['content']->Value ."</td></tr></table><br/>";
echo "- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ";
$rs->MoveNext();
}
/*释放资源*/
$rs->Close();
$conn->Close();
$rs = null;
$conn = null;
?>
Insert.php
<?php
$name=$_POST['user_name'];
$content=$_POST['user_post'];
if ($name<>"" and $content<>"")
{
include_once("include/conn.php");
$rs = $conn->Execute("insert into contents (name,content) values ('$name','$content')");
header("location:index.php");
}
else
echo "<script language='javascript'>alert('字段不能有空!');location='index.php';</script>";
?>
Delete.php
<?
session_start();
if($_SESSION['admin']=="OK")
{
include_once("include/conn.php");
$sql="delete from contents where id=".$_GET['id'];
$rs = $conn->Execute($sql);
header("location:admin_index.php");
}
?>
Updata.php
<?
session_start();
if($_SESSION['admin']=="OK")
{
include_once("include/conn.php");
$sql="update contents set content='".$_POST['post_contents']."' where id=".$_POST['id'];
$rs = $conn->Execute($sql);
}
header("location:admin_index.php");
?>