adodb测试代码

版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/mayongzhan - 马永占,myz,mayongzhan

其中需要在本地文件夹里建立一个temp文件夹

adodbtest.php

<? php
require_once ( ' newadodb.php ' );
?>
< html >
< head >
< metahttp - equiv = " Content-Type " content = " text/html;charset=gbk " />
< title ></ title >
</ head >
< body >
<? php
/*
*@author马永占
*/
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;

$query = " SELECT*FROMlibrary " ;

// $result=$db->Execute($query)ordie($db->ErrorMsg());
$result = $db -> SelectLimit( $query , 10 , 1 )or die ( $db -> ErrorMsg()); // 从第一个开始显示10个

while ( ! $result -> EOF)
{
echo $result -> fields[ ' title ' ] . " - " . $result -> fields[ ' author ' ] . " <br/> " ;
$result -> MoveNext();
}
echo " <br/>[ " . $result -> RecordCount() . " rows]<br/></b> " ; // 行数
echo " <br/>[ " . $result -> FieldCount() . " fields]<br/></b> " ; // 字段数
$db -> Close();
?>
</ body >
</ html >

adodbtest2.php

<? php
require_once ( ' newadodb.php ' );
?>
< html >
< head >
< metahttp - equiv = " Content-Type " content = " text/html;charset=gbk " />
< title ></ title >
</ head >
< body >
<? php
/*
*@author马永占
*/

$title = $db -> qstr( " myz " );
$author = " 123 " ;
$query = " INSERTINTOlibrary(title,author)VALUES($title,$author) " ;

$result = $db -> Execute( $query )or die ( $db -> ErrorMsg());

if ( $result )
{
echo " LastinsertedIDis " . $db -> Insert_ID();
}

$db -> Close();
?>
</ body >
</ html >

adodbtest3.php

<? php
require_once ( ' newadodb.php ' );
?>
< html >
< head >
< metahttp - equiv = " Content-Type " content = " text/html;charset=gbk " />
< title ></ title >
</ head >
< body >
<? php
/*
*@author马永占
*/

$title = $db -> qstr( " myz " );
$author = " 123 " ;
$query = " DELETEFROMlibraryWHEREid=4 " ;

$result = $db -> Execute( $query )or die ( $db -> ErrorMsg());

if ( $result )
{
echo $db -> Affected_Rows() . " rowsdeleted " ;
}

$db -> Close();
?>
</ body >
</ html >

adodbtest4.php

<? php
/*
*@author马永占
*/

require_once ( " newadodb.php " );

$query = $db -> Prepare( " INSERTINTOlibrary(title,author)VALUES(?,?) " );

$data = file ( " list.txt " );

foreach ( $data as $l )
{
$arr = explode ( " , " , $l );
$result = $db -> Execute( $query , array ( $arr [ 0 ] , $arr [ 1 ]))or die ( " Errorinquery:$query. " . $db -> ErrorMsg());
}


$db -> Close();
?>

adodbtest5.php

<? php
/*
*@author马永占
*/

require_once ( " newadodb.php " );


$db -> BeginTrans();

// firstquery
$query = " INSERTINTOlibrary(title,author)VALUES('TitleA','AuthorB') " ;
$result = $db -> Execute( $query )or die ( " Errorinquery:$query. " . $db -> ErrorMsg());

// useIDfromfirstqueryinsecondquery
if ( $result )
{
$id = $db -> Insert_ID();
$query = " INSERTINTOlibrary(title,author)VALUES($id,'USD39.99') " ;
$result = $db -> Execute( $query )or die ( " Errorinquery:$query. " . $db -> ErrorMsg());
}

if ( $result )
{

$db -> CommitTrans();
}

else
{
$db -> RollbackTrans();
}


$db -> Close();
?>

adodbtest6.php

<? php
/*
*@author马永占
*/

require_once ( " newadodb.php " );

$query = " SELECT*FROMlibrary " ;
$result = $db -> CacheExecute( 300 , $query )or die ( $db -> ErrorMsg());

while ( ! $result -> EOF)
{
echo $result -> fields[ 1 ] . " - " . $result -> fields[ 2 ] . " " ;
$result -> MoveNext();
}
$db -> Close();

?>

adodbtest7.php

<? php
/*
*@author马永占
*/

require_once ( " newadodb.php " );

$query = " SELECTtitle,idFROMlibrary " ;
$result = $db -> Execute( $query )or die ( " Errorinquery:$query. " . $db -> ErrorMsg());


print $result -> GetMenu( " library " , '' , false );

$db -> Close();

?>

adodbtest8.php

<? php
/*
*@author马永占
*/
require_once ( " adodb/toexport.inc.php " );
require_once ( " adodb/tohtml.inc.php " );
require_once ( " newadodb.php " );
$query = " SELECTtitle,idFROMlibrary " ;
$result = $db -> Execute( $query )or die ( " Errorinquery:$query. " . $db -> ErrorMsg());
// echors2csv($result,false);
//echors2tab($result,false);
echo rs2html( $result , false );
$db -> Close();
?>

newadodb.php

<? php
/*
*@author马永占
*/

require_once ' adodb/adodb.inc.php ' ;

$ADODB_CACHE_DIR = ' temp/ ' ;

$mydbtype = ' mysql ' ;
$mydbhost = ' localhost ' ;
$mydbname = ' root ' ;
$mydbpass = ' myz ' ;
$mydb = ' adodbtest ' ;

$db = NewADOConnection( $mydbtype );

$db -> Connect( $mydbhost , $mydbname , $mydbpass , $mydb )or die ( $db -> ErrorMsg());
?>

list.txt

abc,bcd
sdf,dsfgg
grwetg,dfsdf