update.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
$connection = openconnection( );
$I = 1;
for ( ;	$I <= 6;	++$I	)
{
	$STR = "REGISTER_TIME".$I;
	$REGISTER_TIME = $$STR;
	if ( $REGISTER_TIME == "" )
	{
		$query = "delete from ATTEND_DUTY where USER_ID='{$USER_ID}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='{$I}'";
		$cursor = exequery( $connection, $query );
	}
	else if ( is_time( $REGISTER_TIME ) )
	{
		$REGISTER_TIME = $SOME_DATE." ".$REGISTER_TIME;
		$query = "select * from ATTEND_DUTY where USER_ID='{$USER_ID}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='{$I}'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$query = "update ATTEND_DUTY set REGISTER_TIME='{$REGISTER_TIME}' where USER_ID='{$USER_ID}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='{$I}'";
		}
		else
		{
			$query = "insert into  ATTEND_DUTY(USER_ID,REGISTER_TYPE,REGISTER_TIME) values ('{$USER_ID}','{$I}','{$REGISTER_TIME}')";
		}
		$cursor = exequery( $connection, $query );
	}
}
header( "location: index.php?SOME_DATE={$SOME_DATE}" );
?>