Problem with mysqli num rows

Question

I have a function i use for selecting from the database

function selectquery ($sql, $types, $params)
    {
       $connection = getConnect ();
       $result = $connection->prepare("$sql");
       $result->bind_param($types, $params);
       $status = $result->execute();
       $result->store_result();
       $return=array('obj'=>$result, 'status' => $status, 'data'=>array());
       $meta = $result->result_metadata();  
       while ( $field = $meta->fetch_field() ) 
       {  
            $parameters[] = &$row[$field->name];  
       }  
       call_user_func_array(array($result, 'bind_result'), $parameters);  

       while ( $result->fetch()) 
       {  
          $x = array();  
          foreach( $row as $key => $val ) 
          {  
             $x[$key] = $val;  
          }  
          $return['data'][] = $x;  
       } 
       $result->close(); 
       return $return; 
    }

When i run my query:

$resultobj=selectquery ("select id from employers where subdomain = ? ", "s", $reg_subdomain);
if ($resultobj['obj']->num_rows()>0 || in_array($reg_subdomain, $locked_subdomains)) { $error .="Subdomain already exist, please choose another <br>"; }

I get this error message:

Warning: mysqli_stmt::num_rows() [mysqli-stmt.num-rows]: Couldn't fetch mysqli_stmt in /home/drac/public_html/dracxyz.com/functions.php on line 174

Please what am i not doing right?

Thanks

did you try $resultobj->num_rows

Haim Evgi
– Haim Evgi

2011-09-14 09:50:28 +00:00
Commented Sep 14, 2011 at 9:50 — Haim Evgi
– Haim Evgi, Commented Sep 14, 2011 at 9:50

Jonan · Accepted Answer · 2014-02-15 18:37:00Z

1

Use it like

$resultobj->num_rows()

http://php.net/manual/en/mysqli-result.num-rows.php

edited Feb 15, 2014 at 18:37

Jonan

2,5363 gold badges27 silver badges45 bronze badges

answered Sep 14, 2011 at 9:51

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ogugua Belonwu Over a year ago

i changed to your suggestion and got this error: Warning: processform() [function.processform]: Couldn't fetch mysqli_stmt in /home/drac/public_html/dracxyz.com/functions.php on line 174

Haim Evgi Over a year ago

you need to work on $result but you dont return him and close him $result->close()

Collectives™ on Stack Overflow

Problem with mysqli num rows

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related