为什么fetch_array() 得不到数据?该如何解决
程序员文章站
2022-03-27 13:23:57
...
为什么fetch_array() 得不到数据?
function query($sql) {
$this->sql = $sql;
$result = mysql_query($sql,$this->conn) or die(mysql_error());
if (!$result) {
$this->show("错误SQL语句",$sql);
} else {
$this->result = $result;
}
}
function select($table, $columnName = "*", $condition = '') {
$condition = $condition ? ' WHERE ' . $condition : NULL;
$this->query("SELECT $columnName FROM $table $condition");
}
function fetch_array() {
if(!mysql_fetch_array($this->result)){
$this->show("错误执行");
}else{
return mysql_fetch_array($this->result);
}
}
------解决方案--------------------
function query($sql) {
$this->sql = $sql;
$result = mysql_query($sql,$this->conn) or die(mysql_error());
if (!$result) {
$this->show("错误SQL语句",$sql);
} else {
$this->result = $result;
}
}
function select($table, $columnName = "*", $condition = '') {
$condition = $condition ? ' WHERE ' . $condition : NULL;
$this->query("SELECT $columnName FROM $table $condition");
}
function fetch_array() {
if(!mysql_fetch_array($this->result)){
$this->show("错误执行");
}else{
return mysql_fetch_array($this->result);
}
}
------解决方案--------------------
- PHP code
function fetch_array() { if(! $this->result){ $this->show("错误执行"); }else{ return mysql_fetch_array($this->$result); }相关文章
相关视频