版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/mayongzhan - 马永占,myz,mayongzhan
其中需要在本地文件夹里建立一个temp文件夹
adodbtest.php
<?php
require_once('newadodb.php');
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title></title>
</head>
<body>
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$query = "SELECT * FROM library";
//$result = $db->Execute($query) or die($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>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title></title>
</head>
<body>
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
$title=$db->qstr("myz");
$author="123";
$query = "INSERT INTO library (title, author) VALUES ($title, $author)";
$result = $db->Execute($query) or die($db->ErrorMsg());
if ($result)
{
echo "Last inserted ID is " . $db->Insert_ID();
}
$db->Close();
?>
</body>
</html>
adodbtest3.php
<?php
require_once('newadodb.php');
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title></title>
</head>
<body>
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
$title=$db->qstr("myz");
$author="123";
$query = "DELETE FROM library WHERE id = 4";
$result = $db->Execute($query) or die($db->ErrorMsg());
if ($result)
{
echo $db->Affected_Rows() . " rows deleted";
}
$db->Close();
?>
</body>
</html>
adodbtest4.php
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
require_once("newadodb.php");
$query = $db->Prepare("INSERT INTO library (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("Error in query: $query. " . $db->ErrorMsg());
}
$db->Close();
?>
adodbtest5.php
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
require_once("newadodb.php");
$db->BeginTrans();
// first query
$query = "INSERT INTO library (title, author) VALUES ('Title A', 'Author B')";
$result = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());
// use ID from first query in second query
if ($result)
{
$id = $db->Insert_ID();
$query = "INSERT INTO library (title, author) VALUES ($id, 'USD 39.99')";
$result = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());
}
if ($result)
{
$db->CommitTrans();
}
else
{
$db->RollbackTrans();
}
$db->Close();
?>
adodbtest6.php
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
require_once("newadodb.php");
$query = "SELECT * FROM library";
$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 马永占
* @email mailmyz*gmail.com
*/
require_once("newadodb.php");
$query = "SELECT title, id FROM library";
$result = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());
print $result->GetMenu("library", '', false);
$db->Close();
?>
adodbtest8.php
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
require_once("adodb/toexport.inc.php");
require_once("adodb/tohtml.inc.php");
require_once("newadodb.php");
$query = "SELECT title, id FROM library";
$result = $db->Execute($query) or die("Error in query: $query. " . $db->ErrorMsg());
//echo rs2csv($result,false);
//echo rs2tab($result,false);
echo rs2html($result,false);
$db->Close();
?>
newadodb.php
<?php
/*
* @author 马永占
* @email mailmyz*gmail.com
*/
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
发表于 @ 2007年06月29日 22:12:00|评论(loading...)|编辑