title: Making an insert with comma's around the keys and values (loaded from array)
body: <p>I am making a really small script, that allows you to make an insert query, based on an array.</p>
  
  <p>So the only thing that you need to do is define the <code>$table</code> and add an array to the function.</p>
  
  <pre><code>public function makeRecord($table, $array){
  
      $array_keys = array_keys($array);
      $array_values = array_values($array);
      $keys = implode(',', $array_keys);
      $values = implode(',', $array_values);
      $this-&gt;DB-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      $sql = "INSERT INTO $table ($keys)
      VALUES ($values)";
      return $this-&gt;DB-&gt;exec($sql);
  
  }
  </code></pre>
  
  <p>The next code will generate an SQL query like this.
  <code>INSERT INTO Users (UserName,Password) VALUES (daan,welkom01)</code>.</p>
  
  <p>But it needs to be </p>
  
  <p><code>INSERT INTO Users ('UserName', 'Password') VALUES ('daan','welkom01')</code>
  What is the best way to fix this :)?</p>