how do I know whether a procedure is called from PHP??
Posted: Wed Apr 12, 2006 1:46 pm
I have a procedure declared and I am making a call from PHP but I am not sure whether it is working but the query generated from PHP when run directly from Mysql client or any other Mysql tool works properly, I suspect the procedure is not called... Can anyone point me whether I am doing anything wrong or there is any method available to know whether a procedure is called???
Code: Select all
mysql call:
call SavedItemsToShoppingCartLines(55);
+------------+------------------------+
| m_quantity | m_doesProductExistInSC |
+------------+------------------------+
| 1 | NULL |
+------------+------------------------+
1 row in setCode: Select all
$query = "call SavedItemsToShoppingCartLines({$User->getObjID()});";
echo $query;
$result = $conn->query($query);
if ($result){
//echo "valid result returned";
}
echo $conn->affected_rows;Code: Select all
output of above php code:
call SavedItemsToShoppingCartLines(55);-1