Can't store array with mysqli [Error 1064]

Question

I'm trying to store a JSON-encoded array into MySql, but I get an error 1064.

My table structure:

And my code:

public static function addFriends($player, $friends = []){
    $array = json_encode($friends);
    $sql = "INSERT INTO friends (friends) VALUES ('$array') WHERE name = '" . $player . "'";
    $query = DatabaseManager::getConnection()->query($sql);
    if(!$query){
        echo mysqli_errno(DatabaseManager::getConnection());
        return;
    }
    echo 'Done';
}

The $friends array is like ["Car", "Plane", "Bug"].

You want to insert only one record with the field `friends` having the array values in form of the string `Car, Plane, Bug`? Or you want to insert a record for each array item? — , Jan 14 '18 at 16:43
@NicoHaase How to get it? mysqli_errno display only 1064, nothing else — GuyWhoDoThings, Jan 14 '18 at 16:59
Put this two lines in your file (on top of it) where you call the function `addFriends`: `error_reporting(E_ALL);` followed by `ini_set('display_errors', 1);`. This way you will be able to see the whole error on screen. — , Jan 14 '18 at 17:03
https://stackoverflow.com/questions/22662488/how-to-get-mysqli-error-in-different-environments — Paul Spiegel, Jan 14 '18 at 17:05

score 0 · Answer 1 · answered Jan 14 '18 at 16:53

0

Try this:

$sql = "INSERT INTO friends (friends) VALUES ('".$array."') WHERE name = '" . $player . "'";

answered Jan 14 '18 at 16:53

blanck

1

1

That should result in the exact same query – Nico Haase Jan 14 '18 at 17:19

Can't store array with mysqli [Error 1064]

1 Answers1