PHP LightCrud Database Examples

Example #1

File: InsertStatement.php Project: buuni/php-light-crud

 public function execute()
 {
     $this->id = $this->db->insert($this->columns)->into($this->table)->values($this->values)->execute();
 }

Example #2

File: DeleteStatement.php Project: buuni/php-light-crud

 public function execute()
 {
     $this->status = $this->db->delete($this->table)->whereMany(array_combine($this->columns, $this->values), '=', 'AND')->execute();
 }

Example #3

File: UpdateStatement.php Project: buuni/php-light-crud

 public function execute()
 {
     $oldPk = $this->oldObject->getValues()[$this->primaryKey];
     $this->status = $this->db->update(array_combine($this->columns, $this->values))->table($this->table)->where($this->primaryKey, '=', $oldPk)->execute();
 }