public function delete($criteria, $table)
{
$delete = $this->queryHandler->newDelete();
$delete->from($table);
foreach ($criteria as $col => $value) {
$delete->where($col . ' = :' . $col);
}
$delete->bindValues($criteria);
return $this->db->perform($delete->__toString(), $delete->getBindValues());
}
/**
* Remove relationship.
*
* @param \Percy\Entity\EntityInterface $entity
* @param array $rels
* @param array $map
*
* @return void
*/
public function deleteRelationship(EntityInterface $entity, array $rels, array $map)
{
$this->dbal->beginTransaction();
foreach ($rels as $rel) {
$delete = $this->query->newDelete();
$delete->from($map['defined_in']['table']);
$delete->where(sprintf('%s = :%s', $map['defined_in']['primary'], $map['defined_in']['entity']));
$delete->where(sprintf('%s = :%s', $map['target']['relationship'], 'relationship'));
$delete->limit(1);
$delete->bindValue('uuid', $entity[$map['defined_in']['entity']]);
$delete->bindValue('relationship', $rel);
$this->dbal->perform($delete->getStatement(), $delete->getBindValues());
}
$this->dbal->commit();
}
/**
* @return Aura\SqlQuery\Common\DeleteInterface
*/
public static function newDelete()
{
return self::$queryFactory->newDelete();
}
<?php
require 'config.php';
use Aura\SqlQuery\QueryFactory;
use Aura\Sql\ExtendedPdo;
$query_factory = new QueryFactory('mysql');
$insert = $query_factory->newInsert();
$update = $query_factory->newUpdate();
$delete = $query_factory->newDelete();
$pdo = new ExtendedPdo('mysql:host=' . $mysql_host . ';dbname=' . $mysql_db, $mysql_user, $mysql_pass, array(), array());
function pdoSelect($select)
{
global $pdo;
$sth = $pdo->prepare($select->getStatement());
$sth->execute($select->getBindValues());
return $sth->fetchAll(PDO::FETCH_ASSOC);
}
function pdoInsert($table, $data)
{
global $pdo, $insert;
$insert->into($table)->cols(array_keys($data))->bindValues($data);
$sth = $pdo->prepare($insert->getStatement());
$sth->execute($insert->getBindValues());
return $pdo->lastInsertId();
}
function pdoUpdate($table, $id, $data)
{
global $pdo, $update;
$update->table($table)->where('id = ?', $id)->cols(array_keys($data))->bindValues($data);
$sth = $pdo->prepare($update->getStatement());
return $sth->execute($update->getBindValues());
