SQL dump and Example PHP file

2 files changed, 85 insertions, 0 deletions

diff --git a/SQL dump/testdb.sql b/SQL dump/testdb.sql
new file mode 100644
index 0000000..eadf3fb
--- /dev/null
+++ b/SQL dump/testdb.sql
@@ -0,0 +1,38 @@
+/*
+Navicat MySQL Data Transfer
+
+Source Server         : localhost_3306
+Source Server Version : 50527
+Source Host           : localhost:3306
+Source Database       : testdb
+
+Target Server Type    : MYSQL
+Target Server Version : 50527
+File Encoding         : 65001
+
+Date: 2012-11-12 14:07:39
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for `persons`
+-- ----------------------------
+DROP TABLE IF EXISTS `persons`;
+CREATE TABLE `persons` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Firstname` varchar(32) DEFAULT NULL,
+  `Lastname` varchar(32) DEFAULT NULL,
+  `Sex` char(1) DEFAULT NULL,
+  `Age` tinyint(3) DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+
+-- ----------------------------
+-- Records of persons
+-- ----------------------------
+INSERT INTO `persons` VALUES ('1', 'John', 'Doe', 'M', '19');
+INSERT INTO `persons` VALUES ('2', 'Bob', 'Black', 'M', '40');
+INSERT INTO `persons` VALUES ('3', 'Zoe', 'Chan', 'F', '21');
+INSERT INTO `persons` VALUES ('4', 'Sekito', 'Khan', 'M', '19');
+INSERT INTO `persons` VALUES ('5', 'Kader', 'Khan', 'M', '56');
diff --git a/index.example.php b/index.example.php
new file mode 100644
index 0000000..71a78e0
--- /dev/null
+++ b/index.example.php
@@ -0,0 +1,47 @@
+<?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' => '31' ) );
+	
+	// Single Row
+	$id_age 	 =     $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"John"));
+		
+	// Single Row with numeric index
+	$id_age_num  =     $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"John"),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")); 
+?>
\ No newline at end of file