I was able to fix this problem my self and my system is working fine. Thanks for the suggestions osgood_. ... View more

Hi, Thanks for the useful reply. I actually got my script working now but there is a problem with my ipn file. Once a payment is successful PayPal's IPN doesn't update  my MySQL database. Is there an error in my coding? <?php //Include DB configuration file include 'dbConfig.php'; /* * Read POST data * reading posted data directly from $_POST causes serialization * issues with array data in POST. * Reading raw POST data from input stream instead. */ $raw_post_data = file_get_contents('php://input'); $raw_post_array = explode('&', $raw_post_data); $myPost = array(); foreach ($raw_post_array as $keyval) {   $keyval = explode ('=', $keyval);   if (count($keyval) == 2)   $myPost[$keyval[0]] = urldecode($keyval[1]); } // Read the post from PayPal system and add 'cmd' $req = 'cmd=_notify-validate'; if(function_exists('get_magic_quotes_gpc')) {   $get_magic_quotes_exists = true; } foreach ($myPost as $key => $value) {   if($get_magic_quotes_exists == true && get_magic_quotes_gpc() == 1) {   $value = urlencode(stripslashes($value));   } else {   $value = urlencode($value);   }   $req .= "&$key=$value"; } /* * Post IPN data back to PayPal to validate the IPN data is genuine * Without this step anyone can fake IPN data */ $paypalURL = "https://www.sandbox.paypal.com/cgi-bin/webscr"; $ch = curl_init($paypalURL); if ($ch == FALSE) {   return FALSE; } curl_setopt($ch, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_POSTFIELDS, $req); curl_setopt($ch, CURLOPT_SSLVERSION, 6); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); curl_setopt($ch, CURLOPT_FORBID_REUSE, 1); // Set TCP timeout to 30 seconds curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); curl_setopt($ch, CURLOPT_HTTPHEADER, array('Connection: Close', 'User-Agent: company-name')); $res = curl_exec($ch); /* * Inspect IPN validation result and act accordingly * Split response headers and payload, a better way for strcmp */ $tokens = explode("\r\n\r\n", trim($res)); $res = trim(end($tokens)); if (strcmp(trim($res), "VERIFIED") == 0 || strcasecmp($res, "VERIFIED") == 0) {   //Payment data   $txn_id = $_POST['txn_id'];   $payment_gross = $_POST['mc_gross'];   $currency_code = $_POST['mc_currency'];   $payment_status = $_POST['payment_status'];   $payer_email = $_POST['payer_email'];   //Check if payment data exists with the same TXN ID.   $prevPayment = $db->query("SELECT payment_id FROM payments WHERE txn_id = '".$txn_id."'");   if($prevPayment->num_rows > 0){   exit();   }else{   //Insert tansaction data into the database   $insertPayment = $db->query("INSERT INTO payments(txn_id,payment_gross,currency_code,payment_status,payer_email) VALUES('".$txn_id."','".$payment_gross."','".$currency_code."','".$payment_status."','".$payer_email."')");   if($insertPayment){   //Insert order items into the database   $payment_id = $db->insert_id;   $num_cart_items = $_POST['num_cart_items'];   for($i=1;$i<=$num_cart_items;$i++){   $order_item_number = $_POST['item_number'.$i];   $order_item_quantity = $_POST['quantity'.$i];   $order_item_gross_amount = $_POST['mc_gross_'.$i];   $insertOrderItem = $db->query("INSERT INTO order_items(payment_id,item_number,quantity,gross_amount) VALUES('".$payment_id."','".$order_item_number."','".$order_item_quantity."','".$order_item_gross_amount."')");   }   }   } } ... View more

If I was to attach my files. Would someone be able to take a look and give me advice. Due to my time limit I am unable to learn PHP at this moment. This is for a school project and neither of my teachers are of any use. Thanks Danyaal. ... View more

Hi, I've removed the space and the issue still remains. I am following their tutorial but no matter what I try I still get the same message. Thanks Danyaal, ... View more

Because my teachers can't help. Yes, I'm under 18 I'm still at college. ... View more

Hi, Thanks so much! Danyaal. ... View more

Hi, I have attached my files as a zip.​ Websitecoursework.zip <https://drive.google.com/a/preston-manor.com/file/d/0BxUHVcr21is0WFhYUVRIOGtEbWM/view?usp=drive_web> ​ ... View more

Yes. ... View more

Hi, I've tried that but the colour still remains. ... View more

Hi, I don't have a website yet. I am just testing the site on my internet browser. Thanks Danyaal. ... View more

But then I'll get the message Payment failed. ... View more

Yes, I am following a code from codex world. I managed to fix the above error but I am still getting the error: Notice: Undefined index: tx in /storage/h3/495/770495/public_html/success.php on line 12 Notice: Undefined index: amt in /storage/h3/495/770495/public_html/success.php on line 13 Notice: Undefined index: cc in /storage/h3/495/770495/public_html/success.php on line 14 Notice: Undefined index: st in /storage/h3/495/770495/public_html/success.php on line 15 ... View more

the bracket was missing. ... View more

Hi, I have added a bracket under the code on my success.php file. if($paymentResult->num_rows > 0){           //payment information         $paymentRow = $paymentResult->fetch_assoc();         $payment_id = $paymentRow['payment_id']; } On my success page I now get this message: Parse error: syntax error, unexpected 'else' (T_ELSE) in /storage/h3/495/770495/public_html/success.php on line 53 Have I put too many brackets. Thanks, Danyaal. ... View more

Hi, i am testing it in Sandbox. Once I put in my credentials for PayPal and i am returned to my own website (the success.php) page I get the message in my first post. Thanks, Danyaal ... View more

Hi, I do have <input type='hidden' name='notify_url' value='http://www.xxxxxxxxx.xxxx/ipn/ipn.php'> in my payment form. Unfortunately, my teachers have been unable to help me with this so far. I was hoping for someone to help online. Thanks for the reply though, Danyaal. ... View more

My IPN file: <?php //Include DB configuration file include 'dbConfig.php'; /* * Read POST data * reading posted data directly from $_POST causes serialization * issues with array data in POST. * Reading raw POST data from input stream instead. */ $raw_post_data = file_get_contents('php://input'); $raw_post_array = explode('&', $raw_post_data); $myPost = array(); foreach ($raw_post_array as $keyval) {   $keyval = explode ('=', $keyval);   if (count($keyval) == 2)   $myPost[$keyval[0]] = urldecode($keyval[1]); } // Read the post from PayPal system and add 'cmd' $req = 'cmd=_notify-validate'; if(function_exists('get_magic_quotes_gpc')) {   $get_magic_quotes_exists = true; } foreach ($myPost as $key => $value) {   if($get_magic_quotes_exists == true && get_magic_quotes_gpc() == 1) {   $value = urlencode(stripslashes($value));   } else {   $value = urlencode($value);   }   $req .= "&$key=$value"; } /* * Post IPN data back to PayPal to validate the IPN data is genuine * Without this step anyone can fake IPN data */ $paypalURL = "https://www.sandbox.paypal.com/cgi-bin/webscr"; $ch = curl_init($paypalURL); if ($ch == FALSE) {   return FALSE; } curl_setopt($ch, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); curl_setopt($ch, CURLOPT_POSTFIELDS, $req); curl_setopt($ch, CURLOPT_SSLVERSION, 6); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); curl_setopt($ch, CURLOPT_FORBID_REUSE, 1); // Set TCP timeout to 30 seconds curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30); curl_setopt($ch, CURLOPT_HTTPHEADER, array('Connection: Close', 'User-Agent: company-name')); $res = curl_exec($ch); /* * Inspect IPN validation result and act accordingly * Split response headers and payload, a better way for strcmp */ $tokens = explode("\r\n\r\n", trim($res)); $res = trim(end($tokens)); if (strcmp($res, "VERIFIED") == 0 || strcasecmp($res, "VERIFIED") == 0) {   //Payment data   $txn_id = $_POST['txn_id'];   $payment_gross = $_POST['mc_gross'];   $currency_code = $_POST['mc_currency'];   $payment_status = $_POST['payment_status'];   $payer_email = $_POST['payer_email'];   //Check if payment data exists with the same TXN ID.   $prevPayment = $db->query("SELECT payment_id FROM payments WHERE txn_id = '".$txn_id."'");   if($prevPayment->num_rows > 0){   exit();   }else{   //Insert tansaction data into the database   $insertPayment = $db->query("INSERT INTO payments(txn_id,payment_gross,currency_code,payment_status,payer_email) VALUES('".$txn_id."','".$payment_gross."','".$currency_code."','".$payment_status."','".$payer_email."')");   if($insertPayment){   //Insert order items into the database   $payment_id = $db->insert_id;   $num_cart_items = $_POST['num_cart_items'];   for($i=1;$i<=$num_cart_items;$i++){   $order_item_number = $_POST['item_number'.$i];   $order_item_quantity = $_POST['quantity'.$i];   $order_item_gross_amount = $_POST['mc_gross_'.$i];   $insertOrderItem = $db->query("INSERT INTO order_items(payment_id,item_number,quantity,gross_amount) VALUES('".$payment_id."','".$order_item_number."','".$order_item_quantity."','".$order_item_gross_amount."')");   }   }   } } On my Paypal profile I have set auto return to e.g. mysite.com/success/php Thanks. Danyaal ... View more

Hi, Thanks for your reply. Yes, that is the workflow I am using. I have the ipn.php file on my server and have set up IPN on my PayPal account to the file on my server. Danyaal. ... View more