aodat2 Posted August 13, 2008 Share Posted August 13, 2008 I was given a code which I am suppose to incorporate into my website. Can someone be kind enough to help me by telling me what I should do here to make the code work? I do understand that in the end of the Function, it will return a value or something like that which is in the variable $Result but can someone tell me what else I am suppose to do to get the Function working or how am I suppose to call the Function? Thanks a lot for the help in advance. <?PHP function Requery(){ $query = "http://www.mobile88.com/epayment/enquiry.asp?MerchantCode=" . $MerchantCode . "&RefNo=" . $RefNo . "&Amount=" . $Amount; $url = parse_url($query); $host = $url["host"]; $path = $url["path"] . "?" . $url["query"]; $timeout = 1; $fp = fsockopen ($host, 80, $errno, $errstr, $timeout); if ($fp) { fputs ($fp, "GET $path HTTP/1.0\nHost: " . $host . "\n\n"); while (!feof($fp)) { $buf .= fgets($fp, 128); } $lines = split("\n", $buf); $Result = $lines[count($lines)-1]; fclose($fp); } else { # enter error handing code here } return $Result; } ?> Link to comment https://forums.phpfreaks.com/topic/119474-php-help-needed-noobie/ Share on other sites More sharing options...
webref.eu Posted August 13, 2008 Share Posted August 13, 2008 Hi You need to break your questions down to step by step. Tell us the first step that you are trying to achieve, with more background details, and someone here may be able to help. Rgds Link to comment https://forums.phpfreaks.com/topic/119474-php-help-needed-noobie/#findComment-615459 Share on other sites More sharing options...
aodat2 Posted August 13, 2008 Author Share Posted August 13, 2008 Oh ok, I think I got it working already. The only problem I have now is what's left unknown. I have the variables $MerchantCode and $RefNo but I do not have the amount. Could you tell me how I could obtain a value from a MySQL table? Example: Payment_Table contains the fields Name, Address, Amount, RefNo and Transaction_ID. How could I get the variable from the MySQL table out so that I could use it? Thanks for the help in advance. Link to comment https://forums.phpfreaks.com/topic/119474-php-help-needed-noobie/#findComment-615519 Share on other sites More sharing options...
webref.eu Posted August 13, 2008 Share Posted August 13, 2008 Very rough answer: Run an SQL query against your database: //store the SQL query in the result variable $result = mysql_query("SELECT * FROM YourTable WHERE YourId LIKE 10"); (write your own LIKE clause) Run your query: //associative array allows you to use field names to get results while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { .... Refer to your field name to get it's value: echo '<td>' . $row[ReviewId] . '</td>'; Rgds Link to comment https://forums.phpfreaks.com/topic/119474-php-help-needed-noobie/#findComment-615537 Share on other sites More sharing options...
aodat2 Posted August 13, 2008 Author Share Posted August 13, 2008 The funniest problem is that I got everything correct already. But when I try running the script and see if it works, it gives me "Invalid Parameter". Not too sure what's wrong but if you actually enter the URL into the browser, it will work perfectly fine. Something is definitely wrong somewhere. Can someone actually help me by telling me what I did wrong or where is wrong? $MerchantCode = "12345"; $RefNo = "22"; $Amount_Paid = "1.00"; function Requery(){ $query = "http://www.mobile88.com/epayment/enquiry.asp?MerchantCode=" . $MerchantCode . "&RefNo=" . $RefNo . "&Amount=" . $Amount_Paid; $url = parse_url($query); $host = $url["host"]; $path = $url["path"] . "?" . $url["query"]; $timeout = 1; $fp = fsockopen ($host, 80, $errno, $errstr, $timeout); if ($fp) { fputs ($fp, "GET $path HTTP/1.0\nHost: " . $host . "\n\n"); while (!feof($fp)) { $buf .= fgets($fp, 128); } $lines = split("\n", $buf); $Result = $lines[count($lines)-1]; fclose($fp); } else { # enter error handing code here } return $Result; } $verify = Requery(); echo $verify; Link to comment https://forums.phpfreaks.com/topic/119474-php-help-needed-noobie/#findComment-615650 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.