/**
* Insert a record in the database.
*
* @param $table
* @param Yampee_Db_Record $record
* @return array
*/
public function insert($table, Yampee_Db_Record $record)
{
$qb = $this->createQueryBuilder()->insert($table);
foreach ($record->toArray() as $field => $value) {
$qb->set($field, $this->uncast($value));
}
return $qb->execute();
}
<?php
require '../autoloader.php';
$db = new Yampee_Db_Manager(new Yampee_Db_Dsn(Yampee_Db_Dsn::DRIVER_MYSQL, 'test'), 'root', '');
/*
* Select
*/
$results = $db->query('SELECT * FROM test');
foreach ($results as $result) {
echo $result->getFirstField();
echo $result->getDateField()->format('d/m/Y H:i');
}
/*
* Insert
*/
$record = new Yampee_Db_Record();
// You can use camelCased magic methods ...
$record->setFirstField('127.0.0.1');
$record->setSecondField('127.0.0.1');
$record->setDateField(new DateTime());
// Or real methods
$record->set('firstField', '127.0.0.1');
$record->set('secondField', '127.0.0.1');
$record->set('dateField', new DateTime());
$db->insert('table_name', $record);
/*
* Query builder
*/
$records = $db->createQueryBuilder()->select('t.field, t.otherField, ot.foreignField')->from('table t')->leftJoin('otherTable ot ON ot.table_id = t.id')->where('t.id = :id')->setParameter('id', 4)->limit(5)->execute();
$db->createQueryBuilder()->insert('table t')->set('t.firstField', $firstValue)->set('t.secondField', $secondValue)->execute();
$db->createQueryBuilder()->update('table t')->set('t.firstField', $firstValue)->set('t.secondField', $secondValue)->where('t.id = :id')->setParameter('id', 4)->execute();
