Archive | April, 2008

Escape String

function escape_string($varr){
//Escape array or string in postgre
if(is_array($varr)){
foreach($varr as $key => $value){
$result[$key] = trim(pg_escape_string($value));
}
}else{
$result = trim(pg_escape_string($varr));
}
return $result;
}

Read more
Tutorials
  28. Apr, 2008       0 Comments

PHP Number Leading Zero’s

<?php
$id = 3;
echo sprintf(“%04d”,$id);
//result 0003
?>

Read more
Tutorials
  25. Apr, 2008       3 Comments

PostgreSQL Calculate Age From Birthdate

SELECT EXTRACT(year from AGE(NOW(), ‘1985-08-21′)) as “age”;

Read more
Tutorials
  22. Apr, 2008       3 Comments