Help in Database Procedure returns value

Discussion in 'Programming' started by AimyThomas, Sep 17, 2012.

  1. #1
    We have a database procedure that returns a value by reference.

    This is how it is used in ABF:
    h_status = pr_get_passphrase
    (h_passphrase = BYREF:)gv_passphrase));

    Is it possible to do the same in PHP?
     
    AimyThomas, Sep 17, 2012 IP
  2. DaBrounsi

    DaBrounsi Peon

    Messages:
    17
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    3
    #2
    but php uses SQL to request the data. So u store ur SQL Query in a var and then run the mysql_query() command with that statement as paramter. You'll get an result which can be transformed into an array. If you are requesting more than one row u'll need to loop over the result for building that array.

    Just google for mysql_query and mysql_fetch_assoc or mysql_fetch_array
     
    DaBrounsi, Sep 18, 2012 IP