summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorIndieteq <admin@indieteq.com>2013-09-09 20:44:56 +0200
committerIndieteq <admin@indieteq.com>2013-09-09 20:44:56 +0200
commit097f88ca83861112101f1244113e35b71e67e2f8 (patch)
tree657fdd61c9511a80b2a5030b74ecca5aa0a182a6
parent8fb5251aa1cbaf872e953c2125e0316220196c33 (diff)
downloadphp-mysql-pdo-database-class-097f88ca83861112101f1244113e35b71e67e2f8.zip
php-mysql-pdo-database-class-097f88ca83861112101f1244113e35b71e67e2f8.tar.gz
php-mysql-pdo-database-class-097f88ca83861112101f1244113e35b71e67e2f8.tar.bz2
Added some Aggregate method examples
Added some Aggregate method examples
-rw-r--r--easyCRUD/index.php24
1 files changed, 20 insertions, 4 deletions
diff --git a/easyCRUD/index.php b/easyCRUD/index.php
index e77c04e..b48efa3 100644
--- a/easyCRUD/index.php
+++ b/easyCRUD/index.php
@@ -20,13 +20,29 @@
$person->id = "4";
$person->Find();
- echo $person->Firstname;
- echo $person->Age;
-
+ d($person->Firstname, "Person->Firstname");
+ d($person->Age, "Person->Age");
+
// Delete person
$person->id = "17";
$delete = $person->Delete();
// Get all persons
$persons = $person->all();
-?> \ No newline at end of file
+
+ // 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>';
+ }
+
+?>