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());