Db\Adapter::insert

public boolean insert (string | array $table, array $values, [array $fields], [array $dataTypes])

Inserts data into a table using custom RDBMS SQL syntax

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

 // 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#insert

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::listViews public listViews ([mixed $schemaName]) List all views on a database print_r($connection->listViews("blog"));

Db\Adapter\Pdo extends abstract class Phalcon\Db\Adapter implements Phalcon\Events\EventsAwareInterface Source on GitHub Phalcon\Db\Adapter\Pdo is the Phalcon\Db th

Db\Adapter::describeReferences public describeReferences (mixed $table, [mixed $schema]) Lists table references print_r($connection->describeReferences('robots_parts'));

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