读取mdb数据库例程

$conn = new com("adodb.connection");
$connstr = "driver={microsoft access driver (*.mdb)}; dbq=". realpath("data/db.mdb");

$conn->open($connstr);
$rs = new com("adodb.recordset");
$rs->open("select * from szd_t",$conn,1,1);
while(! $rs->eof)
$f = $rs->fields(1);
echo $f->value;
$rs->movenext();

class excel{

    /**
     *头的excel文件（前缀的行）
     *
     *从excel复制的xml规格。
     *
     * @访问私有
     * @无功串
     */
    var $header = "<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/tr/rec-html40">";

    /**
     *页脚的excel文件（附加到行）
     *
     *从excel复制的xml规格。
     *
     * @访问私有
     * @无功串
     */
    var $footer = "</workbook>";

    /**
     * document lines (rows in an array)
     *
     * @access private
     * @var array
     */
    var $lines = array ();

    /**
     工作表名称
     *
     *包含一个单一的工作表名称
     *
     * @访问私有
     * @无功串
     */
    var $worksheet_title = "table1";

    /**
  添加一个单行的文档字符串$
     *
     * @访问私有
     * @帕拉姆库马拉阵列一维阵列
     * @待办事项行创造应做减本-> addarray
     */
    function addrow ($array) {

        // initialize all cells for this row
        $cells = "";
       
        // foreach key -> write value into cells
        foreach ($array as $k => $v):
   
         // 加个字符串与数字的判断 避免生成的 excel 出现数字以字符串存储的警告
         if(is_numeric($v)) {
          // 防止首字母为 0 时生成 excel 后 0 丢失
          if(substr($v, 0, 1) == 0) {
           $cells .= "<cell><data ss:type="string">" . $v . "</data></cell> ";
          } else {
           $cells .= "<cell><data ss:type="number">" . $v . "</data></cell> ";
          }
         } else {
             $cells .= "<cell><data ss:type="string">" . $v . "</data></cell> ";
         }

        endforeach;

        // transform $cells content into one row
        $this->lines[] = "<row> " . $cells . "</row> ";

    }

    /**
    *添加一个数组到文档
     *
     *这应该是唯一的方法需要生成一个excel
     *文件。
     *
     * @访问公开
     * @帕拉姆库马拉数组二维数组
     * @待办事项可以转移到__construct（）稍后
     */
    function addarray ($array) {

        // run through the array and add them into rows
        foreach ($array as $k => $v):
            $this->addrow ($v);
        endforeach;

    }

    /**
    设置工作表名称
     *
     *检查的字符串不允许字符（： /?*),
     *削减它的最大31个字符，并设置标题。该死
     *为何未允许字符无处可寻？视窗
     *帮助没有帮助...
     *
     * @访问公开
     * @帕拉姆库马拉字符串$标题设计标题
     */
    function setworksheettitle ($title) {

        // strip out special chars first
        $title = preg_replace ("/[\|:|/|?|*|[|]]/", "", $title);

        // now cut it to the allowed length
        $title = substr ($title, 0, 31);

        // set title
        $this->worksheet_title = $title;

    }

   /**
     *生成excel文件
     *
     *最后生成的excel文件，并使用header（）函数
     *提供给浏览器。
     *
     * @访问公开
     * @帕拉姆库马拉字符串$文件名名称的excel文件来生成（... xls）中
     */
    function generatexml ($filename) {

        // deliver header (as recommended in php manual)
        header("content-type: application/vnd.ms-excel; charset=utf-8");
        header("content-disposition: inline; filename="" . $filename . ".xls"");

        // print out document to the browser
        // need to use strips教程lashes for the damn ">"
        echo stripslashes ($this->header);
        echo " <worksheet ss:name="" . $this->worksheet_title . ""> <table> ";
        echo "<column ss:index="1" ss:autofitwidth="0" ss:width="110"/> ";
        echo implode (" ", $this->lines);
        echo "</table> </worksheet> ";
        echo $this->footer;

    }

}

 * created on 2010-4-21
 *
 * the class for control mysql
 *
 * made by s71ence
 *
 * @$host
 * @$user_name
 * @$user_pwd
 * @$data_base
 * @$coding
 */
 class mysql
 {
 private $host;//主机名
 private $user_name;//用户名
 private $user_pwd;//密码
 private $data_base;//数据库名
 private $coding;//编码

//构造函数 进行初始化操作
 function __construct($host,$user_name,$user_pwd,$data_base,$coding)
 {
  $this->host=$host;
  $this->user_name=$user_name;
  $this->user_pwd=$user_pwd;
  $this->data_base=$data_base;
  $this->coding=$coding;
  $this->connect();//初始化连接
 }

/*********************************************************************************************
 * 数据库
 * 基本方法
 ********************************************************************************************/

//数据库连接
 function connect()
 {
  $link=mysql_connect($this->host,$this->user_name,$this->user_pwd) or die($this->error());
  mysql_select_db($this->data_base,$link) or die("无法连接数据库".$this->data_base);
  mysql_query("set names '$this->coding'");
 }

//错误信息
 function error()
 {
  return mysql_error();
 }

//mysql_query()方法
 function query($sql, $type = '')
 {
     if(!($query = mysql_query($sql)))
  {
   $this->show('say:', $sql);
  }

  //echo $sql."<br/>";//测试完成后 注释
     return $query;
 }

//sql语句显示
 function show($message = '', $sql = '')
 {
  if(!$sql)
  {
   echo $message;
  }
  else
  {
   echo $message.'<br>'.$sql;
  }
 }

//mysql_affected_rows()方法
    function affected_rows()
 {
  return mysql_affected_rows();
 }

//mysql_result方法
 function result($query, $row)
 {
  return mysql_result($query, $row);
 }

//mysql_num_rows方法
 function num_rows($query)
 {
  return @mysql_num_rows($query);
 }

//mysql_num_fields方法
 function num_fields($query)
 {
  return mysql_num_fields($query);
 }

//mysql_free_result方法
 function free_result($query)
 {
  return mysql_free_result($query);
 }

//mysql_insert_id方法
 function insert_id()
 {
  return mysql_insert_id();
 }

//mysql_fetch_row方法
 function fetch_row($query)
 {
  return mysql_fetch_row($query);
 }

//mysql_get_server_info方法
 function version()
 {
  return mysql_get_server_info();
 }

//mysql_fetch_array()方法
 function fetch_array($result)
 {
  return mysql_fetch_array($result);
 }

//mysql_close方法
 function close()
 {
  return mysql_close();
 }

/*********************************************************************
 * 数据库
 * 功能方法
 *********************************************************************/

/*
 * insert方法
 *  $table 表名
 * $fields 字段名
 * $value 字段值
 */

 function fn_insert($table,$fields,$values)
 {
  return $this->query("insert into $table ($fields) values ($values)");
  $this->close();
 }

/*
 * select方法
 *  $table 表名
 * $fields 字段名
 * $condition 查询条件
 * $order 排序条件
 * $limit 取出条数
 */
 function fn_select($table,$fields,$condition,$order,$limit)
 {
  $query="select $fields from $table";

  if($condition!="")
  {
   $query.=" where $condition";
  }

  if($order!="")
  {
   $query.=" order by $order ";
  }

  if($limit!="")
  {
   $query.=" limit $limit";
  }

  return $this->query($query);
  $this->close();
 }

/*
 * delete方法
 * $table 表名
 * $fields 字段名
 * $values 字段值
 */
 function fn_delete($table,$condition)
 {
  return $this->query("delete from $table where $condition");
  $this->close();
 }

/*
 * update方法
 * $table 表名
 * $fields 字段名
 * $values 字段值
 */
 function fn_update($table,$set,$condition)
 {
  $sql="update $table set $set";
  if($condition!="")
  {
   $sql.=" where $condition";
  }

  return $this->query($sql);
  $this->close();
 }

/*
 * 析构函数，垃圾回收
 */
 function __destruct()
 {
  //echo "clear";
    }
 }
 

 $db =  new mysql('127.0.0.1','username','password','databasename',"utf8");

class sortclass{

var $data = array();
var $child = array(-1=>array());
var $layer = array(-1=>-1);
var $parent = array();
var $link;
var $table;
function sortclass($link, $table){
$this->setnode(0, -1, '顶极节点');
$this->link = $link;
$this->table = $table;
$node = array();
$results = mysql_query("select * from $this->table",$this->link);

while($node = mysql_fetch_array($results)){
$this->setnode($node['id'],$node['f_id'],$node['name']);
}
}
function setnode ($id, $parent, $value){
$parent = $parent?$parent:0;
$this->data[$id] = $value;
$this->child[$id] = array();
$this->child[$parent][] = $id;
$this->parent[$id] = $parent;
$this->layer[$id] = !isset($this->layer[$parent])? 0 : $this->layer[$parent] + 1;
}
function getlist (&$tree, $root= 0){
foreach ($this->child[$root] as $key=>$id){
$tree[] = $id;
if ($this->child[$id]) $this->getlist($tree, $id);
}
}
function getvalue ($id){return $this->data[$id];}
function getlayer ($id, $space = false){
return $space?str_repeat($space, $this->layer[$id]):$this->layer[$id];
}
function getparent ($id){return $this->parent[$id];}
function getparents ($id){
while ($this->parent[$id] != -1){
$id = $parent[$this->layer[$id]] = $this->parent[$id];
}
ksort($parent);
reset($parent);
return $parent;
}
function getchild ($id){return $this->child[$id];}
function getchilds ($id = 0){
$child = array($id);
$this->getlist($child, $id);
return $child;
}
function addnode($name,$pid){
//echo "insert into $this->table (`f_id`,`name`) values ('$pid','$name')";exit;
mysql_query("insert into $this->table (`f_id`,`name`) values ('$pid','$name')",$this->link);

}
function modnode($cid, $newname){
mysql_query("update $this->table set `name`='$newname' where `id` = $cid",$this->link);
}
function delnode($cid){
$allchilds = $this->getchilds($cid);
$sql ='';
if(empty($allchilds)){
$sql = "delete from $this->table where `id` = $cid";
}else{
$sql = 'delete from '.$this->table.' where `id` in ('.implode(',',$allchilds).','.$cid.')';
}
mysql_query($sql,$this->link);
}
function movenode($cid, $topid){
mysql_query("update $this->table set `f_id`=$topid where `id` = $cid", $this->link);
}
}
//函数
function back(){
echo '<script language="网页特效">window.location.href="news.class.php?"+new date().gettime();</script>';
exit;
}
//生成select
function makeselect($array,$formname){
global $tree;
$select = '<select name="'.$formname.'">';
foreach ($array as $id){
$select.='<option value="'.$id.'">'.$tree->getlayer($id, '|-').$tree->getvalue($id)."</option>";
}
return $select.'</select>';
}
$tree = new sortclass($link,'`p_newsclass`');
$op = !empty($_post['op']) ? $_post['op'] : $_get['op'];
if(!empty($op)){

if($op=='add'){
$tree->addnode($_post['cname'],$_post['pid']);
back();
}

if($op=='mod'){
$tree->modnode($_post['cid'],$_post['cname']);
back();
}

if($op=='del'){
$tree->delnode($_get['cid']);
back();
}

if($op=='move'){
$tree->movenode($_post['who'],$_post['to']);
back();
}
}
$category = $tree->getchilds();
?>