PDO准备的声明与动态变量[重复]

Question

This question already has an answer here:

• Can PHP PDO Statements accept the table or column name as parameter? 7 answers

I want to create a function that can insert data into database using PDO prepared statement

public function test() {
  $this->insert([
    'first_name' => $_POST['first_name'],
    'last_name' => $_POST['last_name'],
    'email' => $_POST['email']
  ]);
}


public function insert(array $data) {

  $fields = '';
  $bindValues = '';
  $values = [];

  foreach($data as $k => $v) {
    $fields .= $k . ', ';
    $bindValues .= ':' . $k . ', ';
    $values[$k] = $v; 
  }

  $fields = rtrim($fields, ', ');
  $bindValues = rtrim($bindValues, ', ');

  $insert = $this->db->prepare("
    INSERT INTO
      :table
    (:fields)
    VALUES 
      (:values)
  ");

  $insert->execute([
    'table' => $this->table,
    $values
  ]);  
}

---

dumped variables: 
1. $fields
2. $bindValues 
3. $values


'first_name, last_name, email' (length=28)
':first_name, :last_name, :email' (length=31)
array (size=3)
  'first_name' => string 'Nikola' (length=6)
  'last_name' => string 'Misic' (length=5)
  'email' => string '[e-mail]' (length=13)

And I'm getting an error

Call to a member function execute() on boolean

There's something wrong with the SQL, and I don't know what or how to debug it.

</div>

Answer 1

You need to build the SQL using something like...

$insert = $this->db->prepare("
    INSERT INTO
      {$this->table}
    ($fields)
    VALUES 
      ($bindValues)
  ");