欧美日韩精品在线,国内精品久久久久久久久,一级毛片恃级毛片直播,清纯唯美亚洲综合欧美色

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

編輯Tag賺U幣
教程Tag：暫無(wú)Tag,歡迎添加,賺取U幣!

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

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

<?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ù)庫(kù)連接錯(cuò)誤!");
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
// 取得當(dāng)條記錄詳細(xì)信息
//====================================
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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ù)庫(kù)連接錯(cuò)誤!");
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實(shí)現(xiàn)Jmai組件及發(fā)送郵件三例
代碼一： <% On error resume next Dim JMail, contentId Set JMail = Server.CreateObject("JMail.Message") JMail.Charset = "gb2

來(lái)源：模板無(wú)憂//所屬分類：PHP教程/更新時(shí)間：2008-08-22
相關(guān)PHP教程：