为什么我们在某个地方使用fetch_array（）而在其他地方使用result（）？

Question

I am following the Codeigniter framework. I just learn't how to connect to database and retrieve values. My model function is :-

public function getAll()
    {

        $query = $this->db->query("SELECT * FROM company_basic_details");

        return $query->result();

    }

Why do we not use fetch_array() or fetch_assoc() or mysqli* here. In the first OO php-mysql program I used :-

$query = "SELECT company_id FROM company_basic_details WHERE company_name = 'ABC'";
$result = $db->query($query);

while($row = $result->fetch_array())
{
    echo $row['company_id'];
}

Why we use fetch_array() at some place and result() in other places?

Answer 1

Look at closer. No difference?

$query->result()
$result->fetch_array()

$query->result() is array of associative array i.e. result set. $result->fetch_array() here you fetch one row from result set i.e. associative array.