diff options
Diffstat (limited to 'easyCRUD')
| -rw-r--r-- | easyCRUD/Person.class.php | 13 | ||||
| -rw-r--r-- | easyCRUD/easyCRUD.class.php | 129 | ||||
| -rw-r--r-- | easyCRUD/index.php | 48 |
3 files changed, 0 insertions, 190 deletions
diff --git a/easyCRUD/Person.class.php b/easyCRUD/Person.class.php deleted file mode 100644 index 131b6b3..0000000 --- a/easyCRUD/Person.class.php +++ /dev/null @@ -1,13 +0,0 @@ -<?php - require_once("easyCRUD.class.php"); - - class Person Extends Crud { - - # Your Table name - protected $table = 'persons'; - - # Primary Key of the Table - protected $pk = 'id'; - } - -?>
\ No newline at end of file diff --git a/easyCRUD/easyCRUD.class.php b/easyCRUD/easyCRUD.class.php deleted file mode 100644 index 2033b15..0000000 --- a/easyCRUD/easyCRUD.class.php +++ /dev/null @@ -1,129 +0,0 @@ -<?php -/** -* Easy Crud - This class kinda works like ORM. Just created for fun :) -* -* @author Author: Vivek Wicky Aswal. (https://twitter.com/#!/VivekWickyAswal) -* @version 0.1a -*/ -require_once(__DIR__ . '/../Db.class.php'); -class Crud { - - private $db; - - public $variables; - - public function __construct($data = array()) { - $this->db = new DB(); - $this->variables = $data; - } - - public function __set($name,$value){ - if(strtolower($name) === $this->pk) { - $this->variables[$this->pk] = $value; - } - else { - $this->variables[$name] = $value; - } - } - - public function __get($name) - { - if(is_array($this->variables)) { - if(array_key_exists($name,$this->variables)) { - return $this->variables[$name]; - } - } - - $trace = debug_backtrace(); - trigger_error( - 'Undefined property via __get(): ' . $name . - ' in ' . $trace[0]['file'] . - ' on line ' . $trace[0]['line'], - E_USER_NOTICE); - return null; - } - - public function save($id = "0") { - $this->variables[$this->pk] = (empty($this->variables[$this->pk])) ? $id : $this->variables[$this->pk]; - - $fieldsvals = ''; - $columns = array_keys($this->variables); - - foreach($columns as $column) - { - if($column !== $this->pk) - $fieldsvals .= $column . " = :". $column . ","; - } - - $fieldsvals = substr_replace($fieldsvals , '', -1); - - if(count($columns) > 1 ) { - $sql = "UPDATE " . $this->table . " SET " . $fieldsvals . " WHERE " . $this->pk . "= :" . $this->pk; - return $this->db->query($sql,$this->variables); - } - } - - public function create() { - $bindings = $this->variables; - - if(!empty($bindings)) { - $fields = array_keys($bindings); - $fieldsvals = array(implode(",",$fields),":" . implode(",:",$fields)); - $sql = "INSERT INTO ".$this->table." (".$fieldsvals[0].") VALUES (".$fieldsvals[1].")"; - } - else { - $sql = "INSERT INTO ".$this->table." () VALUES ()"; - } - - return $this->db->query($sql,$bindings); - } - - public function delete($id = "") { - $id = (empty($this->variables[$this->pk])) ? $id : $this->variables[$this->pk]; - - if(!empty($id)) { - $sql = "DELETE FROM " . $this->table . " WHERE " . $this->pk . "= :" . $this->pk. " LIMIT 1" ; - return $this->db->query($sql,array($this->pk=>$id)); - } - } - - public function find($id = "") { - $id = (empty($this->variables[$this->pk])) ? $id : $this->variables[$this->pk]; - - if(!empty($id)) { - $sql = "SELECT * FROM " . $this->table ." WHERE " . $this->pk . "= :" . $this->pk . " LIMIT 1"; - $this->variables = $this->db->row($sql,array($this->pk=>$id)); - } - } - - public function all(){ - return $this->db->query("SELECT * FROM " . $this->table); - } - - public function min($field) { - if($field) - return $this->db->single("SELECT min(" . $field . ")" . " FROM " . $this->table); - } - - public function max($field) { - if($field) - return $this->db->single("SELECT max(" . $field . ")" . " FROM " . $this->table); - } - - public function avg($field) { - if($field) - return $this->db->single("SELECT avg(" . $field . ")" . " FROM " . $this->table); - } - - public function sum($field) { - if($field) - return $this->db->single("SELECT sum(" . $field . ")" . " FROM " . $this->table); - } - - public function count($field) { - if($field) - return $this->db->single("SELECT count(" . $field . ")" . " FROM " . $this->table); - } - -} -?> diff --git a/easyCRUD/index.php b/easyCRUD/index.php deleted file mode 100644 index b48efa3..0000000 --- a/easyCRUD/index.php +++ /dev/null @@ -1,48 +0,0 @@ -<?php -// Require the person class file - require("Person.class.php"); - -// Instantiate the person class - $person = new Person(); - -// Create new person - $person->Firstname = "Kona"; - $person->Age = "20"; - $person->Sex = "F"; - $creation = $person->Create(); - -// Update Person Info - $person->id = "4"; - $person->Age = "32"; - $saved = $person->Save(); - -// Find person - $person->id = "4"; - $person->Find(); - - d($person->Firstname, "Person->Firstname"); - d($person->Age, "Person->Age"); - -// Delete person - $person->id = "17"; - $delete = $person->Delete(); - - // Get all persons - $persons = $person->all(); - - // Aggregates methods - d($person->max('age'), "Max person age"); - d($person->min('age'), "Min person age"); - d($person->sum('age'), "Sum persons age"); - d($person->avg('age'), "Average persons age"); - d($person->count('id'), "Count persons"); - - function d($v,$t) - { - echo '<pre>'; - echo '<h1>' . $t. '</h1>'; - var_dump($v); - echo '</pre>'; - } - -?> |