A-A+
PHP操作Access类(PHP+ODBC+Access)
此文章为网络转载,大致使用方式看说明。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 | < ?php -------------------------------------------------------------------- //FileName:class.php //Summary: Access数据库操作类 //Author: forest //CreateTime: 2006-8-10 //LastModifed: //copyright (c)2006 freeweb.nyist.net/~chairy [email]chaizuxue@163.com[/email] // 使用范例: //$databasepath="database.mdb"; //$dbusername=""; //$dbpassword=""; //include_once("class.php"); //$access=new Access($databasepath,$dbusername,$dbpassword); 新建一个链接数据库的类 //print_r($access->getlist("SELECT TOP 5 * FROM `Result` WHERE `ResultNo` < 12 ORDER BY `ResultNo` DESC")); 查询5条记录 -------------------------------------------------------------------- class Access { var $databasepath,$constr,$dbusername,$dbpassword,$link; function Access($databasepath,$dbusername,$dbpassword) { $this->databasepath=$databasepath; $this->username=$dbusername; $this->password=$dbpassword; $this->connect(); } function connect() { $this->constr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath($this->databasepath); $this->link=odbc_connect($this->constr,$this->username,$this->password,SQL_CUR_USE_ODBC); return $this->link; //if($this->link) echo "恭喜你,数据库连接成功!"; //else echo "数据库连接失败!"; } function query($sql) { return @odbc_exec($this->link,$sql); } function first_array($sql) { return odbc_fetch_array($this->query($sql)); } function fetch_row($query) { return odbc_fetch_row($query); } function total_num($sql)//取得记录总数 { return odbc_num_rows($this->query($sql)); } function close()//关闭数据库连接函数 { odbc_close($this->link); } function insert($table,$field)//插入记录函数 { $temp=explode(',',$field); $ins=''; for ($i=0;$i<count ($temp);$i++) { $ins.="'".$_POST[$temp[$i]]."',"; } $ins=substr($ins,0,-1); $sql="INSERT INTO ".$table." (".$field.") VALUES (".$ins.")"; $this->query($sql); } function getinfo($table,$field,$id,$colnum)//取得当条记录详细信息 { $sql="SELECT * FROM ".$table." WHERE ".$field."=".$id.""; $query=$this->query($sql); if($this->fetch_row($query)) { for ($i=1;$i< $colnum;$i++) { $info[$i]=odbc_result($query,$i); } } return $info; } function getlist($table,$field,$colnum,$condition,$sort="ORDER BY id DESC")//取得记录列表 { $sql="SELECT * FROM ".$table." ".$condition." ".$sort; $query=$this->query($sql); $i=0; while ($this->fetch_row($query)) { $recordlist[$i]=getinfo($table,$field,odbc_result($query,1),$colnum); $i++; } return $recordlist; } function getfieldlist($table,$field,$fieldnum,$condition="",$sort="")//取得记录列表 { $sql="SELECT ".$field." FROM ".$table." ".$condition." ".$sort; $query=$this->query($sql); $i=0; while ($this->fetch_row($query)) { for ($j=0;$j< $fieldnum;$j++) { $info[$j]=odbc_result($query,$j+1); } $rdlist[$i]=$info; $i++; } return $rdlist; } function updateinfo($table,$field,$id,$set)//更新记录 { $sql="UPDATE ".$table." SET ".$set." WHERE ".$field."=".$id; $this->query($sql); } function deleteinfo($table,$field,$id)//删除记录 { $sql="DELETE FROM ".$table." WHERE ".$field."=".$id; $this->query($sql); } function deleterecord($table,$condition)//删除指定条件的记录 { $sql="DELETE FROM ".$table." WHERE ".$condition; $this->query($sql); } function getcondrecord($table,$condition="")// 取得指定条件的记录数 { $sql="SELECT COUNT(*) AS num FROM ".$table." ".$condition; $query=$this->query($sql); $this->fetch_row($query); $num=odbc_result($query,1); return $num; } } ?> |
布施恩德可便相知重
微信扫一扫打赏
支付宝扫一扫打赏