CodeIgniter将mysql行转换为对象

Question

I want to convert a mysql row into an object with property => value

example

$query = "SELECT * FROM blah...";
if($query->num_rows() > 0)
{
    foreach($query->result_array() as $row)
    {
        $notification = new stdClass();
        //this is where I don't know what to do
        for every coloumn
            $notification->coloumn_name = value at that coloumn;
        //end of cluelessness   
        return $notification;
    }
}

Answer 1

Use $query->result() in foreach loop of yours..

This function returns the query result as an array of objects, or an empty array on failure.

Also see this for more information...