Implements PHP magic __toString method to convert the query to a string.

Return value

string The prepared statement.

Overrides Query::__toString

3 methods override InsertQuery::__toString()

InsertQuery_mysql::__toString in includes/database/mysql/query.inc

Implements PHP magic __toString method to convert the query to a string.

InsertQuery_pgsql::__toString in includes/database/pgsql/query.inc

Implements PHP magic __toString method to convert the query to a string.

InsertQuery_sqlite::__toString in includes/database/sqlite/query.inc

Implements PHP magic __toString method to convert the query to a string.

File

includes/database/query.inc, line 668

Class

InsertQuery

General class for an abstracted INSERT query.

Code

public function __toString() {
 // Create a sanitized comment string to prepend to the query.
 $comments = $this->connection 
 ->makeComment ($this->comments );
 // Default fields are always placed first for consistency.
 $insert_fields = array_merge ($this->defaultFields , $this->insertFields );
 if (!empty($this->fromQuery )) {
 return $comments . 'INSERT INTO {' . $this->table  . '} (' . implode (', ', $insert_fields) . ') ' . $this->fromQuery ;
 }
 // For simplicity, we will use the $placeholders array to inject
 // default keywords even though they are not, strictly speaking,
 // placeholders for prepared statements.
 $placeholders = array();
 $placeholders = array_pad ($placeholders, count ($this->defaultFields ), 'default');
 $placeholders = array_pad ($placeholders, count ($this->insertFields ), '?');
 return $comments . 'INSERT INTO {' . $this->table  . '} (' . implode (', ', $insert_fields) . ') VALUES (' . implode (', ', $placeholders) . ')';
}

---