Month hour and minute listing


Month List ---------------------------------------------------->

private static $monthArray = array("01"=>"January",
"02"=>"February",
"03"=>"March",
"04"=>"April",
"05"=>"May",
"06"=>"June",
"07"=>"July",
"08"=>"August",
"09"=>"September",
"10"=>"October",
"11"=>"November",
"12"=>"December");

// print month list
static function getMonthList($listName = "", $id="", $width = 250){
print self::createList(self::$monthArray,$listName,$id,$width,"Month",false);
}

Hour and Minute?List ---------------------------------------------------->

private static $hourListArray =array();
private static $minuteListArray =array();

// print Issue Number
static function getHourList($listName = "", $id="", $width = 250){
for ($i = 1; $i<=23; $i++){
$i = str_pad($i, 2, "0", STR_PAD_LEFT);
self::$hourListArray[$i] = $i;
}
print self::createList(self::$hourListArray,$listName,$id,$width,"Hour",false);
}

static function getMinuteList($listName = "", $id="", $width = 250){
for ($i = 1; $i<=59; $i++){
$i = str_pad($i, 2, "0", STR_PAD_LEFT);
self::$minuteListArray[$i] = $i;
}
print self::createList(self::$minuteListArray,$listName,$id,$width,"Min",false);
}

&nbsp;

&nbsp;

Random number in mysql

For generating a random number between any two numbers we can use below code

update gurtestimonials set testrating = 5 – FLOOR( RAND( ) * ( 5 -4 +1 ) );

maxnum-FLOOR( RAND( ) * ( maxnum?-minnum +1 ) );