DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 5 DAY);
DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 1 MONTH);
Continue reading Delete rows older than x days or x months in MySQL
07 Jun, 2008
Fatal error: Allowed memory size of * bytes exhausted in PHP
Posted in: PHP, Troubleshooting
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 128 bytes) in /home/yoursite/public_html/index.php on line 1051
The above error is caused by not having enough memory to execute the requested page.
You can adjust the memory limit at run time by specifying the following at the very beginning of your php file (eg: index.php)
ini_set(‘memory_limit’,'12M’);
Or [...]
Continue reading Fatal error: Allowed memory size of * bytes exhausted in PHP
Seconds
Equivalent to
300
5 mins
600
10 mins
900
15 mins
1200
20 mins
1800
30 mins
2700
45 mins
3600
1 hour
7200
2 hours
10800
3 hours
14400
4 hours
18000
5 hours
36000
10 hours
54000
15 hours
86400
1 day
172800
2 days
259200
3 days
345600
4 days
432000
5 days
604800
1 week
1209600
2 weeks
1814400
3 weeks
2419200
4 weeks
14515200
6 months
29030400
1 [...]
Continue reading Seconds to minutes, hours, days, weeks, months, years cheatsheet
Sun Microsystems, Inc. (NASDAQ: JAVA) today announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world’s fastest growing open source databases for approximately $1 billion in total consideration. The acquisition accelerates Sun’s position in enterprise IT to now include the $15 billion [...]
Continue reading Sun acquired MySQL for $1 billion
Description
Display a daily/monthly horoscope for a specified star sign. It accepts an RSS feed URL as a parameter, gets star sign value from within your page content, appends the star sign value to the RSS feed URL, fetches the content of the feed, and changes your page content dynamically upon loading. You can [...]
Continue reading Horoscope Mambot (Plugin) for Joomla!
About 2 million sites (20,016,421 domains, to be precise) use PHP (Ref: Usage Stats for April 2007)
75% of Web 2.0 sites are built in PHP (Ref: InformationWeek)
Some of the biggest online brands, such as Facebook, Friendster, Flickr, Technorati, and Yahoo! are powered by PHP
About 5 million PHP developers worldwide
As of August 2007, PHP is the [...]
Continue reading Quick facts about PHP
In PHP, exporting data into an excel file (.csv) can be achieved very easily by sending a raw HTTP header. And having a formula in cells is no brainier either (and I only found that out after searching through google and not finding any solution – hehe).
The following is a rough example [...]
Continue reading Export into excel with formula in PHP
I have finished reading Professional Web APIs with PHP: eBay, Google, Paypal, Amazon, FedEx plus Web Feeds book by Paul Reinheimer over the weekend.
I have to say, it was quite a resourceful read. I have read a few books on API but I found this book particularly interesting because the book was [...]
Continue reading Book: Professional Web APIs with PHP
A while ago, I wrote a post about my eZ Publish extensions for Flickr and YouTube. I have been meaning to upload them onto official eZ publish repository but didn’t really get to doing it until I received a comment a few days ago which reads, “I’m exactly looking for these extensions. I couldn’t [...]
Continue reading eZ Publish extensions for Flickr and YouTube – Download
I am sure you have heard of all the hype about the fastest growing social networking site, Facebook. Facebook has become very popular, so much so it even creates new jobs in IT & T industry. How do I know, I hear you ask. Have a look at this job [...]
Continue reading Facebook application development
Hello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more 
