用php odbc access數(shù)據(jù)庫來操作函數(shù)_PHP教程

教程Tag：暫無Tag,歡迎添加,賺取U幣!

推薦：PHP實例：上傳多個圖片并校驗的代碼
單張的圖片上傳是不復(fù)雜的，這里涉及到多張圖片上傳和對圖片格式的校驗，保證上傳的一定是圖片，防止上傳其他文件到服務(wù)器。基本實現(xiàn)算法是使用數(shù)組的形式，把所有的圖片提交個一個數(shù)組，

前些天下載了adodb,想用adodb連access數(shù)據(jù)庫，后來連是連上了，不過不能更新和插入記錄，也不知道為什么到現(xiàn)在還沒人給我回答那個苦惱的問題，后來就放棄了adodb，使用php自己的odbc，但是使用很不方便，就寫下了下面這些函數(shù),還沒有封裝成類,希望能夠為有同樣問題的朋友一些幫助。

<?php
/*
　* @ access class
　* insert,update,delete record
　* version 1.0
　* date 2005.6
　* power by Samsun Manzalo (34n 豬八戒)
　*
　*/

//====================================
// insert record
// 插入記錄
//====================================
function insRd( table, field){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
tmpA = explode(',', field);
ins = '';
for( i=0; i<count( tmpA); i ){
ins.= "'". _POST[ tmpA[ i]]."',";
}
ins = substr( ins,0,-1);
sql = "INSERT INTO ". table." (". field.") VALUES (". ins.")";
//echo sql;exit;
query = @odbc_do( connid, sql);
}

//====================================
// get one record detail
// 取得當條記錄詳細信息
//====================================
function getInfo( table, field, id, colnum){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "select * from ". table." where ". field."=". id;
query = @odbc_do( connid, sql);

if(odbc_fetch_row( query)){
for( i=0; i< colnum; i ){
info[ i] = odbc_result( query, i 1);
}
}
return info;
}

//====================================
// get record list
// 取得記錄列表
//====================================
function getList( table, field, colnum, condition, sort="order by id desc"){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "select * from ". table." ". condition." ". sort;
query = @odbc_do( connid, sql);
//echo sql."<br>";
i = 0;
while(odbc_fetch_row( query)){
rdList[ i] = getInfo( table, field,odbc_result( query,1), colnum);
i ;
}
return rdList;
}

//====================================
// get record list condition
// 取得記錄列表
//====================================
function getFieldList( table, field, fieldnum, condition="", sort=""){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "select ". field." from ". table." ". condition." ". sort;
query = @odbc_do( connid, sql);
//echo sql."<br>";
i = 0;
while(odbc_fetch_row( query)){
for( j=0; j< fieldnum; j ){
info[ j] = odbc_result( query, j 1);
}
rdList[ i] = info;
i ;
}
return rdList;
}

//====================================
// update record
// 更新記錄
//====================================
function updateInfo( table, field, id, set){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "update ". table." set ". set." where ". field."=". id;
query = @odbc_do( connid, sql);
}

//====================================
// record delete
// 刪除記錄
//====================================
function delRd( table, field, id){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "delete from ". table." where ". field."=". id;
query = @odbc_do( connid, sql);
}

//====================================
// record delete cat
// 刪除記錄（條件）
//====================================
function delOrRd( table, condition){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "delete from ". table." where ". condition;
query = @odbc_do( connid, sql);
}

//====================================
// count record
// 取得記錄數(shù)
//====================================
function countRd( table, condition=""){
connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/email.mdb";
connid = @odbc_connect( connstr,"","",SQL_CUR_USE_ODBC ) or die ("數(shù)據(jù)庫連接錯誤!");
sql = "select count(*) as num from ". table." ". condition;
query = @odbc_do( connid, sql);
odbc_fetch_row( query);
num = odbc_result( query,1);
return num;
}

?>

分享：講解用PHP實現(xiàn)Jmai組件及發(fā)送郵件三例
代碼一： <% On error resume next Dim JMail, contentId Set JMail = Server.CreateObject("JMail.Message") JMail.Charset = "gb2