php使用com链接access数据库

最新推荐文章于 2021-03-22 16:57:05 发布

原创最新推荐文章于 2021-03-22 16:57:05 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#access #php #function #sql #数据库 #microsoft

php 专栏收录该内容

29 篇文章

订阅专栏

本文探讨了国内全能主机的特点，特别是在Windows平台上支持多种技术栈（PHP、ASP、ASP.NET等）。介绍了使用Access数据库的优势，并提供了一个PHP工具类示例，用于实现Access数据库的基本操作，如连接数据库、执行SQL语句、获取数据等。

国内有很多全能主机，windows平台下 php + asp + asp.net + mssql + access + mysql这样的全能主机

不要对php+access这种结构嗤之以鼻，相比之下一个小型的企业类站点，使用access数据库在维护上更加灵活

安装也比较方便

mssql:

$connstr = "Provider=SQLOLEDB;
               Persist Security Info=False;
               User ID=youruid;
               Password=yourpwd;
               Initial Catalog=yourdatabase;
               Data Source=127.0.0.1";

附一个工具类<?php /** * ScriptName: DB2 * Version:0.1 * //获得数据库实例 * $db = new DB2('access数据库的物理地址'); * //获得数据库表结构Array * $db->show_tables(); * //执行sql语句Void * $db->query("insert into tb (id,name) values (null,'foobar')"); * //获取单个元素String * $name = $db->get_var("select name from tb where id=1"); * $total = $db->get_var("select count(id) as n from tb"); * //获取一行Array * $row = $db->get_row("select * from tb where id=1"); * //获取列表Array $pagesize = 12, $page=1, 后两项参数可选，为空则返回所有数据 * $rows = $db->get_results("select * from tb where cate=2",12,1); * */ class DB2{ var $conn; var $rs; var $cstr; function DB2($dbpath){ $this->conn = new com("ADODB.Connection"); $this->rs = new com("ADODB.RecordSet"); $this->cstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".$dbpath; $this->initDB(); } function initDB(){ $this->conn->Open($this->cstr); } function flushDB(){ $this->conn->Close(); } function show_tables(){ $rs = $this->conn->openSchema(20); $tables = array(); $rs->movefirst; while(!$rs->eof){ if($rs['TABLE_TYPE']->value == 'TABLE') $tables[] = $rs["TABLE_NAME"]->value; $rs->movenext; } return $tables; } function query($sql){ return $this->conn->execute($sql); } function get_row($sql){ $_row = $this->query($sql); if($_row->eof || $_row->bof) return null; foreach(@$_row->fields as $std){ $row[$std->name] = @$std->value; } return $row; } function get_var($sql){ $_row = $this->query($sql); if($_row->eof || $_row->bof) return null; return $_row->fields(0)->value; } function get_results($sql,$page_size = 0,$page = 0){ $this->rs->Open($sql,$this->conn,1,1); if($this->rs->eof || $this->rs->bof){ @$this->rs->Close(); return null; } if($page_size > 0 && $page > 0){ $this->rs->pagesize = $page_size; if($page < 1) $page = 1; if($page > $this->rs->pagecount) $page = $this->rs->pagecount; $this->rs->move(($page-1) * $page_size); for($i=1;$i<=$this->rs->pagesize;$i++){ $row = array(); foreach($this->rs->fields as $std){ $row[$std->name] = $std->value; } $rows[] = $row; $this->rs->movenext(); if($this->rs->eof||$this->rs->bof) break; } }else{ while(1){ $row = array(); foreach($this->rs->fields as $std){ $row[$std->name] = $std->value; } $rows[] = $row; $this->rs->movenext(); if($this->rs->eof||$this->rs->bof) break; } } $this->rs->close(); return $rows; } } ?>