Archive for October, 2009

PHP Ordinal Numbers. 3rd, 4th, 1st, etc.

Posted by Lucas in PHP Programming on October 11th, 2009

Here is a little function you can use to get the proper ordinal. Works for negative numbers too:

     function ordinal($number) {

    // when fed a number, adds the English ordinal suffix. Works for any
    // number, even negatives

    if ($number % 100 > 10 && $number %100 < 14):
        $suffix = "th";
    else:
        switch($number % 10) {

            case 0:
                $suffix = "th";
                break;

            case 1:
                $suffix = "st";
                break;

            case 2:
                $suffix = "nd";
                break;

            case 3:
                $suffix = "rd";
                break;

            default:
                $suffix = "th";
                break;
        }

    endif;

    return "${number}$suffix";

}

Usage:
Just call it with ordinal(179) and you will get back, 179th
Cool eh?

No Comments

Dreamweaver GetSQLValueString function enhancements

Posted by Lucas in PHP Programming on October 11th, 2009

I’ve been using Dreamweaver’s GetSQLValueString function as part of my code for a long time. Over the last few projects, I’ve made some enhancements that you may find useful. It formats phones, SSN, does datetime (instead of just date) and of course you can add your own. Here it is, I hope you enjoy it.

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")	{
if (PHP_VERSION &lt; 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
 case "text":
   $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
   break;
 case "long":
 case "int":
   $theValue = ($theValue != "") ? intval($theValue) : "NULL";
   break;
 case "double":
   $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
   break;
 case "date":
   $theValue = ($theValue != "") ? "'" . date("Y-m-d",strtotime($theValue)) . "'" : "NULL";
  break;
 case "datetime":
   $theValue = ($theValue != "") ? "'" . date("Y-m-d H:i:s",strtotime($theValue)) . "'" : "NULL";
   break;
 case "displaydate":
   $theValue = ($theValue != "") ?  date("m/d/Y h:i:s A",strtotime($theValue)) : "NULL";
   break;
 case "ssn":
   $theValue = ($theValue != "") ? "'" . substr($theValue,0,3)."-".substr($theValue,4,2)."-".substr($theValue,6,9) . "'" : "NULL";
   break;
 case "unssn":
   $arrfind = array(" ","-","/","\");
   $arrrepl = array("","","","");
   $theValue = ($theValue != "") ? "'" . str_replace($arrfind,$arrrepl,$theValue) . "'" : "NULL";
   break;
 case "phone":
   $phone = preg_replace("/[^0-9]/", "", $theValue);
    if(strlen($phone) == 7)
     return "'".preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $phone)."'";
   elseif(strlen($phone) == 10)
     return "'".preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $phone)."'";
   else
     return "'".$phone."'";
   break;
 case "null":
   $theValue = "NULL";
   break;
 case "defined":
   $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
   break;
}
 return $theValue;
}

Here is how you use it: Want a cleaned up phone number? Call it with this:
GetSQLValueString($yourval,"phone")
Need a good null?
GetSQLValueString("NULL","null")
How about a datetime?
GetSQLValueString($mydateval,"datetime")
You get it now, go on with your bad self.

, ,

No Comments