Db\Adapter::updateAsDict

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

Updates data on a table using custom RBDM SQL syntax Another, more convenient syntax

//Updating existing robot
 $success = $connection->updateAsDict(
 "robots",
 array(
      "name" => "New Astro Boy"
  ),
 "id = 101"
 );
 
 //Next SQL sentence is sent to the database system
 UPDATE `robots` SET `name` = "Astro boy" WHERE id = 101

Links:

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

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::delete public boolean delete (string | array $table, [string $whereCondition], [array $placeholders], [array $dataTypes]) Deletes data from a table using cu

Db\Adapter::releaseSavepoint public releaseSavepoint (mixed $name) Releases given savepoint

Db\Adapter::getConnectionId public string getConnectionId () Gets the active connection unique identifier

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