【正文】 $row[user_province]./tdtd.$row[user_city]./tdtd.$row[user_address]./tdtd.$row[user_zip]./tdtd.$row[user_phone]./tdtd.$row[user_mail]./tdtd.$row[user_uses]./tdtd.$row[user_permissions]./tdtd.$row[user_lastlogintime]./tdtd.$row[user_logintimes]./tdtd.$row[user_regtime]./tdtda href=?lmbs=.$row[user_id].修改/a/tdtda href=?lmbs=.$row[user_id]. onclick=\javascript:if((39。您確定要刪除嗎？39。))return true。else return false。\ 刪除/a/tdtda href=?lmbs=.$row[user_id].查看成果/a/td/tr。}26 成果查詢（1）成果查詢界面圖 69　成果查詢界面（2）功能簡介管理員在操作頁面中點擊成果查詢進入成果查詢頁面。管理員在成果查詢頁面可以按不同的查詢方式對成果進行查詢，在頁面下半部分顯示查詢的結(jié)果。管理員還可以對查詢出來的成果進行修改信息、刪除等操作。（3）關(guān)鍵代碼$strSql=。include()。switch($SearchWay){case 39。userid39。:$strSql=select * from result where user_id like 39。%$SearchText%39。 order by result_kind limit $offset,$pagesize。break。case 39。username39。:$strSql=select * from result where user_id in (select user_id from users where user_name like 39。%$SearchText%39。) order by result_kind limit $offset,$pagesize。break。case 39。usersex39。:$strSql=select * from result where user_id in (select user_id from users where user_sex like 39。$SearchText39。) order by result_kind limit $offset,$pagesize。break。case 39。userjob39。:$strSql=select * from result where user_id in (select user_id from users where user_job like 39。$SearchText39。) order by result_kind limit $offset,$pagesize。break。case 39。userprovince39。:if($UserCity==city){$strSql=select * from result where user_id in 27(select user_id from users where user_province like 39。$SearchText39。) order by result_kind limit $offset,$pagesize。}else {$strSql=select * from result where user_id in (select user_id from users where user_province like 39。$SearchText39。 and user_city like 39。$UserCity39。) order by result_kind limit $offset,$pagesize。}break。case 39。useruses39。:$strSql=select * from result where user_id in (select user_id from users where user_uses like 39。$SearchText39。) order by result_kind limit $offset,$pagesize。break。case 39。userpermission39。:$strSql=select * from result where user_id in (select user_id from users where user_permissions like 39。$SearchText39。) order by result_kind limit $offset,$pagesize。break。case 39。fundnumber39。:$strSql=select * from result where fund_number like 39。%$SearchText%39。 order by result_kind limit $offset,$pagesize。break。case 39。fundname39。:$strSql=select * from result where fund_name like 39。%$SearchText%39。 order by result_kind limit $offset,$pagesize。break。case 39。resultkind39。:$strSql=select * from result where result_kind like 39。$SearchText39。 order by result_kind limit $offset,$pagesize。break。case 39。papername39。:$strSql=select * from result where paper_name like 39。%$SearchText%39。 order by result_kind limit $offset,$pagesize。break。}$result=mysql_query($strSql,$con)。while($row=mysql_fetch_array($result)){echo tr class=tRcolortdinput type=checkbox name=ids value=.$row[result_id]./tdtd.$row[fund_number]./tdtd.$row[fund_name]./tdtd.$row[result_kind]./tdtd.$row[paper_name]./tdtd.$row[paper_time]./tdtda href=.$row[paper_download].下載/a/tdtda href=?lmbs=.$row[result_id].修改/a/tdtda href=?lmbs=.$row[result_id]. onclick=\javascript:if((39。您確定要刪除嗎？39。))return true。else return false。\ 刪除/a。} 資料查詢（1）資料查詢界面28圖 610　資料查詢界面（2）功能簡介管理員在操作頁面中點擊資料查詢進入資料查詢頁面。管理員在資料查詢頁面可以按不同的查詢方式對資料進行查詢，在頁面下半部分顯示查詢的結(jié)果。（3）關(guān)鍵代碼$strSql=。switch($SearchWay){case 39。userid39。:$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_id like 39。%$SearchText%39。)) limit $offset,$pagesize。break。case 39。username39。:$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_name like 39。%$SearchText%39。)) limit $offset,$pagesize。break。case 39。usersex39。:$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_sex like 39。$SearchText39。)) limit $offset,$pagesize。break。case 39。userjob39。:$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_job like 39。$SearchText39。)) limit $offset,$pagesize。break。case 39。userprovince39。:if($UserCity==city){$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_province like 39。$SearchText39。)) limit $offset,$pagesize。}else {$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_province like 39。$SearchText39。 and user_city like 39。$UserCity39。 )) limit $offset,$pagesize。}break。case 39。useruses39。:$strSql=select * from data where data_id in (select data_id from user_data 29where user_id in (select user_id from users where user_uses like 39。$SearchText39。)) limit $offset,$pagesize。break。case 39。userpermission39。:$strSql=select * from data where data_id in (select data_id from user_data where user_id in (select user_id from users where user_permissions like 39。$SearchText39。)) limit $offset,$pagesize。break。case 39。dataname39。:$strSql=select * from data where data_name like 39。%$SearchText%39。 limit $offset,$pagesize。break。case 39。datakind39。:$strSql=select * from data where data_kind like 39。$SearchText39。 limit $offset,$pagesize。break。case 39。datacontent39。:$strSql=select * from data where data_content like 39。%$SearchText%39。 limit $offset,$pagesize。break。}$result=mysql_query($strSql,$con)。while($row=mysql_fetch_array($result)){echo tr class=tRcolortd.$row[data_name]./tdtd.$row[data_kind]./tdtd.$row[data_content]./td/tr。} 用戶管理設(shè)計 用戶信息瀏覽（1）用戶信息瀏覽界面圖 611　用戶信息瀏覽界面30（2）功能簡介管理員在操作頁面中點擊用戶信息瀏覽，進入用戶信息瀏覽頁面。管理員在該頁面可以查看到用戶的信息并可以對用戶進行修改、刪除、查看成果等操作。（3）關(guān)鍵代碼include()。$strSql=select * from users limit $offset,$pag