Unable to insert serialized XML Array to Database (MySQLi)

Question

I am trying to integrate a PHP plugin with my web app, but I am stuck with storing the values that I receive from an XML file to a table in my database.

This is what I have so far, but when I run the PHP script it does not save to the database. I have created a table in my database with one column (type=text, name=test)

    global $mysqli;

    $str = serialize($Items);
    printF($str);
    $result = $mysqli->query("INSERT INTO nepremicnine (test) VALUES ('$str');");

Have you checked your error logs? You're making an assumption the query is working. — Jay Blanchard
– Jay Blanchard, Commented May 4, 2016 at 18:20
You do have an extra semicolon toward the end of your result statement. Logs would show this. ('$str');"); — Brian
– Brian, Commented May 4, 2016 at 19:03

Barmar · Accepted Answer · 2016-05-04 18:22:44Z

2

$Items probably contains some strings with single quotes, and this is causing a syntax error when you substitute it into the INSERT query. Use a prepared statement to avoid problems with special characters.

$stmt = $mysqli->prepare("INSERT INTO nepremicnine (test) VALUES (?);");
$stmt->bind_param("s", $str);
$result = $stmt->execute();

answered May 4, 2016 at 18:22

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

Svedr Over a year ago

This was correct, sorry for the late approval, but your solution helped me out :)

Collectives™ on Stack Overflow

Unable to insert serialized XML Array to Database (MySQLi)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related