开发者

mysqli DESCRIBE returns only one row

开发者 https://www.devze.com 2023-02-22 10:36 出处:网络
Structure: CREATE TABLE `links` ( `id` int(11) NOT NULL auto_increment, `title` int(11) default NULL, `url` varchar(200) NOT NULL,

Structure:

CREATE TABLE `links` (
 `id` int(11) NOT NULL auto_increment,
 `title` int(11) default NULL,
 `url` varchar(200) NOT NULL,
 `seourl` varchar(150) default NULL,
 `linkset` varchar(50) NOT NULL default 'main',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

I'm experiencing a weird problem here, query DESCRIBE links returns only first row (id).

// my query...
$data = $db->query('DESCRIBE `links`')->fetch();

// query function
public function query($sql, $id = false){
    $this->query_id = mysqli_query($this->connection, $sql);
    if(!$this->query_id){
        psyo::error("Error while executing query (sql: {$sql}).");
        return NULL;
    }else{
        $this->result = mysqli_store_result($this->connection);
        $this->affected = mysqli_affected_rows($this->connection);
        return $id ? $this->query_id : $this;
    }
}

// fetch function
public function fetch($query_id = NULL){
    if($query_id)
        $this->query_id = $query_id;
    if($this->query_id){
        $data = mysqli_fetch_assoc($this->query_id);
    }else{
        psyo::error("Error while fetching results (query id: {$this->query_id}).");
    }
    $this->free();
    return $data;
}

// connection set by
public function connect(){
    $this->connection = mysqli_connect($this->server, $this->username, $this->password, $this->database);
    if(!开发者_如何转开发$this->connection){
        psyo::error("Error connecting to server or while selecting database (database: {$this->database}).");
    }
}

So those are my functions taken out of a class (ask if more needed...), and yes, the performed query returns only first row, but $this->affected returns the correct value of 5 in this case.

Returns anticipated result when query is run within phpMyAdmin.

What could be the problem?


Ah, found out the problem myself, looks like my fetch() function returned only first row. Changed it a little and it works:

public function fetch($all = false, $query_id = NULL){
    if($query_id)
        $this->query_id = $query_id;
    if($this->query_id){
        if($all){
            while($row = mysqli_fetch_assoc($this->query_id)){
                $data[] = $row;
            }
        }else{
            $data = mysqli_fetch_assoc($this->query_id);
        }
    }else{
        psyo::error("Error while fetching results (query id: {$this->query_id}).");
    }
    $this->free();
    return $data;
}

Damn those heedless mistakes...

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号