How to list Stored Procedures and Functions in MySQL database

How to, Resources, Tips and Tricks, Tutorials
How to check if there are any STORED PROCEDURE in MySQL database? [sourcecode language="sql"]SHOW PROCEDURE STATUS;[/sourcecode] Similarly for MySQL database FUNCTIONS [sourcecode language="sql"]SHOW FUNCTION STATUS;[/sourcecode] But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending [sourcecode language="sql"]## display FUNCTIONS from 'test' db SHOW FUNCTION STATUS WHERE db LIKE ='test';[/sourcecode] Hope it helps somebody. Enjoy!
Read More

CodeIgniter or CakePHP? can’t decide

Personal, PHP
Can't decide between CodeIgniter or CakePHP for my personal project. CodeIgniter is faster in terms of performance but development is slow, CakePHP's cake-bake makes development faster but its performance is not good. My problem is that I need both. I want it at best performance since I will be handling millions even billions of domain records AND I cannot spend more time developing my own system. Any ideas?
Read More

Centralia Pennsylvania, a strange place

Oddly Enough
Centralia is a borough in Columbia County, Pennsylvania, United States. Its population has dwindled from over 1,000 residents in 1981 to 12 in 2005 and 9 in 2007, as a result of a mine fire burning beneath the borough since 1962. Centralia is now the least-populous municipality in Pennsylvania, with four fewer residents than the borough of S.N.P.J. Courtesy of Centralia Pennsylvania on WikiPedia. read more about this by clicking here.
Read More

Link: Did astronaut really Twitter from space?

News
Did a NASA astronaut really “tweet” from space? That’s the question bouncing around Twitter about “Astro_Mike,” or Mike Massimino, an astronaut on space shuttle Atlantis, set to land today at Kennedy Space Center. On May 12, Massimino wrote, “From orbit: Launch was awesome!! I am feeling great, working hard, & enjoying the magnificent views, the adventure of a lifetime has begun!” Ever since, NASA, newspapers, TV shows and blogs have been crediting him as the first person to post on the microblogging service, or “tweet,” while in orbit. In reality, Massimino writes his updates in space and then e-mails them to Houston, where a NASA employee posts them to his Twitter profile. That often takes hours because e-mails are transmitted from the shuttle only a few times a day. Read…
Read More

Creating and Installing crontabs using CodeIgniter

How to, OpenSource, PHP, Resources, Reviews, Tips and Tricks, Tutorials
Last night, I was trying to get a crontab working in CodeIgniter, since my current project (a personal project) is using CodeIgniter now. I didn't wanted to use the conventional approach of running crontabs and my code seperate. Unfortunately, CodeIgniter does not have support for Crontabs and I didn't wanted to user wget in linux crontab to initiate unwanted requests. I spent some time and came up with a solution. It uses CodeIgniter backend Does not modify any core architecture of CodeIgniter Keeps configuration at one place So enough of the summary and let me show you how its done. Create a file (e.g. cron.php) in the same place as your index.php and system folder. Here is its code [php]/** * @author Asim Zeeshan * @web http://www.asim.pk/ * @date 13th…
Read More

Template Library for CodeIgniter, Simple, Fast and Easy!

How to, OpenSource, PHP, Resources, Reviews, Tips and Tricks, Tutorials
If you have not noticed, I just got started on CodeIgniter. I was really disappointed today when I noticed the lack of a template system in CodeIngiter to skin my little application. They say The Template Parser Class is not a full-blown template parsing solution. We've kept it very lean on purpose in order to maintain maximum performance. Lucky for me, I got a little help here, the library is great and works well for the latest version of CI too best of all its small and does not modify the CI code in anyway. It just uses the already available code to skin the application. Sleak! I made a couple of modifications in the original library, here are my modifications [php]<?php if ( ! defined('BASEPATH')) exit('No direct script access…
Read More