Data not inserting in MySQL

Question

I am making a script for a guy and he uses Advanced Outgoing API (not familiar). He gives me this URL where the POST variable will be stored in http://example.com/your_script.php?email_address={u_email}&firstname={u_firstname}. So here is my php code. The problem is it cannot read the post values. When I echo it, it's empty.

NOTE: This is the instruction from the API Manual.

Advanced Outgoing API You can have up to 5 URLs for each Product/Podcast/RSS Feed/Membership be notified whenever a subscriber event happens. You can enter these URLs by clicking on "Edit Notifications/Custom Fields" for a particular item. The system will then POST the following variables to the URLs you've entered. You can also include any of the variables below as a "tags" in your URL and the system will replace the tag with the actual value. This way you can post the values to an existing script that expects a variable name to be different than the ones listed below. For example, your notification URL could be: http://example.com/your_script.php?email_address={u_email}&firstname={u_firstname} . The system would then post all the variables below to: http://example.com/[email protected]&firstname=Joe

    $con = mysql_connect("localhost","xyz","xyz","xyz"); // Establish connection to insert in the first table.

    $username = $_POST['paypal_email']; // username of the user.
    $rawpass = $_POST['access_code']; // Raw password.
    $pass = md5($rawpass); // Password of the user encrypted with md5.
    $email = $_POST['email_address']; // E-mail of the user.
    $time = date("Y-m-d H:i:s");

    echo $username;
    echo $pass;
    echo $email;
    echo $time;

    mysql_query("INSERT INTO wpinrootusers ('user_login', 'user_pass', 'user_email', user_registered, 'user_status') VALUES ('$username', '$pass', '$email', '$time', 0), $con"); // Insertion into wpinrootusers table.

    mysql_close($con); // Close connection.

    $con = mysql_connect("localhost","xyz","xyz","xyz"); // Establish connection to insert in the second table.

    mysql_query("INSERT INTO customers ('receipt', 'prod_num', 'email') VALUES ('$rawpass', '6', '$email')", $con); // Insertion into customers table.

    mysql_close($con); // Close second connection.

Those aren't POST values. They are GET values. Also, don't use MD5 for hashing passwords. It's broken. Oh, and mysql_* functions are obsolete. Oh, and you're wide open to SQL injections. — John Conde
– John Conde, Commented May 16, 2014 at 14:15
First your mysql_connect parameters are wrong and secondly why are you opening a connection twice to MySQL if you just need to insert into different tables (referencing this from the code comments)? — Karl Viiburg
– Karl Viiburg, Commented May 16, 2014 at 14:20
Yeah I see. But the thing is I cannot get the variables from POST. I inserted the API manual instructions. — miszu
– miszu, Commented May 16, 2014 at 14:22

Albion S. · Accepted Answer · 2014-05-16 14:18:06Z

1

With mysql you have to do:

$con = mysql_connect("localhost","xyz","xyz");

and then select the database:

$db = mysql_select_db("xyz");

The code you used to connect to database works with mysqli (i stands for improved) and you should consider switching from mysql to mysqli

answered May 16, 2014 at 14:18

Albion S.

2382 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

theHacker · Accepted Answer · 2014-05-16 14:16:46Z

0

When you send the variable as GET parameters you have to use $_GET of course.

answered May 16, 2014 at 14:16

theHacker

4,0431 gold badge23 silver badges36 bronze badges

Collectives™ on Stack Overflow

Data not inserting in MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related