PHP连接ACCESS操作

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>&nbsp;&nbsp;姓名:".$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");

?>