title: How to fetch data using procedure in PHP?
body: <p>I am using procedure first time.How can I fetch data using procedure.I created this procedure in sql file.</p>
  
  <pre><code>CREATE  PROCEDURE `GetUserProfile`(IN p_user_id INT, IN p_enabled BIT)
  READS SQL DATA
  BEGIN
  # prepare init params
  if p_user_id = 0 then
  set p_user_id = null;
  end if;
  
  select  parent_user_id
        ,user_id
        ,Last_name
        ,First_name
        ,email as Email_address
        ,mobile as Phone
  from    app_users
  where   app_user_id = IFNULL(p_user_id, user_id)
  </code></pre>
  
  <p>and     enabled = IFNULL(p_enabled, enabled);</p>
  
  <p>then How can I fetch the user detail through PHP like First_name,Last_name etc.
  thanks</p>