CakePHP

               LAMP (Linux/Apache/MySQL/PHP) platform is a successful alternative to commercial software for building and operating dynamic and high performance web systems. PHP has become one of the major player on the web development market in the last few years. For all Linux hosting packages, PHP 5.5 has recently become the standard version. The upgraded PHP version 5.5 comes with lots of changes and value additions.Most of the changes are beneficiary for the e-commerce stores running on php. Here’s a Brief description of what php version 5.5 has to offer your e-commerce store…. (i) Addition of keywords : In php version 5.5, the provided refinery keyword facility will allow a developer to define block code, cache block for better keyword search. It improves the result of the search based on keywords. Keyword search is very much helpful in the e-commerce online stores. (ii) Availabili...

MySql 5 introduced the concept of stored procedure functionality. If you have already worked on other DBMS(Database management System) or Mysql,  you might be familiar with the concept of stored procedure. We will learn more about it in detail here. What is mysql stored procedure? Stored procedure is a set of SQL codes stored in a database server which can be invoked by a program, trigger or stored procedure itself.  Stored procedure is a way to execute tasks/business logic directly on your database server. Generic tasks can be performed  which are dependent on database table data. so rather to go multiple time on database to fetch data into your program and perform your business logic stored procedure give some generic way of coding for your business logic and take data return or you can save your processed data into your database. Let us take an example:- A loan officer wants to change the floating interest levied for a customer’s loan account. What is y...