PHP: Trouble with mysql statement.

Question

I am having a public function doing query for mysql. Everything works great in my local computer but having trouble once it was uploaded to the godaddy server. Basically, the $rows is null when I called the method.

I am sure the database data are correct and the query should return few records. I have spent hours trying to figure it out but have no luck. I was hoping you guys can help me out on this one. Thanks in advance.

Code

    class test{

     public function getEmployees($username,$password) {



         $stmt = mysqli_prepare($this->connection,
              "SELECT name, password
               FROM employee
               WHERE name='$username' && password='$password'
               ");     

          $this->throwExceptionOnError();

          mysqli_stmt_execute($stmt);
          $this->throwExceptionOnError();

          $rows = array();


          while (mysqli_stmt_fetch($stmt)) {
              $rows[] = $row;
              $row = new stdClass();
              mysqli_stmt_bind_result($stmt,  $row->name, $row->password);
          }
          if(mysqli_stmt_num_rows($stmt)==0){

              return false;
          }else{
              return $rows;
          }



          mysqli_stmt_free_result($stmt);
          mysqli_close($this->connection);
   }

}

$test=new test();
$row=$test->getEmployees('bob','1111');
echo "<pre>";
print_r($row);
echo "</pre>";

//it prints nothing on the page

Thanks guys, I just figured it out. I had to change mysqli_stmt_num_rows($stmt)==0 to mysqli_stmt_num_rows($stmt). Not sure why though. — Rouge
– Rouge, Commented May 3, 2012 at 3:31

bitoshi.n · Accepted Answer · 2012-05-03 03:22:05Z

1

I think the problem is code structure. Try:

class test{

     public function getEmployees($username,$password) {



         $stmt = mysqli_prepare($this->connection,
              "SELECT name, password
               FROM employee
               WHERE name='$username' && password='$password'
               ");     

          $this->throwExceptionOnError();

          mysqli_stmt_execute($stmt);
          $this->throwExceptionOnError();

          $rows = array();
          $row = new stdClass();
          mysqli_stmt_bind_result($stmt,  $row->name, $row->password);

          while (mysqli_stmt_fetch($stmt)) {
              $rows[] = $row;

          }

          mysqli_stmt_free_result($stmt);
          mysqli_close($this->connection);
          $temp = mysqli_stmt_num_rows($stmt); 
          if($temp==0){

              return false;
          }else{
              return $rows;
          }



   }

}

$test=new test();
$row=$test->getEmployees('bob','1111');
echo "<pre>";
print_r($row);
echo "</pre>";

answered May 3, 2012 at 3:22

bitoshi.n

2,3381 gold badge16 silver badges16 bronze badges

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

1 Comment

Rouge Over a year ago

Thanks man. Please see my comment. Your code would work for me too. I will give u green. :D

Collectives™ on Stack Overflow

PHP: Trouble with mysql statement.

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related