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', ], );

输出

更新行

// 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
);

输出

删除行

// 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, ]
);