call informix sp using PHP3 in this way,right?
Posted in 2000
Hi, All: I am the beginner of Informix and PHP3 Now I want to use Sotred Procedure in PHP3 File, I write it in the following way, Is it Right? Please Help me <? $sql3="EXECURE PROCEDURE addcashcheque($user_id,'$order_id',$cheque,'$invoice_no','$location',$euid,$ cash,$cheque) INTO :result "; $result3=ifx_query($sql3,$connection); if (! $result3) { printf("Can't select orders : %s\\n<br>%s<br>\\n", ifx_error()); ifx_errormsg(); die; } $row = ifx_fetch_row ($result3, "NEXT"); while (is_array($row)) { for(reset($row); $fieldname=key($row); next($row)) { $fieldvalue = $row[$fieldname]; $result = $row["result"]; } $row = ifx_fetch_row ($result3, "NEXT"); } ifx_free_result ($result3); if ($result=-1) { echo "error money"; exit;} ?> Looking forward your help. :-)) Thank you all Thank you in advance . 2000.03.22