Comma Seperated List
Posted by Michael on Sunday, Feb 8th, 2009 |
Comments | code snippet, PHP | 
Permalink
Easy way to create a comma seperated list, pulled from a mysql database table-
<?
$query = mysql_query("SELECT item FROM table WHERE color = 'red'");
$system_array = array() ;
$i = 0 ;
while ( $row = mysql_fetch_assoc( $query ) )
{
$system_array[ $i ] = $row[ 'item' ] ;
$i++ ;
}
$item_list = implode( ', ', $system_array ) ;
echo $item_list;
?>
Date Formatting
Posted by Michael on Sunday, Feb 8th, 2009 | Comments | code snippet, PHP | Permalink
Some example code on date formatting...
<?
$thirtyDays = mktime(date("H"), date("i"), date("s"), date("m"), date("d")+30, date("y"));
$sixtyDays = mktime(date("H"), date("i"), date("s"), date("m"), date("d")+60, date("y"));
//Display Current Date, 30 Days from Date, 60 Days from Date
echo "Today: ". date('Y-m-d H:i:s') . "<br />";
echo "30 Days: ". date('Y-m-d H:i:s',$thirtyDays) . "<br />";
echo "60 Days: ". date('Y-m-d H:i:s',$sixtyDays) . "<br />";
?>
<br />
<?
//Current Date Formatted
echo date("F j, Y, g:i a") . "<br />";
//30 Days from Current Date, formatted
echo date("F j, Y, g:i a", $thirtyDays);
?>
