PHP PDO DB示例

示例#1

文件： delete.php 项目： karlpatrickespiritu/simple-php-pdo-wrapper

<?php

require_once 'config.php';
use PDO\DB;
// not recommened use
// affectedRows = DB::i()->exec("DELETE FROM `users` WHERE id = ?", [2]);
// recommended use, more
$affectedRows = DB::i()->exec("DELETE FROM `users` WHERE id = :id", [':id' => 1]);
dd($affectedRows);

示例#2

文件： update.php 项目： karlpatrickespiritu/simple-php-pdo-wrapper

<?php

require_once 'config.php';
use PDO\DB;
// not recommened use
/**
DB::i()->exec(
    "UPDATE `users` SET name = ?, email = ? WHERE id = ?",
    ["nick", "*****@*****.**", 98]
);
**/
// recommended use, more readable
$params = [":name" => "John Mayer", ":email" => "*****@*****.**", ":id" => 3];
$affectedRows = DB::i()->exec("UPDATE `users` SET name = :name, email = :email WHERE id = :id", $params);
dd($affectedRows);

示例#3

文件： insert.php 项目： karlpatrickespiritu/simple-php-pdo-wrapper

<?php

require_once 'config.php';
use PDO\DB;
// not recommended use
/**
DB::i()->exec(
    "INSERT INTO `users`(`name`, `address`, `email`) VALUES (?, ?, ?)",
    ['brian', 'labangon', '*****@*****.**']
);
**/
// recommended use, more readable
DB::i()->exec("INSERT IGNORE INTO `users`(`name`, `address`, `email`) VALUES (:name, :address, :email)", [':address' => 'urgello', ':name' => 'Karl', ':email' => '*****@*****.**']);
// dump data
dd(DB::i()->getLastId());