Well im currently coding up a paypal payment system to go with a user system for a site, and when someone goes through paypal, paypal pushes info to this script. Problem is, the script does not log anything to MySQL, and I can't figure out why. Anyone here want to see what may be wrong?

mysql_connect("localhost", "****", "****") or die(mysql_error());
mysql_select_db("****") or die(mysql_error());
// 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('ssl://www.sandbox.paypal.com', 443, $errno, $errstr, 30);
// assign posted variables to local variables
$item_name = $_POST['item_name'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$txn_id = $_POST['txn_id'];
$payer_email = $_POST['payer_email'];
$name = $_POST['first_name'] . " " . $_POST['last_name'];
$address_street = $_POST['address_street'];
$address_zip = $_POST['address_zip'];
$address_city = $_POST['address_city'];
$contact_phone = $_POST['contact_phone'];
$email = $_POST['payer_email'];
//timezone set
//acc start date
$aaa = time();
//acc end date
$bbb = strtotime("+30 day");
//set acctype
if ($payment_amount == "35.00")
    $acctype = "1";
} elseif ($payment_amount == "45.00")
    $acctype = "2";
} else
if (!$fp)
} else
    fputs($fp, $header . $req);
    while (!feof($fp))
        $res = fgets($fp, 1024);
        if (strcmp($res, "VERIFIED") == 0)
            //generate random acc id
            $randnum = rand(10000, 99999);
            $randtest = mysql_query("select id from users where id = '$randnum'");
            if (mysql_num_rows($randtest) != 0)
                $rand = $randnum + 1;
            } else
                $rand = $randnum;
            //create acc
            $md5pass = md5($address_city);
             $acctest = mysql_query("select * from users where email = '$email'");
              if (mysql_num_rows($acctest) != 0)
                $cmdqaz = "select * from users where email = '$email'";
                 $cmmdqaz = mysql_query($cmdqaz);
                 $readqaz = mysql_fetch_array($cmmdqaz);
                 $oldtime = $readqaz['date_expire'];
                 $doubleday = strtotime("+30 day", $oldtime);
                 $s = "UPDATE users SET date_expire = '$doubleday' where email = '$email'";
             } else
            mysql_query("INSERT INTO users SET id = '$rand', realname = '$name', acc_type = '$acctype', username = '$email', password = '$md5pass', normal_password = '$address_city', email = '$email', address = '$address_street', zip_code = '$address_zip', number = '$contact_phone', date_registered = '$aaa', date_expire = '$bbb'") or die(mysql_error());
             //log payment
            mysql_query("INSERT INTO payments (email, item_name, payment_status, txn_id, payment_ammount) VALUES('" . mysql_escape_string($email) . "', '" . $item_name . "', '" . $payment_status . "', '" . $txn_id . "', '" . $payment_amount . "' ) ") or die(mysql_error());
      } else
            if (strcmp($res, "INVALID") == 0)
                // log for manual investigation

Recommended Answers

All 4 Replies

Hi ddggttff a possible reason i could think of is:

1) For the paypal button you saved. The Buttons redirection link should be pointing to another page (e.g. success.php or failure.php) other than ipn.php. ipn.php read the post from paypal system and add cmd than it post back to the paypal system to validate

I got mine working through trial and error and know the concepts.

If this doesnt help please read a tutorial in the link below

well the weird thing is if I remove the "or die(mysql_error());" that's behind the part that adds the user to the users table, the script then logs payment, so it makes me think it is unable to add a user account for some reason, but I don't see any errors in my code :S Any ideas?

after doing some research, it seems to be a problem with how I set up my mysql database... anyone see what the problem might be?

database setup:

  `realname` varchar(30) CHARACTER SET ascii NOT NULL,
  `acc_type` decimal(2,0) NOT NULL,
  `acc_status` decimal(10,0) NOT NULL DEFAULT '0',
  `username` varchar(60) CHARACTER SET ascii NOT NULL,
  `password` varchar(32) CHARACTER SET ascii NOT NULL,
  `normal_password` varchar(60) CHARACTER SET ascii NOT NULL,
  `email` varchar(60) CHARACTER SET ascii NOT NULL,
  `address` varchar(50) CHARACTER SET ascii NOT NULL,
  `zip_code` varchar(7) CHARACTER SET ascii NOT NULL,
  `number` varchar(18) CHARACTER SET ascii DEFAULT NULL,
  `date_registered` varchar(30) CHARACTER SET ascii NOT NULL,
  `date_expire` varchar(30) CHARACTER SET ascii NOT NULL,
  `mac_num` decimal(2,0) NOT NULL DEFAULT '0',
  `mac_addresses` varchar(144) CHARACTER SET ascii DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `username` (`username`(5))

fixed it, was a mix between a error in my php code, and my mysql setup.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.