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);
//创建记录集查询
?>
Add.php
<?php
$name=$_POST['user_name'];
$content=$_POST['user_post'];
if ($name<>"" and $content<>"")
{
?>
Del.php
<?
session_start();
if($_SESSION['admin']=="OK")
{
include_once("include/conn.php");
$sql="delete
$rs = $conn->Execute($sql);
header("location:admin_index.php");
}
?>
Show.php
<?
session_start();
if($_SESSION['admin']=="OK")
{
include_once("include/conn.php");
$sql="select * from contents where id=".$_GET['id'];
$rs = $conn->Execute($sql);
$name=$rs->Fields['name']->Value;
$content=$rs->Fields['content']->Value;
$id=$rs->Fields['id']->Value;
?>
<form action="modify_save.php" method="post" name="name1">
<?
}
?>
Edit.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");
?>