Okay, forget about that first script. I'm now using the IPN Class from Trivia Shock. The IPN script is working great! However, I'm still having difficulties getting data into my database.

// If we made it down here, the order is verified and payment is complete.
// You could log the order to a MySQL database or do anything else at this point.
//Write the data to my own database
$item_name = $HTTP_POST_VARS['item_name'];
$receiver_email = $HTTP_POST_VARS['receiver_email'];
$item_number = $HTTP_POST_VARS['item_number'];
$payment_status = $HTTP_POST_VARS['payment_status'];
$payment_gross = $HTTP_POST_VARS['payment_gross'];
$payer_email = $HTTP_POST_VARS['payer_email'];
$quantity = $HTTP_POST_VARS['quantity'];
$payment_date = $HTTP_POST_VARS['payment_date'];
$first_name = $HTTP_POST_VARS['first_name'];
$last_name = $HTTP_POST_VARS['last_name'];
$address_street = $HTTP_POST_VARS['address_street'];
$address_city = $HTTP_POST_VARS['address_city'];
$address_state = $HTTP_POST_VARS['address_state'];
$address_zip = $HTTP_POST_VARS['address_zip'];

$db = mysql_connect('localhost','username','password');
mysql_select_db('dbname');
$resultat_sql = mysql_query("INSERT INTO orders ('item_name', 'receiver_email', 'item_number', 'payment_status', 'payment_gross', 'payer_email', 'quantity', 'payment_date', 'first_name', 'last_name', 'address_street', 'address_city', 'address_state', 'address_zip') VALUES ('$item_name', '$receiver_email', '$item_number', '$payment_status', '$payment_gross', '$payer_email', '$quantity', '$payment_date', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip'");


Am I even close?



haydiz

Thanks, I changed the code. However, I'm data isn't being inserted into my database. I'm having no problems with the IPN system itself. I've had several orders verified and completed.

Here's the entire code (from trivia shock and my added on MySQL statements):

<?php
////////////////////////////////////////////////////////////////////////////////
// example.php
// PHP paypal_ipn class example
////////////////////////////////////////////////////////////////////////////////

require("paypal_ipn.php");

// PayPal will send the information through a POST
$paypal_info = $HTTP_POST_VARS;

$paypal_ipn = new paypal_ipn($paypal_info);

// where to contact us if something goes wrong
$paypal_ipn->error_email = "email@email.com";

// We send an identical response back to PayPal for verification
$paypal_ipn->send_response();

// PayPal will tell us whether or not this order is valid.
// This will prevent people from simply running your order script
// manually
if( !$paypal_ipn->is_verified() )
{
// bad order, someone must have tried to run this script manually
$paypal_ipn->error_out("Bad order (PayPal says it's invalid)");
}

// payment status
switch( $paypal_ipn->get_payment_status() )
{
case 'Completed':
// order is good
break;

case 'Pending':
// money isn't in yet, just quit.
// paypal will contact this script again when it's ready
$paypal_ipn->error_out("Pending Payment");
break;

case 'Failed':
// whoops, not enough money
$paypal_ipn->error_out("Failed Payment");
break;

case 'Denied':
// denied payment by us
// not sure what causes this one
$paypal_ipn->error_out("Denied Payment");
break;

default:
// order is no good
$paypal_ipn->error_out("Unknown Payment Status" . $paypal_ipn->get_payment_status());
break;

} // end switch



// If we made it down here, the order is verified and payment is complete.
// You could log the order to a MySQL database or do anything else at this point.

//Write the data to my own database
$item_name = $HTTP_POST_VARS['item_name'];
$receiver_email = $HTTP_POST_VARS['receiver_email'];
$item_number = $HTTP_POST_VARS['item_number'];
$payment_status = $HTTP_POST_VARS['payment_status'];
$payment_gross = $HTTP_POST_VARS['payment_gross'];
$payer_email = $HTTP_POST_VARS['payer_email'];
$quantity = $HTTP_POST_VARS['quantity'];
$payment_date = $HTTP_POST_VARS['payment_date'];
$first_name = $HTTP_POST_VARS['first_name'];
$last_name = $HTTP_POST_VARS['last_name'];
$address_street = $HTTP_POST_VARS['address_street'];
$address_city = $HTTP_POST_VARS['address_city'];
$address_state = $HTTP_POST_VARS['address_state'];
$address_zip = $HTTP_POST_VARS['address_zip'];

$db = mysql_connect('localhost','username','password');
mysql_select_db('db_name');
$resultat_sql = mysql_query("INSERT INTO orders ('item_name', 'receiver_email', 'item_number', 'payment_status', 'payment_gross', 'payer_email', 'quantity', 'payment_date', 'first_name', 'last_name', 'address_street', 'address_city', 'address_state', 'address_zip') VALUES ('$item_name', '$receiver_email', '$item_number', '$payment_status', '$payment_gross', '$payer_email', '$quantity', '$payment_date', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip')",$db);


// Email the information to us
$date = date("D M j G:i:s T Y", time());


I'm not an expert PHP programmer (kinda obvious) but if anybody can help, I sure would appreciate it!




haydiz

I do have a primary key field (auto_increment). Nothing is being inserted into it as well.

I've double checked my fields and they all match.



haydiz

Okay, I totally scrapped both of the scripts above. I copied the PHP code from PayPal and added a MySQL insert statement and Hallelujah it works!

However, there is still a problem. It inserts all of the data except the 'item_name', 'item_number', and 'quantity' fields. But atleast I'm getting something in my database!

Here's the code:

<?php
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);

// assign variables
$item_name = $_POST['item_name'];
$receiver_email = $_POST['receiver_email'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_gross = $_POST['payment_gross'];
$payer_email = $_POST['payer_email'];
$quantity = $_POST['quantity'];
$payment_date = $_POST['payment_date'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$address_street = $_POST['address_street'];
$address_city = $_POST['address_city'];
$address_state = $_POST['address_state'];
$address_zip = $_POST['address_zip'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// process payment
//Write the data to my own database

$db = mysql_connect('localhost','username','pass');
mysql_select_db('db_name');
$resultat_sql = mysql_query("INSERT INTO orders (item_name, receiver_email, item_number, payment_status, payment_gross, payer_email, quantity, payment_date, first_name, last_name, address_street, address_city, address_state, address_zip) VALUES ('$item_name', '$receiver_email', '$item_number', '$payment_status', '$payment_gross', '$payer_email', '$quantity', '$payment_date', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip')",$db);

}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>


haydiz

Here is the correct code for inserting records into your MySQL database.

<?php
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);

// assign variables
$item_name = $_POST['item_name1'];
$receiver_email = $_POST['receiver_email'];
$item_number = $_POST['item_number1'];
$payment_status = $_POST['payment_status'];
$payment_gross = $_POST['payment_gross'];
$payer_email = $_POST['payer_email'];
$quantity = $_POST['quantity1'];
$payment_date = $_POST['payment_date'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$address_street = $_POST['address_street'];
$address_city = $_POST['address_city'];
$address_state = $_POST['address_state'];
$address_zip = $_POST['address_zip'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// process payment
//Write the data to my own database

$db = mysql_connect('localhost','username','pass');
mysql_select_db('database_name');
$resultat_sql = mysql_query("INSERT INTO orders (item_name, receiver_email, item_number, payment_status, payment_gross, payer_email, quantity, payment_date, first_name, last_name, address_street, address_city, address_state, address_zip) VALUES ('$item_name1', '$receiver_email', '$item_number1', '$payment_status', '$payment_gross', '$payer_email', '$quantity1', '$payment_date', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip')",$db);

}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>


haydiz

I have tried out the last script you were using, and the script is posting back to paypal. I have included the script below. Please help. I have been trying to get the paypal IPN working a number of different ways with no luck and I am starting to pull out all my hair.

Thank you in advance,

<?php
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);

// assign variables
$receiver_email = $_POST['receiver_email'];
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$quantity = $_POST['quantity'];
$invoice = $_POST['invoice'];
$custom = $_POST['custom'];
$payment_status = $_POST['payment_status'];
$pending_reason = $_POST['pending_reason'];
$payment_date = $_POST['payment_date'];
$exchange_rate = $_POST['exchange_rate'];
$payment_gross = $_POST['payment_gross'];
$payment_fee = $_POST['payment_fee'];
$txn_id = $_POST['txn_id'];
$txn_type = $_POST['txn_type'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$address_street = $_POST['address_street'];
$address_city = $_POST['address_city'];
$address_state = $_POST['address_state'];
$address_zip = $_POST['address_zip'];
$address_country = $_POST['address_country'];
$address_status = $_POST['address_status'];
$payer_email = $_POST['payer_email'];
$payer_id = $_POST['payer_id'];
$payer_status = $_POST['payer_status'];
$payment_type = $_POST['payment_type'];
$verify_sign = $_POST['verify_sign'];
$subscr_date = $_POST['subscr_date'];
$subscr_effective = $_POST['subscr_effective'];
$period1 = $_POST['period1'];
$period2 = $_POST['period2'];
$period3 = $_POST['period3'];
$amount1 = $_POST['amount1'];
$amount2 = $_POST['amount2'];
$amount3 = $_POST['amount3'];
$recurring = $_POST['recurring'];
$reattempt = $_POST['reattempt'];
$retry_at = $_POST['retry_at'];
$recur_times = $_POST['recur_times'];
$username = $_POST['username'];
$password = $_POST['password'];
$subscr_id = $_POST['subscr_id'];

if (!$fp) {
// HTTP ERROR
echo "http error";
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
if (strcmp ($payment_status, "Completed") == 0) {
$qry = "SELECT password FROM paypal WHERE item_number = \"$item_number\" ";
$result = mysql_query($qry,$db);
while ($myrow = mysql_fetch_row($result)) { $passwd = $myrow[0]; }
$message .= "Dear Customer,\n Thankyou for your order.\n\nThe password for the item you ordered is: $row[0]\n\nIf you have any problems, please contact us: \n\nholla\@hiphopg.com";
mail($payer_email, "Your Book Password...", $message, "From: holla@hiphopg.com\nReply-To: holla@hiphopg.com");
echo "It worked.";
// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// process payment
//Write the data to my own database

$db = mysql_connect('localhost','user','pass');
mysql_select_db('db');
$resultat_sql = mysql_query("INSERT INTO paypal(receiver_email,item_name,item_number,quantity,invoice,custom,payment_status,pending_reason,payment_date,payment_gross,payment_fee,txn_id,txn_type,first_name,last_name,address_street,address_city,address_state,address_zip,address_country,address_status,payer_email,payer_status,payment_type,verify_sign,subscr_date,period1,period2,period3,amount1,amount2,amount3,recurring,reattempt,retry_at,recur_times,username,password,subscr_id )
VALUES ('$invoice', '$receiver_email', '$item_name', '$item_number', '$quantity', '$payment_status', '$pending_reason', '$payment_date', '$payment_gross', '$payment_fee', '$txn_id', '$txn_type', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip', '$address_country', '$address_status', '$payer_email', '$payer_status', '$payment_type', '$custom', '$verify_sign', '$subscr_date','$period1', '$period2','$period3','$amount1','$amount2','$amount3','$recurring','$reattempt','$retry_at','$recure_times','$username','$password','$subscr_id' ) ",$db);

}
else if (strcmp ($res, "INVALID") == 0) {
echo "invalid";
// log for manual investigation
}
}
fclose ($fp);
}
?>

Hi,

Yes we have a solution built exactly for this. Send us an email if you have specific questions or if you are looking for a system tailored to your needs.

Cheers,

Sharad Goel
Well Drafted Consultants Inc.
http://www.welldrafted.net