summaryrefslogtreecommitdiffstats
path: root/index.php
diff options
context:
space:
mode:
authorJamie Cressey <jamiecressey89@googlemail.com>2014-07-05 17:25:41 -0400
committerJamie Cressey <jamiecressey89@googlemail.com>2014-07-05 17:25:41 -0400
commite31300547c71b567159456048a91b4d55f483db8 (patch)
tree3b4baefc79cc28a6a102abbbe67d5648f6ab30ee /index.php
parent9737cfe130e4a7a56eaa91ba0835efdedb9bceec (diff)
downloadphp-mysql-pdo-database-class-e31300547c71b567159456048a91b4d55f483db8.zip
php-mysql-pdo-database-class-e31300547c71b567159456048a91b4d55f483db8.tar.gz
php-mysql-pdo-database-class-e31300547c71b567159456048a91b4d55f483db8.tar.bz2
typo
Diffstat (limited to 'index.php')
-rw-r--r--index.php60
1 files changed, 0 insertions, 60 deletions
diff --git a/index.php b/index.php
deleted file mode 100644
index 623cb9a..0000000
--- a/index.php
+++ /dev/null
@@ -1,60 +0,0 @@
-<?php
- require("Db.class.php");
-
- // Creates the instance
- $db = new Db();
-
- // 3 ways to bind parameters :
-
- // 1. Read friendly method
- $db->bind("firstname","John");
- $db->bind("age","19");
-
- // 2. Bind more parameters
- $db->bindMore(array("firstname"=>"John","age"=>"19"));
-
- // 3. Or just give the parameters to the method
- $db->query("SELECT * FROM Persons WHERE firstname = :firstname AND age = :age", array("firstname"=>"John","age"=>"19"));
-
- // Fetching data
- $person = $db->query("SELECT * FROM Persons");
-
- // If you want another fetchmode just give it as parameter
- $persons_num = $db->query("SELECT * FROM Persons", null, PDO::FETCH_NUM);
-
- // Fetching single value
- $firstname = $db->single("SELECT firstname FROM Persons WHERE Id = :id ", array('id' => '3' ) );
-
- // Single Row
- $id_age = $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"Zoe"));
-
- // Single Row with numeric index
- $id_age_num = $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"Zoe"),PDO::FETCH_NUM);
-
- // Column, numeric index
- $ages = $db->column("SELECT age FROM Persons");
-
- // The following statemens will return the affected rows
-
- // Update statement
- $update = $db->query("UPDATE Persons SET firstname = :f WHERE Id = :id",array("f"=>"Johny","id"=>"1"));
-
- // Insert statement
-// $insert = $db->query("INSERT INTO Persons(Firstname,Age) VALUES(:f,:age)",array("f"=>"Vivek","age"=>"20"));
-
- // Delete statement
-// $delete = $db->query("DELETE FROM Persons WHERE Id = :id",array("id"=>"6"));
-
- function d($v,$t)
- {
- echo '<pre>';
- echo '<h1>' . $t. '</h1>';
- var_dump($v);
- echo '</pre>';
- }
- d($person, "All persons");
- d($firstname, "Fetch Single value, The firstname");
- d($id_age, "Single Row, Id and Age");
- d($ages, "Fetch Column, Numeric Index");
-
-?>