Phalcon数据库操作(插入/更新/删除行)

本文概述

  • 更新行
  • 删除行
插入行
// Inserting data with a raw SQL statement$sql= 'INSERT INTO 'company'('name', 'year') VALUES ('srcmini', 2010)'; $success = $connection-> execute($sql); // With placeholders$sql= 'INSERT INTO 'company'('name', 'year') VALUES (?, ?)'; $success = $connection-> execute($sql, ['javatoint', 2010, ]); // Generating dynamically the necessary SQL$success = $connection-> insert('company', ['srcmini', 2010, ], ['name', 'year', ], );

【Phalcon数据库操作(插入/更新/删除行)】输出
Phalcon数据库操作(插入/更新/删除行)

文章图片
更新行
// Updating data with a raw SQL statement$sql= 'UPDATE 'company' SET 'name' = 'srcmini' WHERE 'id' = 101'; $success = $connection-> execute($sql); // With placeholders$sql= 'UPDATE 'company' SET 'name' = ? WHERE 'id' = ?'; $success = $connection-> execute($sql, ['srcmini', 101, ]); // Generating dynamically the necessary SQL (another syntax)$success = $connection-> updateAsDict('company', ['name' => 'New srcmini', ], 'id = 101' // Warning! In this case values are not escaped);

输出
Phalcon数据库操作(插入/更新/删除行)

文章图片
删除行
// Deleting data with a raw SQL statement$sql= 'DELETE 'company' WHERE 'id' = 101'; $success = $connection-> execute($sql); // With placeholders$sql= 'DELETE 'company' WHERE 'id' = ?'; $success = $connection-> execute($sql, [101]); // Generating dynamically the necessary SQL$success = $connection-> delete('company', 'id = ?', [101, ]);

    推荐阅读