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 … Continue reading Working with combined expressions in WHERE clauses in Laravel 4
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 … Continue reading Install and Run Symfony 2.3.6 projects in OpenShift instances in just one minute with this boilerplate repository
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 … Continue reading Running Symfony 2 Applications in OpenShift
I am a big fan of NeedForSpeed since version 2. You remember that? Those days were complete fun chasing with FZR2000 or McLaren F1. I specially liked to run on Hollywood track in NFS2SE. Today, a new version of NFS (ProStreet) has been released. And we, a small developers team in Trippert Labs released the … Continue reading NeedForSpeed – Our First Facebook Application for Electronic Arts
We (Trippert Inc) are recently working on developing facebook applications, and as a part of this, we released Holiday Gifts two months ago. This nice app is built using PHP with MySQL in backend. And you know what do we get after these two months? a surprising amount of total users – almost 260K by … Continue reading So 260K Users in 2 months is Not Huge, u bet?
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 … Continue reading List of RSS Feeds I read almost everyday
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 … Continue reading Using ActiveRecord Library Separately from CodeIgniter
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 with them. What I did was plain code relevant to database specific portions. Oh ya, that was a long time ago.
Soon after that I came to know adoDB which made my dream come true. I was so much happy getting my all db specific works done in a much more smarter way. I get rid of database portability issues. I was very happy that time.
I learned smarty soon after I realize that my codes are getting ugly with all the inline HTMLs and PHPs. Nothing could be smarter than separating the presentation logic from the business layer. I am a big smarty fan since that time. It saves my sleep for many nights.
But again I am recurrently suffering from maintainability issues. I was not surprised to find that my code is becoming huge unmanageable giant and it takes huge time for refactoring the application. I was very sad those days. Oh what a disaster that was.
When working with my team members located remote places, I fall into a deep shit. How can we manage and track the changes done by us? Even I was getting strange code in my routine which I bet was not written by me!! It was a terrific job Continue reading “Prelude to foundation: Its time to go for a better PHP Framework”
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 … Continue reading Vulnerable bug in CodeIgniter which took us hours to fix our corrupted database
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 jobs!! OMG
Specially in BD most of the time PHP developers plays multiple roles in the companies, they are developer, they are template designers, they are HTML coders, they are DBA, they are PMs….what the heck. Only few companies have different people for these roles.
How far you can go just learning PHP (RAW code, in ancient style, that means PHP+HTML together, yak!!)? You have to have knowledge in CSS, JS, Frameworks, Multiple DBS
When it comes the question of CSS, you should maintain a list of websites where from you can get updates. Dont learn the CSS from book, but goto websites and see what is happening… If you are still using Tables to design Continue reading “Just PHP will give you nothing… unless you upgrade yourself”