如何使用PHP将MySQL的记录转换为值对象

Question

I have this code:

$Result = DBQuery("SELECT user_id,nick_name,email FROM users LIMIT $fromindex.",".$numOfUsers);
if ($Result)
{
     $resultUsers->UersData=$Result;
}

The problem is that the results U get are in some kind of format that i don't know.

I want to get the results in array format, which every element of that array should be a value object class of this type:

class UserVO {
    var $_explicitType="UserVO";

    var $id;

    var $nickName;

    var $email;
}

Any idea how it can be done?

Answer 1

My answer might not sound very helpful, regarding your unclear question. I am supposing, that the function DBquery returns the result of mysql_query(......). If thats true, then you are feeding the userData with a Resource string which is a resource data type.

There are few ways to access such resource String

1. If the query exports multiple results

   while($row = mysql_fetch_assoc($userData) {
      print_r($row); //This is where you will get your mysql rows.
   }
   

2. If the query return single row

   $row = mysql_fetch_assoc($userData);
   print_r($row); // //This is where you will get your mysql rows.
   

Here are some must check links

• http://php.net/manual/en/function.mysql-fetch-assoc.php
• http://www.php.net/manual/en/function.mysql-fetch-array.php
• http://www.php.net/manual/en/function.mysql-fetch-row.php