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