Ejemplos de A_Sql_Delete en PHP

Ejemplo n.º 1

Archivo: DeleteTest.php Proyecto: TheProjecter/skeleton

 function testSql_DeleteTableWhere()
 {
     $Sql_Delete = new A_Sql_Delete();
     $this->assertEqual($Sql_Delete->table('foo')->render(), 'DELETE FROM foo');
     $Sql_Delete = new A_Sql_Delete();
     $this->assertEqual($Sql_Delete->table('foo')->where(array('bar' => 1))->render(), "DELETE FROM foo WHERE (bar = 1)");
     $Sql_Delete = new A_Sql_Delete();
     $this->assertEqual($Sql_Delete->table('foo')->where(array('bar' => 1, 'faz' => 'baz'))->render(), "DELETE FROM foo WHERE (bar = 1 AND faz = 'baz')");
 }

Ejemplo n.º 2

Archivo: Activerecord.php Proyecto: TheProjecter/skeleton

 public function delete()
 {
     if (isset($this->_data[$this->key]) && $this->is_loaded) {
         $delete = new A_Sql_Delete();
         $delete->table($this->table)->where($this->key, $this->_data[$this->key]);
         $this->sql = $delete->render();
         $this->db->query($this->sql);
     }
     return $this;
 }

Ejemplo n.º 3

Archivo: example_delete.php Proyecto: TheProjecter/skeleton

<?php

include 'config.php';
$delete = new A_Sql_Delete();
$delete->table('mytable')->where('id =', 1);
echo "A_Sql_Delete::render=" . $delete->render() . '<br/>';
dump($delete);