How to call a MySQL stored procedure from within PHP code

Question

I have stored procedure that I created in MySQL and want PHP to call that stored procedure   What is the best way to do this   -MySQL client version  4 1 11 -MySQL Server version  5 0 45    Here is my stored procedure   DELIMITER     DROP FUNCTION IF EXISTS  getNodeName     CREATE FUNCTION  getTreeNodeName   nid  int  RETURNS varchar 25  CHARSET utf8 BEGIN  DECLARE nodeName varchar 25    SELECT name into nodeName FROM tree  WHERE id   nid   RETURN nodeName  END     DELIMITER     What is the PHP code to invoke the procedure getTreeNodeName

User · Answer

You can call a stored procedure using the following syntax    result   mysql query  CALL getNodeChildren 2

User · Answer

This is my solution with prepared statements and stored procedure is returning several rows not only one value    lt  php  require  config php   header  Content-type application json     connection- gt set charset  utf8      mIds     GET  ids      stmt    connection- gt prepare  CALL sp takes string returns table        stmt- gt bind param  s    mIds     stmt- gt execute      result    stmt- gt get result     response    result- gt fetch all MYSQLI ASSOC   echo json encode  response     stmt- gt close     connection- gt close

User · Answer

I now found solution by using mysqli instead of mysql    lt  php      enable error reporting mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT     connect to database  connection   mysqli connect  hostname    user    password    db    port       run the store proc  result   mysqli query  connection   CALL StoreProcName       loop the result set while   row   mysqli fetch array  result           echo  row 0      -        row 1        I found that many people seem to have a problem with using mysql connect  mysql query and mysql fetch array

User · Answer

lt  php      res   mysql query  SELECT getTreeNodeName 1  AS result        if   res     false            echo mysql errno        mysql error              while   obj   mysql fetch object  res             echo  obj- gt result

[php] How to call a MySQL stored procedure from within PHP code?

Examples related to php

Examples related to mysql

Examples related to stored-procedures

Examples related to mysqli

Examples related to user-defined-functions