PHP Developers Network
http://forums.devnetwork.net/

HTTP 500 error with MySQL INSERT and UPDATE queries
http://forums.devnetwork.net/viewtopic.php?f=2&t=144296
Page 1 of 1

Author:  charp23 [ Thu Sep 21, 2017 11:10 pm ]
Post subject:  HTTP 500 error with MySQL INSERT and UPDATE queries

I'm getting this error when the string I'm trying to insert or update in my table contains the text "create a table x" where "x" can be anything at all. The same happens if the text contains "create table x". I'm guessing that the text is interpreted as part of the SQL query, but I can't find any references to this problem to figure out how to correct it. This is happening with $full_details in the code below:

Syntax: [ Download ] [ Hide ]
mysqli_query($dbi,"UPDATE tracker_submits SET
        full_details='$full_details',
        updater='$_SESSION[id]',
        updatestamp='$timestamp'
WHERE submit_id='$postid'"
) or die(mysqli_connect_error()." Oops! Error Updating Post.");
 


Any help figuring this out will be greatly appreciated.

Author:  Christopher [ Mon Sep 25, 2017 5:13 pm ]
Post subject:  Re: HTTP 500 error with MySQL INSERT and UPDATE queries

What is the error message from mysqli_error()? What is the actual value of $full_details? Did you try prepared statements to make sure your variables are escaped?

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/