php编写的ACCESS处理类

    在做项目中要用到ACCESS数据库,所以就写了一个ACCESS处理类.函数名跟ADODB类一样.

 

<?php
/*
*ACCESS数据库操作类
*2008-3-26
*LIQUAN
*$dsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".PATH_ROOT."databasedata.mdb";
*$conn=new Access();
*$conn->Connnect($dsn);
*$conn->GetArray("select * from test");
*/

class Access
{
    var $conn;
    var $fieldsName;
    
    function Access()
    {
   
    }

    //connection 
    function Connect($dsn)
    {
        $this->conn = new COM("ADODB.Connection") or die("Cannot start ADO");
        $this->conn->Open($dsn);
    }

    //返回一个
    function GetOne($sql)
    {  
       $rs = $this->conn->Execute($sql);
       while (!$rs->EOF)
       {
             $value=$rs->Fields(0)->value;      
          $rs->MoveNext();
       }
        $rs->Close();
        $rs=null;

        if(!empty($value))
        {
          return  $value;
        }
        else
        {
          return "";
        }
        unset($value);
    }


   //返回大数组
    function GetArray($sql)
    {
      
       $rs = $this->conn->Execute($sql);
       $num_columns = $rs->Fields->Count();
        $rowcount = 0;
        while (!$rs->EOF)
        {
          for ($i=0; $i < $num_columns; $i++)
          {
                   $fieldName[$rowcount][$rs->Fields($i)->name]= $rs->Fields($i)->value;
          }
          $rowcount++;            
          $rs->MoveNext();
        }
        $rs->Close();

        $rs=null;
        if(!empty($fieldName))
        {
          return  $fieldName;
        }
        else
        {
          return "";
        }
        
        unset($fieldName);
    }

    //返回小数组
    function GetRow($sql)
    {
       $rs = $this->conn->Execute($sql);
       $num_columns = $rs->Fields->Count();
        
       while (!$rs->EOF)
       {
          for ($i=0; $i < $num_columns; $i++)
          {
                  $fieldName[$rs->Fields($i)->name]=$rs->Fields($i)->value;
          }      

          $rs->MoveNext();
        }
        $rs->Close();

        $rs=null;
        if(!empty($fieldName))
        {
          return  $fieldName;
        }
        else
        {
          return "";
        }
       unset($fieldName);

    }

    //execute SQL
    function Execute($sql)
    {
       if($this->conn->Execute($sql))
       {
         return true;
       }
       else
       {
         return false;
       }
    }

    function Close()
    {
        $this->conn->Close();
    }

     function __destruct()
     {
      // $this->conn->Close();
     }



}

?>

 

 

更新日期：2008-03-04

受影响系统：

phpMyAdmin phpMyAdmin < 2.11.5

不受影响系统：

phpMyAdmin phpMyAdmin 2.11.5

描述：

BUGTRAQ ID: 28068


phpMyAdmin是用PHP编写的工具，用于通过WEB管理MySQL。


phpMyAdmin使用$_REQUEST而不是$_GET和$_POST变量作为其参数来源，并且在SQL查询中未经过滤便使用了参数，如果用户受骗访问了恶意网站的话，就可能导致SQL注入攻击。


phpMyAdmin：目前厂商已经发布了升级补丁以修复这个安全问题，请到厂商的主页下载：

http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.11.5-all-languages.tar.bz2?download

<?php
$d=array(
array("a",-20319),
array("ai",-20317),
array("an",-20304),
array("ang",-20295),
array("ao",-20292),
array("ba",-20283),
array("bai",-20265),
array("ban",-20257),
array("bang",-20242),
array("bao",-20230),
array("bei",-20051),
array("ben",-20036),
array("beng",-20032),
array("bi",-20026),
array("bian",-20002),
array("biao",-19990),
array("bie",-19986),
array("bin",-19982),
array("bing",-19976),
array("bo",-19805),
array("bu",-19784),
array("ca",-19775),
array("cai",-19774),
array("can",-19763),
array("cang",-19756),
array("cao",-19751),
array("ce",-19746),
array("ceng",-19741),
array("cha",-19739),
array("chai",-19728),
array("chan",-19725),
array("chang",-19715),
array("chao",-19540),
array("che",-19531),
array("chen",-19525),
array("cheng",-19515),
array("chi",-19500),
array("chong",-19484),
array("chou",-19479),
array("chu",-19467),
array("chuai",-19289),
array("chuan",-19288),
array("chuang",-19281),
array("chui",-19275),
array("chun",-19270),
array("chuo",-19263),
array("ci",-19261),
array("cong",-19249),
array("cou",-19243),
array("cu",-19242),
array("cuan",-19238),
array("cui",-19235),
array("cun",-19227),
array("cuo",-19224),
array("da",-19218),
array("dai",-19212),
array("dan",-19038),
array("dang",-19023),
array("dao",-19018),
array("de",-19006),
array("deng",-19003),
array("di",-18996),
array("dian",-18977), <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>phpinfo</title>
</head>
<body>
<?
$to = "atoat@sina.com";
$subject = "php-Mail";
$msg = "I completely understand SMTP servers now!";
$headers = "From: atoat@163.comrnReply-To: atoat@163.com";
mail("$to", "$subject", "$msg", "$headers");
echo "finished!";
?>
</body>
</html>

出现的错误:
Warning: mail() [function.mail]: SMTP server response: 550 5.7.1 Unable to relay for atoat@sina.com in C:webserverhtdocswwwmail.php on line 14

php.ini配置情况

[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
sendmail_from = atoat@163.com

已经安装了windows自带的smtp服务

找了好久才发现需要在smtp服务的中继选项中添加本机IP地址

虚拟服务器->属性->访问->中继
选择"仅以下列表"=>"单台计算机"=>添加127.0.0.1的本地地址

程序没有出现问题,但收件箱中没有立即收到信息.

没有收到是因为我的机子是在内网中，不能把邮件发送到外网．

解决方法：在网关做个端口映射，把２５端口映射到本机．或者本机有公网IP．