Prahlad Yeri

Freelance Programmer and Writer

[PHP/Codeigniter] Getting multi-queries right with SQLITE

My earlier article dealt with multi-query issues of MySQL, this one is dedicated to SQLITE. Multi-queries are often discouraged to begin with but there are times when you find yourself using them. One typical use case is populating the database initially when it's empty. You do this by running an … Read More


[MySQL] Setting default date to current date

Tags: MySQL PHP  
The most typical way people set default values to mysql date fields is by using the CURRENT_TIMESTAMP constant as follows: create table ledger_entries ( id int(11) not null auto_increment, entry_date datetime default CURRENT_TIMESTAMP ); This will obviously work if you need both date and time parts in the value. But in … Read More

[PHP/Codeigniter] Playing with multi-queries in MySQL

Multi-queries are often discouraged with mysqli functions but there are times when you must use them. One obvious use case is initializing the database. One of the first things your app must do is determine if the database tables exist or not, and then run an initializing SQL script if … Read More


Title case headlines are highly overrated

There are various misconceptions in the blogging world surrounding title cases these days and there are many who advocate putting all your headlines in title case, some of them are: "It Looks Good": The most commonly thrown argument is that title cases are somehow aesthetically pleasing or they look good … Read More



Dealing with writer's block: The ultimate checklist

Writer's Block is something that even the best among us struggle with occasionally and there is no easy answer to it. I've been following techniques such as the 10 content-types method to brainstorm and come up with ideas but all such techniques have a limit, eventually the block finds some … Read More

How to generate a never ending supply of blog posts

Tags: SEO  
If you're suffering from writer's block or don't know what to write about or how to research content for your next blog post, this guide will help you. There are just about 10 basic content-types or patterns around which weblog articles are written these days, and by creatively combining them … Read More

Page 1 / 12 »