Posts Tagged ‘MySQL’

Follow Coding Standards

May 17th, 2007

Being a self-taught beginner at one stage, I understand that code formatting and other concerns NOT regarding syntax is taken for granted, I mean, when you pick up your first programming language, the one thing you want is for your application to work, heck, when some beginners first started programming PHP, they have no idea what a “coding standard” is let alone it’s existence and haphazardly hack away line for line at their scripts without regard.

» Read more: Follow Coding Standards

Using Stored Procedures & MySQLI in PHP 5

January 7th, 2007

For the occasions that you want to use a stored procedure you’ve written in MySQL 5 through PHP , the semantic tool to use is PHP’s built in mysqli objects/package.

According to the php.net: “The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above.”

MySQLI stands for MySQL Improved, and it most certainly is with the addition of prepared statements and extensible Object Oriented interface.
» Read more: Using Stored Procedures & MySQLI in PHP 5

The Singleton Pattern with PHP

May 25th, 2006

The Singleton Pattern is often mistakenly referred to as the OOP nuts “Global variable”.

Admittedly, I myself have been one of those people who had referred to it as such (this is an edited version you are reading), but in fact, the Global Variable tag that has been given to this pattern is actually a side effect – all you need to do is look at the name.

» Read more: The Singleton Pattern with PHP