MySQL

Working with combined expressions in WHERE clauses in Laravel 4

When retrieving records from tables in our database, you often have to write combined expressions in WHERE clauses like [sourcecode language=”sql”] SELECT * FROM users WHERE status=1 AND (fname = ‘John’ OR lname=’Doe’) [/sourcecode] The query above is pulling out all users who’s status is set to 1, and fname is equal to ‘John’ or …

Working with combined expressions in WHERE clauses in Laravel 4 Read More »

Install and Run Symfony 2.3.6 projects in OpenShift instances in just one minute with this boilerplate repository

Okay, I have written an article 2 days ago where I went through every details. But today. I have created a blank symfony container with all the necessary deploy hook and mods so that you can get your symfony 2 project up and running in an openshift container within a minute, fully automated, seriously! Github …

Install and Run Symfony 2.3.6 projects in OpenShift instances in just one minute with this boilerplate repository Read More »

Running Symfony 2 Applications in OpenShift

Openshift is a fantastic Polyglot PaaS from Redhat, and you can do a lot of things with these containers. The good news is that with free accounts, OpenShift gives three gears for free, forever. Today, in this article I will show you how to install and run your Symfony applications in OpenShift. After you have …

Running Symfony 2 Applications in OpenShift Read More »

List of RSS Feeds I read almost everyday

I am sharing a list of RSS feeds that I read almost everyday. And which one is my favorites RSS reader? Well, I use GoogleReader because of it’s excellent features like star and feed history. also I like it’s feed sharing feature. 1. Ajaxian : http://www.ajaxian.com/index.xml 2. Cow’s Blog : http://cow.neondragon.net/xml.php 3. IBM Developer Works …

List of RSS Feeds I read almost everyday Read More »

Using ActiveRecord Library Separately from CodeIgniter

CodeIgniters ActiveRecord library is a nice implementation (though modified) of ActiveRecord design pattern. It comes bundled with CodeIgniter. So if you want to use Just this library in your application individually instead of using full CodeIgniter framework, what to do? Today I’ve spent some time and separate the ActiveRecord library from CodeIgniter. Now you can …

Using ActiveRecord Library Separately from CodeIgniter Read More »

Prelude to foundation: Its time to go for a better PHP Framework

I remember those old days when I had to write everything by myself. I wrote huge libraries to work with MySQL. Then I learned PostgreSQL and SQLite but didn’t rewrote my old library to work with those, I was running short of time. So I forsake the opportunity to write a db library which works …

Prelude to foundation: Its time to go for a better PHP Framework Read More »

Vulnerable bug in CodeIgniter which took us hours to fix our corrupted database

We use codeigniter internally to develop our web solutions in somewhere in… net limited. Day before yesterday we suffered a terrible situation for an internal bug in code igniter which corrupted data inside some tables of our application database and then it tooks hours to find the origin of that bug, to fix it and …

Vulnerable bug in CodeIgniter which took us hours to fix our corrupted database Read More »

Just PHP will give you nothing… unless you upgrade yourself

I have been working with PHP for more than 3yrs (I believe still I am beginner in this category) – I was present in several interview board. Which things disappointed me most is the “lack of eagerness” to learn what comes new. Sometime developers thinks that learning Only PHP will help them to get lucrative …

Just PHP will give you nothing… unless you upgrade yourself Read More »