Tuesday 17 May 2011

Difference between Function, Procedure and Stored Routine in MySQL

A quick summary:

A stored routine is either a procedure or a function.

A procedure is invoked using a CALL statement and can only pass back values using output variables.

A function can be called from inside a statement just like any other function and can return a scalar value.

reference: http://dev.mysql.com/doc/refman/5.0/en/stored-routines-syntax.html

------------------------------------------------------------------------
Difference between Function, Procedure and Stored Routine in MySQL

Tuesday 10 May 2011

Connecting to AWS EC2 (Linux) Instance With PuTTY via SSH In order to connect to an Amazon Web Services EC2 Linux instance using PuTTY over SSH you mu

Connecting to AWS EC2 (Linux) Instance With PuTTY via SSH
----------------------------------------------------------
In order to connect to an Amazon Web Services EC2 Linux instance using PuTTY over SSH you must generate a PPK file from your private key, then import the PPK to PuTTY. PuTTY does not natively support the private key format generated by Amazon EC2, therefore PuttyGen must be used to convert keys to its internal format.

please, download the following file with the complete information.

Connect to your Amazon AWS EC2 Linux machine using SSH and PuTTY in Windows

Monday 9 May 2011

Checking IE Browser using PHP Script

Checking IE Browser using PHP Script
-------------------------------------
if (preg_match('|MSIE ([0-9].[0-9]{1,2})|',$_SERVER['HTTP_USER_AGENT'])) {
{
 echo 'IE';
}
else {
 echo 'Other Browser';
}