给你一个例子,确保pear环境配置正确
<?php
require_once 'DB.php';
$user = 'root';
$pass = '';
$host = 'localhost';
$db_name = 'OA';
$dsn = "mysql://$user:$pass@$host/$db_name";
$dbh=new DB;
$db = $dbh->connect($dsn);
if (DB::isError($db))
{
die ($db->getMessage());
}
$userid=1;
$sql=sprintf("select * from itempos where userid='%s'",$userid);
$rows=$db->getRow($sql,null,DB_FETCHMODE_ASSOC);
if(@DB::isError($rows) || count($rows)<1)
{
$userid=0;
}
//先判断userid在位置列表中是否存在,若不存在,则调用userid=0的数据
$sql=sprintf("select * from itempos as P, itemcon as C where P.itemID=C.itemID and P.itemCol='A' and ifShow=1 and userid='$userid' order by P.itemRow");
$rows = $db->getAll($sql,null,DB_FETCHMODE_ASSOC);
print_r($rows);
?>
<?php
require_once 'DB.php';
$user = 'root';
$pass = '';
$host = 'localhost';
$db_name = 'OA';
$dsn = "mysql://$user:$pass@$host/$db_name";
$dbh=new DB;
$db = $dbh->connect($dsn);
if (DB::isError($db))
{
die ($db->getMessage());
}
$userid=1;
$sql=sprintf("select * from itempos where userid='%s'",$userid);
$rows=$db->getRow($sql,null,DB_FETCHMODE_ASSOC);
if(@DB::isError($rows) || count($rows)<1)
{
$userid=0;
}
//先判断userid在位置列表中是否存在,若不存在,则调用userid=0的数据
$sql=sprintf("select * from itempos as P, itemcon as C where P.itemID=C.itemID and P.itemCol='A' and ifShow=1 and userid='$userid' order by P.itemRow");
$rows = $db->getAll($sql,null,DB_FETCHMODE_ASSOC);
print_r($rows);
?>
我的类实例花一后只能调用一次方法
我发现原因是属性$db在调用方法后发生的变化
为什么呢?
能不能看看我的类是不是写的有问题啊?
感谢```