MySQL INSERT query works in Phpmyadmin but not in PHP

Question

Very strange. I can't see what's going wrong here. The connection to the MySQL database has been made but it won't INSERT from PHP. It's fine if I run the query in Phpmyadmin.

$rawquery = "
    INSERT INTO $log_table_name
        (ref, timestamp, txn_id, email, item_name, item_number, custom, mc_gross, mc_currency, paypal_message)
    VALUES
        (NULL, CURRENT_TIMESTAMP, '$txn_id', '$payer_email', '$item_name', '$item_number', '$custom', '$payment_amount', '$payment_currency', 'INVALID');
";
echo $rawquery;
$query = mysql_query($link, $rawquery) or die('Could not access table');

Produces:

INSERT INTO wp_ipn_log
    (ref, timestamp, txn_id, email, item_name, item_number, custom, mc_gross, mc_currency, paypal_message)
VALUES
    (NULL, CURRENT_TIMESTAMP, '', '', '', '', '', '', '', 'INVALID');Could not access table

I'm expecting the INVALID message, I just want it to be inserted into the database.

Is the problem the format of the query, or is there an issue with the database, or something else?

ADDITIONAL INFO (as requested by vinodadhikary):

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db(DB_NAME, $link) or die ("Could not open db ".mysql_error());

This is working fine.

check if the username and password are correct and have permission to write to the table — bansi
– bansi, Commented Aug 17, 2013 at 15:59
Warning: mysql extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.Please don't use mysql to develop new code. — bansi
– bansi, Commented Aug 17, 2013 at 16:00
It was mysqli originally but it didn't work so I tried mysql instead. Same results. — user114671
– user114671, Commented Aug 17, 2013 at 16:04
add mysql_error()/mysqli_error($link) to your die(). Also, mysql_query is mysql_query(query, link), where mysqli_query is mysql_query(link, query). So it should be $query = mysql_query($rawquery,$link) or die(mysql_error()); OR using mysqli -> $query = mysqli_query($link, $rawquery) or die(mysqli_error($link)); — Sean
– Sean, Commented Aug 17, 2013 at 16:24

Sean · Accepted Answer · 2013-08-17 16:38:41Z

2

When trying to debug code, it is helpful to use mysql_error()/mysqli_error($link) in your die() rather than a generic string - die('Could not access table').

Also, the order of query/link in mysql/mysqli is not the same

mysql_query is mysql_query(query,link), so your code should be

$query = mysql_query($rawquery,$link) or die(mysql_error());

while mysqli_query is mysqli_query(link, query), so your code should be

$query = mysqli_query($link, $rawquery) or die(mysqli_error($link));

answered Aug 17, 2013 at 16:38

Sean

12.4k3 gold badges31 silver badges49 bronze badges

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

Comments

Zulqurnain abbas · Accepted Answer · 2013-08-17 17:02:26Z

0

Need to check few things on this,

1 - is NULL allowed for ref field name ?
2 - paypal_message check is this varchar or text and check length also in database ?
3 - can you try removing '' from each values.
4 - last check empty is allowed ?

you can try doing with some sample values instead of empty. check if that query works, so you can go near around to solution.

Hope these things helped you

thanks

answered Aug 17, 2013 at 17:02

Zulqurnain abbas

7421 gold badge5 silver badges5 bronze badges

Collectives™ on Stack Overflow

MySQL INSERT query works in Phpmyadmin but not in PHP

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