2.php

极限网络智能办公系统—MYOA26—100％—源程序。

<?php

$CUR_DATE = date( "Y-m-d", time( ) );
$WEEK_BEGIN = date( "Y-m-d", strtotime( $CUR_DATE ) - date( "w", strtotime( $CUR_DATE ) ) * 24 * 3600 );
$WEEK_END = date( "Y-m-d", strtotime( $CUR_DATE ) + ( 6 - date( "w", strtotime( $CUR_DATE ) ) ) * 24 * 3600 );
$query = "SELECT USER_NAME,BIRTHDAY from USER order by USER_NAME ASC";
$cursor = exequery( $connection, $query );
$PERSON_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_NAME = $ROW['USER_NAME'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$DATA = substr( $CUR_DATE, 0, 4 ).substr( $BIRTHDAY, 4, 6 );
	if ( $DATA < $WEEK_BEGIN || $WEEK_END < $DATA || $BIRTHDAY == "1900-01-01 00:00:00" || $BIRTHDAY == "0000-00-00 00:00:00" )
	{
	}
	else
	{
		$PERSON_STR .= $USER_NAME."(".date( "m-d", strtotime( $DATA ) ).")&nbsp&nbsp&nbsp&nbsp";
		++$PERSON_COUNT;
	}
}
if ( 0 < $PERSON_COUNT )
{
	echo " <tr class=\"TableData\">\r\n  <td colspan=2>\r\n     <marquee style=\"color:#FF6600;\" behavior=scroll scrollamount=3 scrolldelay=120 onmouseover='this.stop()' onmouseout='this.start()' border=0>\r\n     本周生日：";
	echo $PERSON_STR;
	echo "     </marquee>\r\n  </td>\r\n </tr>\r\n";
}
?>