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

2025-01-10 15:47:30

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\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::tableExists public tableExists (mixed $tableName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.table var_dump($connection->tableE

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