PHP Help Needed - Noobie

[aodat2]

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;
}
?>

[webref.eu]

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

[aodat2]

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.

[webref.eu]

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

 

 

[aodat2]

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;