samayo/发泡材料

一个微型的pdo包装类

维护者

详细信息

github.com/samayo/styrofoam

主页

源代码

问题

安装: 18

依赖: 0

建议者: 0

安全: 0

星标: 10

关注者: 3

分支: 2

开放问题: 1

2.0.0 2015-06-07 20:19 UTC

Requires

  • php: >=5.3.0

MIT c8d458348441d39e33f99582417dd0f9bafab4b0

  • samayo

ormpdowrapper

This package is auto-updated.

Last update: 2024-09-16 08:56:39 UTC

README

一个微型的PDO包装类，用于简单的CRUD操作。

安装

使用composer

$ composer require samayo/styrofoam:1.0.*

使用git

$ git clone https://github.com/samayo/styrofoam.git

用法

require 'path/to/styrofoam.php';

$db = new Styrofoam\Database(
  'mysql:host=localhost; dbname=db-name;  charset=utf8', 'db-user', 'db-pass', [
  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC 
]);

示例

SELECT

// returns $select with value of query
$select = $db->select('SELECT * FROM users WHERE id = ?', [145]);

INSERT

// returns value lastInsertId() on success
$insert = $db->insert('INSERT INTO users (lastname) VALUES (?)', ['robin']);

DELETE

// returns $delete as boolean
$delete = $db->delete('DELETE FROM users WHERE id = ?', [456]);

UPDATE

// returns $update as boolean
$update = $db->update('UPDATE cars SET color = ? WHERE model = ?', ['blue', 'Toyota']);