Question

Notice: Undefined offset: 0 in D:\phpStudy\www\web\htdocs\class\sql.php on line 46

Notice: Undefined offset: 0 in D:\phpStudy\www\web\htdocs\class\sql.php on line 46
sql.php46行代码是下面最后一行代码，return $data[0]; 在线等，分数可追加
<?php class sql
{
public $config =array
(
'host' => 'localhost',
'user' => 'root',
'pwd' => 'sa',
'dbname' => 'hdm0820416_db',
'charset' => 'utf8'
);

public $query;
public $cache;
public function __construct() {
$config = $this->config;
$conn2=mysql_connect($config['host'],$config['user'],$config['pwd'],1,131072) or die("Could not connect: ".mysql_error());
$db= mysql_select_db($config['dbname'],$conn2) or die("Could not select database");;
mysql_query("SET NAMES ".$config['charset']);
$this->cache = new Cache();
}
/**
* 执行sql语句
* @param unknown $sql
* @param unknown $tableName
* @param string $update
* @return resource
*/
public function query($sql,$tableName,$update=FALSE) {

if ($update==true){
//删除缓存
$this->cache->delSql($tableName);
}
$this->query=mysql_query($sql) or exit ($sql);
return $this->query;
}
/**
* 获得一条
* @param unknown $tableName
* @param unknown $column
* @param unknown $where
* @return Ambigous <>
*/
public function onedata($tableName,$column=" * ",$where=""){
$data= $this->datalist ($tableName,$column,$where,1);
return $data[0];
}

?>

Answer 1

意思是没有设置偏移量，可能是$data不是数组，把[0]去掉试试

追问

去掉之后异常没有了！谢谢！不过好像数据库还是没有连接

追答

嗯，不客气，是的，数据库连接不成功就没有结果了