| |
|
|
|
|
|
|
|
|
'Jan',
2 => 'Feb',
3 => 'Mar',
4 => 'Apr',
5 => 'May',
6 => 'June',
7 => 'July',
8 => 'Aug',
9 => 'Sep',
10 => 'Oct',
11 => 'Nov',
12 => 'Dec'
);
switch ($mois) {
case 1 :
$mois_aff = 'January';
break;
case 2 :
$mois_aff = 'February';
break;
case 3 :
$mois_aff = 'March';
break;
case 4 :
$mois_aff = 'April';
break;
case 5 :
$mois_aff = 'May';
break;
case 6 :
$mois_aff = 'June';
break;
case 7 :
$mois_aff = 'July';
break;
case 8 :
$mois_aff = 'August';
break;
case 9 :
$mois_aff = 'September';
break;
case 10 :
$mois_aff = 'October';
break;
case 11 :
$mois_aff = 'November';
break;
case 12 :
$mois_aff = 'December';
break;
}
$date_debut = $annee."-".$mois."-1";
$date_fin = $annee."-".$mois."-31";
$result = mysql_query("SELECT
portrait_fille.nom_fille,
portrait_fille.prenom_fille,
photos_fille.id_fille,
photos_fille.rep_photos,
photos_fille.vignette
FROM portrait_fille,photos_fille
WHERE
photos_fille.id_fille=portrait_fille.id_fille
AND photos_fille.date_photos>='$date_debut'
AND photos_fille.date_photos<='$date_fin'
ORDER BY photos_fille.position_photos desc");
# ^^^ big ugly query... wouldn't be that hard if we used unix timestamps though ;)
# now, lets run a quick query to gather the months and years that have a photo gallery
$datesQuery = mysql_query("select year(date_photos) as year, month(date_photos) as month from photos_fille order by year, month");
# we'll need to put the findings in an array now.
while( $row = mysql_fetch_array( $datesQuery ) )
{
$_DATES[$row['year']][$row['month']] = "year={$row['year']}&month={$row['month']}";
}
# lets loop through the results i guess
while( $row = mysql_fetch_array( $result ) )
{
$_thumbnails[] = array('url'=>" ", 'name'=>$row['nom_fille']);
}
# how about we print out the thumbnails like they should be now?
if( count( $_thumbnails ) == 0 )
{
# no images for this month... sorry
echo "C O M I N G S 0 0 N !
";
}
else
{
# there are thumbnails! weeeeee, print them out
$picsPerRow = 4; // how many thumbnails do we want on each row?
$cellWidth = 130; // how wide do we want each cell to be?
echo "\n";
$i = 0;
while( $i < count( $_thumbnails ) )
{
if( $i%$picsPerRow == 0 )
echo "\n";
echo "{$_thumbnails[$i]['url']}
{$_thumbnails[$i]['name']} | \n";
$i++;
if( $i%$picsPerRow == 0 )
echo " \n";
}
echo " \n";
}
?>
\n";
echo date("F",$timestamp) . " " . date("Y",$timestamp);
echo "
\n";
}
?>
|
|
|
= -$display_day_nb; $i--)
{
$time_stamp=mktime (0,0,0,(date ("n", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb))),(date ("j", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb))),(date ("Y", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb))));
$current_day_of_the_week = date ("l", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb));
echo "";
echo (date ("l", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb)));
echo " ".(date ("j", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb)));
echo " ".(date ("F", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb)));
echo " ".(date ("Y", mktime (0,0,0,$current_month_nb,$current_day_nb+$i,$current_year_nb)));
echo "
";
}
echo '
|
|
| ';
//***********************************
// MONTHS
//***********************************
$display_month_nb=7;
for ($i = 0; $i >= -$display_month_nb; $i--)
{
$time_stamp=mktime (0,0,0,(date ("n", mktime (0,0,0,$current_month_nb+$i,$current_day_nb,$current_year_nb))),(date ("j", mktime (0,0,0,$current_month_nb+$i,$current_day_nb,$current_year_nb))),(date ("Y", mktime (0,0,0,$current_month_nb+$i,$current_day_nb,$current_year_nb))));
echo "";
echo " ".(date ("F", mktime (0,0,0,$current_month_nb+$i,$current_day_nb,$current_year_nb)));
echo " ".(date ("Y", mktime (0,0,0,$current_month_nb+$i,$current_day_nb,$current_year_nb)));
echo "
";
}
?> |
|
|
\n";
echo "\t\t\t";
if( is_file( "photos/application/".$row['VI_filename'] ) )
echo "\t\t\t![](\"photos/application/{$row['VI_filename']}\")
\n";
echo "\t\t\t{$row['VI_title']}
\n";
echo "\t\t\t![](\"images/go.GIF\") \n";
echo "\t\t\t![](\"images/del.gif\") \n";
echo "\t\t\t | \n";
if( $i%4 == 3 )
echo "\t\t\n";
$i++;
}
?>
|
|
|
| |
|
