laiz/laiz-db

Object relational mapping library

laiz-db: PHP O/R Mapping Library

Simple O/R Mapping library with PHP5., _(*1)

Sample Database

Tables:, _(*2)

CREATE TABLE item (
  item_id serial primary key,
  name    text not null,
  opt     text
);
CREATE TABLE sub_item (
  sub_item_id serial primary key,
  item_id     int references item(item_id),
  name        text not null
);

Usage

Initialization::, _(*3)

$db = new Laiz\Db\Db();
$db->setDsn('pgsql:host=localhost dbname=mydb user=myuser password=pass')
    ->setConfigFile('writable/config.ini');
    ->setAutoConfig(true)
    ->setVoPrefix('Vo_');

Selection:, _(*4)

$item = $db->from('Item')
    ->eq(array('name' => 'Name 1'))
    ->result();
$itemAndSubItems = $db->from('Item')
    ->join('SubItem')
    ->eq(array('Item.name' => 'Name 1'))
    ->result();
$items = $db->from('Item')
    ->like(array('Item.name', 'a'))
    ->order('itemId')
    ->iterator();

Update:, _(*5)

$item->name = 'Item 2';
$db->save($item);

Insert:, _(*6)

$subItem = $db->generateVo('SubItem');
$subItem->itemId = $item->itemId;
$subItem->name = 'Sub Name 1';
$db->save($subItem);

Delete:, _(*7)

$db->delete($subItem);

Pager:, _(*8)

$pager = new Laiz\Db\Pager($items, 10);
$pagerHtml = $pager->getHtml();

Notice

Vo that returned from iterator have references of variables. The following code works as expected:, _(*9)

$iterator = $db->from('Goods')->iterator();
$sum = 0;
foreach ($iterator as $goods){
    $sum += $goods->price;
}
echo $sum;

But, the following code does not work as expected:, _(*10)

$iterator = $db->from('Goods')->iterator();
$arr = array();
foreach ($iterator as $goods){
    $arr[] = $goods;
}
$sum = 0;
foreach ($arr as $goods){
    $sum += $goods->price;
}
echo $sum;

If you save vo to arrays or other variables, you need call setCloneVo method:, _(*11)

$iterator = $db->from('Goods')->iterator()->setCloneVo(true);
$arr = array();
foreach ($iterator as $goods){
    $arr[] = $goods;
}

..., _(*12)