MYSQL PHP : update query results in a syntax error

Question

I'm trying to update the content of a database (specifically the post content of one of the posts database's records).

So here's my PHP code :

$update_sql = "UPDATE wp_posts SET post_content='$new_content' WHERE ID=602";

if (mysqli_query($conn, $update_sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}

This is what I get:

Error updating record: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server 
version for the right syntax to use near 'attention�sur 
les plats eux-m�mes, le service est lui aussi tout en 
simplicit' at line 1

I don't know what I'm doing wrong. All I know is that $new_content contains a very long string (an entire wordpress post's content, complete with various HTML tags).

What should I do for it to accept my update query ?

Thanks for your help

What is the type of the post_content column?

Tim Biegeleisen
– Tim Biegeleisen

2015-03-29 13:38:14 +00:00
Commented Mar 29, 2015 at 13:38 — Tim Biegeleisen
– Tim Biegeleisen, Commented Mar 29, 2015 at 13:38

user1358298 · Accepted Answer · 2015-03-29 13:39:28Z

1

You need to escape the string before inserting it into the database

$update_sql = "UPDATE wp_posts SET post_content='" . mysqli_real_escape_string($new_content) . "' WHERE ID=602";

if (mysqli_query($conn, $update_sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}

answered Mar 29, 2015 at 13:39

user1358298

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

Comments

prasanth prem · Accepted Answer · 2015-03-29 13:42:28Z

1

I think the problem is that you are trying to insert some special characters. like ``. You need to escape it
Use this function `

function clean($str)
{
    $str = @trim($str);
    if (get_magic_quotes_gpc()){
        $str = stripslashes($str);
    }
    return mysql_real_escape_string($str);
}

In your code use like this
$update_sql = "UPDATE wp_posts SET post_content=clean('$new_content') WHERE ID=602";

answered Mar 29, 2015 at 13:42

prasanth prem

4643 silver badges13 bronze badges

Comments

Tim Biegeleisen · Accepted Answer · 2015-03-29 13:47:57Z

0

From the MySQL manual describing VARCHAR:

A variable-length string. Note: Trailing spaces are removed when the value is stored (this differs from the ANSI SQL specification) The range of Length is 1 to 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given.

You are trying to INSERT a string which is too long for the post_content column. Try using a MEDIUMTEXT instead, which can store about 16 million characters.

answered Mar 29, 2015 at 13:47

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Collectives™ on Stack Overflow

MYSQL PHP : update query results in a syntax error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related