"; echo ""; ?> "; echo ""; $userInfo = $_SESSION['userInfo']; if($DEBUG) { echo "userInfo[privilege] = $userInfo[privilege]
"; echo "userInfo[ID] = $userInfo[ID]
"; } $table_name = 'sysBlackPwd'; //$table_name_alluser = 'sysUser'; $sort_field = 'write_time'; $sort_direction = 'ASC'; $number_records_to_display = 210; //查询黑名单有多少条记录 以便分页 /*$blackTable='sysBlackPwd'; $blackSQL="SELECT blackPwd FROM $blackTable "; $blackResult = mysqli_query($pubConn,$blackSQL); while($allBlackRow=mysqli_fetch_array($blackResult)){ $blackRow[]=$allBlackRow; } // print_r($blackRow); echo $blackRow[0]['blackPwd']; */ if (!$initial_record) { $initial_record = 0; $str_sql_all ="SELECT count(*) as number_of_records FROM $table_name "; $result = @mysqli_query($pubConn,$str_sql_all); $record = @mysqli_fetch_object($result); $number_of_records = $record->number_of_records; } if ($number_of_records >= 1) { //下面是控制分页显示，传递变量 $next_index = $initial_record + $number_records_to_display; //本页的结束数目 if ($next_index > $number_of_records) { $next_index = $number_of_records; } $t1 = $initial_record + 1; $prev_index = $initial_record - $number_records_to_display; if ($prev_index < 0) { $prev_index = 0; } } //把记录查询出来 且以write_time为排序规则 $str_sql="SELECT * FROM $table_name ORDER BY $sort_field $sort_direction LIMIT $initial_record, $number_records_to_display"; // echo "
str_sql=$str_sql"; $result = mysqli_query($pubConn,$str_sql); $myrows = @mysqli_fetch_array($result); //倘若没有数据 if(!$myrows) { echo "$strNotFindRecord"; exit(); } ?>

$initial_record - $next_index, ($strTotalRecords: $number_of_records )   "; ?>

"; do{ echo ""; echo ""; //密码 echo ""; //添加黑名单密码的时间 echo ""; //echo "$str_sql_alluser
"; //echo "user prive = $myrows_pri[privilege]"; /* if ( ($myrows_pri['privilege']<$userInfo['privilege']) && ($myrows['userName'] != $userInfo['ID']) ) { echo ""; } else { echo ""; }*/ echo ""; }while($myrows=@mysqli_fetch_array($result)); ?>

$myrows[blackPwd]	$myrows[write_time]	$strDelete	$strForceOff