Posts

Using MySQL Stored Procedures with PHP mysql/mysqli/pdo

Using MySQL Stored Procedures with PHP mysql/mysqli/pdoWondering how to use stored procedures with PHP and MySQL? So was I and here’s what I’ve learned. In this tutorial I’ll explain how to use PHP (I’m using 5.2.6) to call MySQL (I’m using 5.0.2) stored procedures using the following database extensions: MySQL – http://php.net/manual/en/book.mysql.phpMySQLi – http://php.net/manual/en/class.mysqli.phpPDO – http://php.net/manual/en/class.pdo.phpFirst we need to setup our enviroment which consists of a new database with one table and two stored procedures. In your db tool of choice (I’ll be using the MySQL Query Browser) create a new database named test. After you create the new database, make sure to add a user called example with password example to the database and give it read access. CREATE DATABASE `test`; Now create the table users: DROP TABLE IF EXISTS `test`.`users`;
CREATE TABLE  `test`.`users` (
`users_id` INT(10)UNSIGNEDNOT NULLAUTO_INCREMENT,
`first_name` VARCHAR(100)NOT NULL,
`las…

TDD of a Simple App in PHP

TEST DRIVEN DEVELOPMENT in PHP In this tutorial, I will present an end-to-end example of a simple application - made strictly with TDD in PHP. I will walk you through each step, one at a time, while explaining the decisions I made in order to get the task done. The example closely follows the rules of TDD: write tests, write code, refactor. Step 1 - Introduction to TDD & PHPUnit Test Driven Development (TDD) TDD is a "test-first" technique to develop and design software. It is almost always used in agile teams, being one of the core tools of agile software development. TDD was first defined and introduced to the professional community by Kent Beck in 2002. Since then, it has become an accepted - and recommended - technique in everyday programming. TDD has three core rules: You are not allowed to write any production code, if there is not a failing test to warrant it.You are not allowed to write more of a unit test than is strictly necessary to make it fail. Not compiling …

Singleton Design Pattern in PHP

Image
Singleton Design Pattern in PHP The Singleton ensures that there can be only one instance of a Class and provides a global access point to that instance. Singleton is a “Gang of Four” Creational Pattern. The Singleton pattern is often implemented in Database Classes, Loggers, Front Controllers or Request and Response objects. Singleton: problem & solutionProblem Solution You want a class to have exactly one instanceYou want the instance to be easily accessibleYou don’t want to use global variables