将mysql资源解压缩到php数组？

Question

My goal is to display the profile of a user. I have this function:

function get_profile($un) {
            if($registerquery = $this->conn->query("SELECT * FROM table WHERE usr = '".$un."' ")){
               return $profile = mysql_fetch_array($registerquery); 
           }
        }

Then the display snippet:

<?php $profile = $mysql->get_profile($un); 

foreach($profile as $key => $value){

     echo "<span>".$key.': '.$value."</span><br />"; 

  }

?>

But I get: "Warning: Invalid argument supplied for foreach() in..."

Help pls???

Answer 1

You need to see if the result was a success or not

if (gettype($result) == "boolean") {
    $output = array('success' => ($result ? 1 : 0));
}

And you need to cycle through it if it's a resource type...

if (gettype($result) == "resource") {
    if (mysql_num_rows($result) != 0 ) {
        while ($row = mysql_fetch_assoc($result)) {
            $output[] =$row;
        }
    }
}

I chopped up some real code that does basically everything pretty awful for you because I can't release it, sorry.