使用逗号围绕键和值进行插入(从数组加载)[重复]

I am making a really small script, that allows you to make an insert query, based on an array.

So the only thing that you need to do is define the $table and add an array to the function.

public function makeRecord($table, $array){

    $array_keys = array_keys($array);
    $array_values = array_values($array);
    $keys = implode(',', $array_keys);
    $values = implode(',', $array_values);
    $this->DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO $table ($keys)
    VALUES ($values)";
    return $this->DB->exec($sql);

}

The next code will generate an SQL query like this. INSERT INTO Users (UserName,Password) VALUES (daan,welkom01).

But it needs to be

INSERT INTO Users ('UserName', 'Password') VALUES ('daan','welkom01') What is the best way to fix this :)?

</div>