adodb学习
来源:互联网 发布:宏观对冲 知乎 编辑:程序博客网 时间:2024/05/16 17:42
<?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>";
}
?>
- adodb学习
- AdoDB学习笔记(一)
- AdoDB学习笔记(二)
- adodb学习总结
- ADODB 入门学习基础教程
- AdoDB学习笔记(一) [转]
- ADODB 入门学习基础教程[多图]
- ADODB
- adodb
- adoDB
- ADODB
- adodb
- ADOdb
- ADODB
- ADODB.Connection、ADODB.RecordSet
- ADODB.Connection、ADODB.RecordSet
- ADODB 入门
- ADODB , ADODB_lite
- C#3.0 learning
- COM+ 无法与 Microsoft 分布式事务协调程序交谈
- 变量的初始化规则
- html学习之三:列表&超链接
- [C/C++] 可变参数表(Variable Arguments)
- adodb学习
- 手机J2ME程序开发(一)
- [资料]I386平台的内存布局
- PLC在自来水净化加药过程中的应用
- 手机J2ME程序开发(二)
- [C/C++] 函数调用的栈分配
- 仅通过崩溃地址找出源代码的出错行
- 如何组织在线图书工程
- 手机J2ME程序开发(三)