diff options
| -rw-r--r-- | SQL dump/testdb.sql | 38 | ||||
| -rw-r--r-- | index.example.php | 47 |
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 |