<?php
/*
adodb数据库学习
*/
include_once("adodb5/adodb.inc.php");//包含adodb的文件
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "member
"); $db->Execute("set names 'GBK'");
$q=$db->Execute("select * from user_list
");
$row=$q->FetchRow();?>
出现如下问题:Fatal error: Call to a member function FetchRow() on a non-object in E:\PHPWEB\test\adob.php on line 13
/*
adodb数据库学习
*/
include_once("adodb5/adodb.inc.php");//包含adodb的文件
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "member
"); $db->Execute("set names 'GBK'");
$q=$db->Execute("select * from user_list
");
$row=$q->FetchRow();?>
出现如下问题:Fatal error: Call to a member function FetchRow() on a non-object in E:\PHPWEB\test\adob.php on line 13
应该是这句错了, 是否有user_list这张表,如果你知道怎么调出错误提示的话就一清二楚了
升级到 php5 应该也是如此
")or die (mysql_error()); 显示:Incorrect database name 'member ' 没有数据库
。我重新找个数据库插入,<?php
/*
adodb数据库学习
*/
include_once 'adodb5/adodb.inc.php';
$conn = &ADONewConnection('mysql');
$conn->Connect("localhost","root","","bbs");
$conn->Execute("set names 'GBK'");
$quey=&$conn->Execute("select * from message
") or die(mysql_error());
$row=$quey->FetchRow();
print_r($row);?>
显示如下:
Array ( [0] => 53 [id] => 53 [1] => 王志强 [user] => 王志强 [2] => 计算机 [title] => 计算机 [3] => 计算机 [content] => 计算机 [4] => 2011-10-03 [lastdate] => 2011-10-03
应该是没有数据库问题,非常感谢大家!