PHP 5 - calling MYSQL 5.5 stored procedure
Posted on 2011-04-22
first of all let me say that I am a DOT NET programmer who for the FIRST time has to code in PHP. I am poirting a web application from DOT NET to PHP. this mean that I am an absolute newbie in PHP with only 2 weeks of experience.
I am trying to get a resultset from PHP via astored procedure in MYSQL 5.5
I tested the stored procedure in the database and it works, however when I try to get the records via PHP I always get a NULL recordset.
below my code. I would appreciate your help with this.
public function authenticateUser($username, $password)
$dbMan = new dbConnect();
$dbName = NULL;
$mySqlConn = NULL;
$resultSet = NULL;
$totalRows = 0;
$sqlQuery = 'call sp_user_authentication(' .$username .',' .$password .')';
$dbName = $dbMan->getDbName();
$mySqlConn = $dbMan->getmySqlConn();
$resultSet = mysqli_query($mySqlConn,$sqlQuery);
if($resultSet != NULL)
$totalRows = mysqli_num_rows($resultSet);