在php中返回sql数组

Question

I am having trouble in returning data in php from an SQL query. here is my code:

      public function get_audit_message($productId,$accountId)
        {
        $sql_list  ="SELECT notes
                     FROM  ".$this->tables_audit."
                     WHERE productId = '".mysql_real_escape_string($productId)."'
                     AND accountId = '".mysql_real_escape_string($accountId)."'
                     ";

        $query = $this->db->query($sql_list);
        if($query->num_rows() > 0)
            {
            $return = $query->result_array();
            return $return;
            }
        else return false;
        }

the reason I am having trouble is that as it is at return $return; returns the correct number of results but only displays the word "array". then if i change it to return $return[0]; returns the first entry of information correctly.

So what i want to be able to do is select all array numbers e.g return $return[*]; if only was possible.

Any suggestions would be much appreciated.

Answer 1

There is several easy ways to display content of PHP Array in HTML.

The most simple is to view it via print_r command like this:

print_r ($my_array);

If you need to be "nice" formatted, add PRE tag like this:

echo "<pre>";
print_r($my_array);
echo "</pre>";

or like this:

echo "<pre>".print_r($my_array, 1)."</pre>";

Also, there is similar var_dump and var_export PHP function:

echo "<pre>";
var_dump($my_array);
echo "</pre>";

or

echo "<pre>";
var_export($my_array);
echo "</pre>";

Just choose your preferred stile.