<?
php
error_reporting ( E_ALL ); # pass any error messages triggered to error handler
require_once ( " Smarty.class.php " );
require_once ( " adodb.inc.php " );
$db = ADONewConnection( ' mysql ' );
print_r ( $db -> ServerInfo() );
$db -> debug = true ;
$db -> Connect( ' localhost ' , ' root ' , '' , ' News ' );
$rs = $db -> Execute( ' select * from tb_news_mu ' );
print " <pre> " ;
// print_r($rs->GetArray());
//print_r($rs->GetRows());
print " </pre> " ;
$recordSet = & $db -> Execute( ' select * from tb_news_mu ' );
if ( ! $recordSet )
print $db -> ErrorMsg();
else
while ( ! $recordSet -> EOF) {
print $recordSet -> fields[ 0 ] . ' ' . $recordSet -> fields[ 1 ] . ' <BR> ' ;
$recordSet -> MoveNext();
} $recordSet -> Close(); # optional
// $db->Close(); # optional
$db -> SetFetchMode(ADODB_FETCH_NUM);
$rs1 = $db -> Execute( ' select * from tb_news_mu ' );
$db -> SetFetchMode(ADODB_FETCH_ASSOC);
$rs2 = $db -> Execute( ' select * from tb_news_mu ' );
print " <pre> " ;
print_r ( $rs1 -> fields); # shows array([0]=>'v0',[1] =>'v1')
print " <pre> " ;
print_r ( $rs2 -> fields); # shows array(['col1']=>'v0',['col2'] =>'v1')
$sql = ' select vcNewsTitle,ltNewsContent from tb_news_mu ' ;
$rs = $db -> Execute( $sql );
print $rs -> GetMenu( ' GetCust ' , ' Mary Rosli ' );
$recordSet -> Close(); # optional
$sql = " insert into tb_news_mu(vcNewsTitle,ltNewsContent) values('ANATR','hello') " ;
if ( $db -> Execute( $sql ) == false ) {
print ' error inserting: ' . $db -> ErrorMsg() . ' <BR> ' ;
}
include_once ( ' adodb-pager.inc.php ' );
include_once ( ' toexport.inc.php ' );
include_once ( ' adodb-pager.inc.php ' );
$sql = " select * from tb_news_mu " ;
$rs = $db -> Execute( $sql );
print " <pre> " ;
print rs2csv( $rs ); # return a string, CSV format
print ' <hr> ' ;
$rs -> MoveFirst(); # note, some databases do not support MoveFirst
print rs2tab( $rs , false ); # return a string, tab-delimited false == suppress field names in first line
print ' <hr> ' ;
$rs -> MoveFirst();
rs2tabout( $rs ); # send to stdout directly (there is also an rs2csvout function)
print " </pre> " ;
$rs -> MoveFirst();
$fp = fopen ( $path , " w " );
if ( $fp ) {
rs2csvfile( $rs , $fp ); # write to file (there is also an rs2tabfile function)
fclose ( $fp );
}
error_reporting ( E_ALL ); # report all errors
ini_set ( " display_errors " , " 0 " ); # do not echo any errors
define ( ' ADODB_ERROR_LOG_TYPE ' , 3 );
define ( ' ADODB_ERROR_LOG_DEST ' , ' C:/errors.log ' );
include ( ' adodb-errorhandler.inc.php ' );
include ( ' adodb.inc.php ' );
include ( ' tohtml.inc.php ' );
$c = NewADOConnection( ' mysql ' );
$c -> PConnect( ' localhost ' , ' root ' , '' , ' News ' );
$rs = $c -> Execute( ' select * from tb_news_mu ' ); # # invalid table productsz
if ( $rs ) rs2html( $rs );
else {
$e = ADODB_Pear_Error();
echo ' <p> ' , $e -> message , ' </p> ' ;
}
$rs = $db -> Execute( ' select * from tb_news_mu ' );
while ( $arr = $rs -> FetchRow()) {
print_r ( $arr ); print " <br> " ;
}
?>
error_reporting ( E_ALL ); # pass any error messages triggered to error handler
require_once ( " Smarty.class.php " );
require_once ( " adodb.inc.php " );
$db = ADONewConnection( ' mysql ' );
print_r ( $db -> ServerInfo() );
$db -> debug = true ;
$db -> Connect( ' localhost ' , ' root ' , '' , ' News ' );
$rs = $db -> Execute( ' select * from tb_news_mu ' );
print " <pre> " ;
// print_r($rs->GetArray());
//print_r($rs->GetRows());
print " </pre> " ;
$recordSet = & $db -> Execute( ' select * from tb_news_mu ' );
if ( ! $recordSet )
print $db -> ErrorMsg();
else
while ( ! $recordSet -> EOF) {
print $recordSet -> fields[ 0 ] . ' ' . $recordSet -> fields[ 1 ] . ' <BR> ' ;
$recordSet -> MoveNext();
} $recordSet -> Close(); # optional
// $db->Close(); # optional
$db -> SetFetchMode(ADODB_FETCH_NUM);
$rs1 = $db -> Execute( ' select * from tb_news_mu ' );
$db -> SetFetchMode(ADODB_FETCH_ASSOC);
$rs2 = $db -> Execute( ' select * from tb_news_mu ' );
print " <pre> " ;
print_r ( $rs1 -> fields); # shows array([0]=>'v0',[1] =>'v1')
print " <pre> " ;
print_r ( $rs2 -> fields); # shows array(['col1']=>'v0',['col2'] =>'v1')
$sql = ' select vcNewsTitle,ltNewsContent from tb_news_mu ' ;
$rs = $db -> Execute( $sql );
print $rs -> GetMenu( ' GetCust ' , ' Mary Rosli ' );
$recordSet -> Close(); # optional
$sql = " insert into tb_news_mu(vcNewsTitle,ltNewsContent) values('ANATR','hello') " ;
if ( $db -> Execute( $sql ) == false ) {
print ' error inserting: ' . $db -> ErrorMsg() . ' <BR> ' ;
}
include_once ( ' adodb-pager.inc.php ' );
include_once ( ' toexport.inc.php ' );
include_once ( ' adodb-pager.inc.php ' );
$sql = " select * from tb_news_mu " ;
$rs = $db -> Execute( $sql );
print " <pre> " ;
print rs2csv( $rs ); # return a string, CSV format
print ' <hr> ' ;
$rs -> MoveFirst(); # note, some databases do not support MoveFirst
print rs2tab( $rs , false ); # return a string, tab-delimited false == suppress field names in first line
print ' <hr> ' ;
$rs -> MoveFirst();
rs2tabout( $rs ); # send to stdout directly (there is also an rs2csvout function)
print " </pre> " ;
$rs -> MoveFirst();
$fp = fopen ( $path , " w " );
if ( $fp ) {
rs2csvfile( $rs , $fp ); # write to file (there is also an rs2tabfile function)
fclose ( $fp );
}
error_reporting ( E_ALL ); # report all errors
ini_set ( " display_errors " , " 0 " ); # do not echo any errors
define ( ' ADODB_ERROR_LOG_TYPE ' , 3 );
define ( ' ADODB_ERROR_LOG_DEST ' , ' C:/errors.log ' );
include ( ' adodb-errorhandler.inc.php ' );
include ( ' adodb.inc.php ' );
include ( ' tohtml.inc.php ' );
$c = NewADOConnection( ' mysql ' );
$c -> PConnect( ' localhost ' , ' root ' , '' , ' News ' );
$rs = $c -> Execute( ' select * from tb_news_mu ' ); # # invalid table productsz
if ( $rs ) rs2html( $rs );
else {
$e = ADODB_Pear_Error();
echo ' <p> ' , $e -> message , ' </p> ' ;
}
$rs = $db -> Execute( ' select * from tb_news_mu ' );
while ( $arr = $rs -> FetchRow()) {
print_r ( $arr ); print " <br> " ;
}
?>