Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #9213

determine a mysqli_result object

Show all headers | View raw

I have a class that I am converting from mysql to mysqli in PHP 5.2.x

The problem I ran into is this.

Previously I could check the mysql_query if it return a resource by using:

is_resource($resource)

and could parse the resource using mysql_fetch_assoc or similar

and if it was an insert, update, etc.. it would not return a resource 
and I would just return a true and carry on.

Now with mysqli it return a mysql_result object.

How do I check for this so I know whether to parse or return

Thanks

Here is a nutshell of what was using for mysql

// Already connected to mysqli

public function query($query){
  $resource = $this->connection->query($query);

  if($resource) {

   if(is_resource($resource)) { // parse

    $data = array();

    $idx = 0;

    while($result = $this->connection->fetch_assoc()) {

     $data[$idx] = $result;
     // Object assembly

    }
   } else { // return

    // update, insert, etc..
    return true;

   }
  } else {
   // error
  }
}

Scotty

Back to comp.lang.php | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

determine a mysqli_result object Scott Johnson <noonehome@chalupasworld.com> - 2013-04-27 16:11 -0700
  Re: determine a mysqli_result object Scott Johnson <noonehome@chalupasworld.com> - 2013-04-27 16:18 -0700

csiph-web