Db\Adapter::insertAsDict

public boolean insertAsDict (string $table, array $data, [array $dataTypes])

Inserts data into a table using custom RBDM SQL syntax

//Inserting a new robot
 $success = $connection->insertAsDict(
 "robots",
 array(
      "name" => "Astro Boy",
      "year" => 1952
  )
 );

 //Next SQL sentence is sent to the database system
 INSERT INTO `robots` (`name`, `year`) VALUES ("Astro boy", 1952);

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Adapter.html#insertasdict

doc_Phalcon

2016-10-16 09:48:52

Comments

Popular Articles

Db\Adapter implements Phalcon\Events\EventsAwareInterface Source on GitHub Base class for Phalcon\Db adapters Methods public getDialectType () Name of the diale

Db\Adapter::limit public limit (mixed $sqlQuery, mixed $number) Appends a LIMIT clause to $sqlQuery argument echo $connection->limit("SELECT * FROM robots", 5);

Db\Adapter::createSavepoint public createSavepoint (mixed $name) Creates a new savepoint

Db\Adapter::delete public boolean delete (string | array $table, [string $whereCondition], [array $placeholders], [array $dataTypes]) Deletes data from a table using cu

Db\Adapter::dropColumn public dropColumn (mixed $tableName, mixed $schemaName, mixed $columnName) Drops a column from a table