條件是顯示問題?- 藍色小舖 BlueShop

台灣最大程式設計社群網站

∣免費加入會員∣登入 ∣回首頁∣ 您好

線上人數
1121

會員總數：246213
討論主題：189783

登入

登出

歡迎您免費加入會員

討論區選單

開發工具

行動裝置開發

資料庫

多媒體 / 網管

綜合

文章區

討論區列表 >> PHP >> 條件是顯示問題?

[]

[我要回覆]

條件是顯示問題?
價值 : 80 QP 點閱數:864 回應數:2

樓主

50	32
548	90

發送站內信

一個頁有兩個資料集其一為帳號Recuser而其二為列出報表Rereport
我在列出報表有個"修改"的聯結因為報表會顯示出所有人寫的報表資料
而我想使用條件是顯示的方式使得帳號與報表名字一樣才會顯示"修改"進入修改頁面

以Recuser(用Session變數MM_Username來顯示目前使用者身份)
而報表頭也有個re_name現示為誰寫的
所以我用以欄位與Session變數比較不等於就將"修改"隱藏起來可是就是不會依內容來顯示與隱藏?

只會全顯示會全都隱藏?是我哪寫錯了?

整頁的程式碼

<?php require_once('Connections/connMember.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
  session_start();
}
mysql_query("SET NAMES'UTF8'");
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  $_SESSION['MM_Username'] = NULL;
  $_SESSION['MM_UserGroup'] = NULL;
  $_SESSION['PrevUrl'] = NULL;
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  unset($_SESSION['PrevUrl']);
	
  $logoutGoTo = "index.html";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "artadmin,RS,WarehouseTube,artHead,RHead,general";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "layout-report.php?errMsg=1";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$colname_Recuser = "-1";
if (isset($_GET['MM_Username'])) {
  $colname_Recuser = $_GET['MM_Username'];
}
mysql_select_db($database_connMember, $connMember);
$query_Recuser = sprintf("SELECT * FROM usersearch WHERE user_name = %s", GetSQLValueString($colname_Recuser, "text"));
$Recuser = mysql_query($query_Recuser, $connMember) or die(mysql_error());
$row_Recuser = mysql_fetch_assoc($Recuser);
$totalRows_Recuser = "-1";
if (isset($_SESSION['MM_Username'])) {
  $totalRows_Recuser = $_SESSION['MM_Username'];
}
$colname_Recuser = "-1";

$colname_Recuser = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Recuser = $_SESSION['MM_Username'];
}
mysql_select_db($database_connMember, $connMember);
$query_Recuser = sprintf("SELECT * FROM staff WHERE username = %s", GetSQLValueString($colname_Recuser, "text"));
$Recuser = mysql_query($query_Recuser, $connMember) or die(mysql_error());
$row_Recuser = mysql_fetch_assoc($Recuser);
$totalRows_Recuser = mysql_num_rows($Recuser);

$colname_Recreport = "-1";
if (isset($_GET['main_id'])) {
  $colname_Recreport = $_GET['main_id'];
}
mysql_select_db($database_connMember, $connMember);
$query_Recreport = sprintf("SELECT reportmain.main_id, reportmain.main_date, reportmain.main_category,COUNT( reportre.main_id)AS num_re, reportre.re_id, reportre.re_unit, reportre.re_title, reportre.re_name, reportre.report1, reportre.report2, reportre.report3, reportre.report4, reportre.report5, reportre.re_date FROM reportmain LEFT JOIN reportre ON reportmain.main_id = reportre.main_id WHERE reportmain.main_id = %s GROUP BY reportmain.main_id, reportmain.main_date, reportmain.main_category, reportre.re_id, reportre.re_unit, reportre.re_title, reportre.re_name, reportre.report1, reportre.report2, reportre.report3, reportre.report4, reportre.report5, reportre.re_date ORDER BY reportre.re_unit,reportmain.main_date DESC", GetSQLValueString($colname_Recreport, "int"));
$Recreport = mysql_query($query_Recreport, $connMember) or die(mysql_error());
$row_Recreport = mysql_fetch_assoc($Recreport);
$totalRows_Recreport = mysql_num_rows($Recreport);

$MM_paramName = "";

// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
$MM_removeList = "&index=";
if ($MM_paramName != "") $MM_removeList .= "&".strtolower($MM_paramName)."=";
$MM_keepURL="";
$MM_keepForm="";
$MM_keepBoth="";
$MM_keepNone="";
// add the URL parameters to the MM_keepURL string
reset ($HTTP_GET_VARS);
while (list ($key, $val) = each ($HTTP_GET_VARS)) {
	$nextItem = "&".strtolower($key)."=";
	if (!stristr($MM_removeList, $nextItem)) {
		$MM_keepURL .= "&".$key."=".urlencode($val);
	}
}
// add the Form parameters to the MM_keepURL string
if(isset($HTTP_POST_VARS)){
	reset ($HTTP_POST_VARS);
	while (list ($key, $val) = each ($HTTP_POST_VARS)) {
		$nextItem = "&".strtolower($key)."=";
		if (!stristr($MM_removeList, $nextItem)) {
			$MM_keepForm .= "&".$key."=".urlencode($val);
		}
	}
}
// create the Form + URL string and remove the intial '&' from each of the strings
$MM_keepBoth = $MM_keepURL."&".$MM_keepForm;
if (strlen($MM_keepBoth) > 0) $MM_keepBoth = substr($MM_keepBoth, 1);
if (strlen($MM_keepURL) > 0)  $MM_keepURL = substr($MM_keepURL, 1);
if (strlen($MM_keepForm) > 0) $MM_keepForm = substr($MM_keepForm, 1);

$queryString_Recreport = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recreport") == false && 
        stristr($param, "totalRows_Recreport") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recreport = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recreport = sprintf("&totalRows_Recreport=%d%s", $totalRows_Recreport, $queryString_Recreport);
?>
<html>
<head>
<title>富貴內部管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">

</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="981" height="902" border="0" align="center" cellpadding="0" cellspacing="0" class="table-bg" id="___01">
	<tr>
		<td rowspan="3">
			<img src="images/layout_01.jpg" width="5" height="283" alt="" /></td>
		<td colspan="4" rowspan="2"><iframe src="memu/layout-memu.html" width="934" height="79" scrolling="no" frameborder="0" marginwidth="0" marginheight="0" ></iframe></td>
		<td colspan="2" rowspan="2">
			<img src="images/layout_04.jpg" width="41" height="79" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="1" height="58" alt="" /></td>
	</tr>
	<tr>
		<td>
			<img src="images/間距.gif" width="1" height="21" alt="" /></td>
	</tr>
	<tr>
		<td colspan="6"><img src="images/images/pmemu4-6_06.jpg" width="975" height="204"></td>
		<td>
			<img src="images/間距.gif" width="1" height="204" alt="" /></td>
	</tr>
	<tr>
		<td colspan="2" rowspan="5" valign="top"><table width="242" border="0" cellspacing="0" cellpadding="0">
		  <tr>
		    <td><img src="images/layout_07.jpg" width="242" height="33"></td>
	      </tr>
		  <tr>
		    <td><table width="242" border="0" cellspacing="0" cellpadding="0">
		      <tr>
		        <td width="50">&nbsp;</td>
		        <td width="170"><table width="170" border="0" cellspacing="0" cellpadding="0">
		          <tr>
		            <td align="center">&nbsp;</td>
		            </tr>
		          <tr>
		            <td align="left">帳號：<?php echo $row_Recuser['staff_name']; ?></td>
		            </tr>
		          <tr>
		            <td align="left">登出：<a href="<?php echo $logoutAction ?>">登出管理頁面</a></td>
		            </tr>
		          <tr>
		            <td align="left">&nbsp;</td>
		            </tr>
	            </table></td>
		        <td width="22">&nbsp;</td>
	          </tr>
	        </table></td>
	      </tr>
		  <tr>
		    <td><img src="images/layout_11.jpg" width="242" height="35" border="0"></td>
	      </tr>
	    </table>
		  <table width="242" border="0" cellspacing="0" cellpadding="0">
	      <tr>
	        <td><img src="images/images/pmemu1-7_12.jpg" width="242" height="333" border="0" usemap="#Map2"></td>
          </tr>
        </table></td>
		<td colspan="5" rowspan="2"><img src="images/images/pmemu2-5_29_08.jpg" width="738" height="99"></td>
		<td>
			<img src="images/間距.gif" width="1" height="33" alt="" /></td>
	</tr>
	<tr>
		<td>
			<img src="images/間距.gif" width="1" height="66" alt="" /></td>
	</tr>
	<tr>
	  <td colspan="5" rowspan="3" valign="top" class="tb-bg"><table width="738" border="0" cellspacing="0" cellpadding="0">
	    <tr>
	      <td width="18">&nbsp;</td>
	      <td width="665"><form name="form1" method="POST">
	        <table width="665" border="0" align="center" cellpadding="0" cellspacing="0" id="h">
	          <tr>
	            <td width="20" align="center">&nbsp;</td>
	            <td align="center">&nbsp;</td>
	            </tr>
	          <tr>
	            <td width="20" align="center">&nbsp;</td>
	            <td>工作日/週報表閱覽</td>
	            </tr>
	          <tr>
	            <td width="20" align="center">&nbsp;</td>
	            <td>報表類別：<?php echo $row_Recreport['main_category']; ?> 、 報表日期：<?php echo $row_Recreport['main_date']; ?> 。</td>
	            </tr>
	          </table>
	        <?php do { ?>
	          <?php /*start db_input script*/ if ($row_Recreport['re_id'] != ""){ ?>
                  <table width="665" border="0" cellspacing="0" cellpadding="0" onMouseOver="this.style.backgroundColor='#BFF6F3';" onMouseOut="this.style.backgroundColor='';">
                    <tr>
                      <td width="20" height="59">&nbsp;</td>
                      <td colspan="2" align="right">報表繳交時間：<?php echo $row_Recreport['re_date']; ?>。</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td width="45" align="right">單位：</td>
                      <td width="604" align="left"><?php echo $row_Recreport['re_unit']; ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td width="45" align="right">職稱：</td>
                      <td><?php echo $row_Recreport['re_title']; ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td width="45" align="right">姓名：</td>
                      <td><?php echo $row_Recreport['re_name']; ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2" align="right"><input name="re_id" type="hidden" id="re_id" value="<?php echo $row_Recreport['re_id']; ?>">
                        <a href="layout-reportadd3.php?<?php echo $MM_keepNone.(($MM_keepNone!="")?"&":"")."re_id=".urlencode($row_Recreport['re_id']) ?>">
                        <?php /*start db_session script*/ if ($row_Recreport['re_name'] != $_SESSION['MM_Username']){ ?>
修改報表
<?php } /*end db_session script*/ ?>
                        </a></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><img src="images/bullet.gif" width="6" height="6"> 本日工作內容簡報 / 本週單位實況：</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><?php echo nl2br(htmlspecialchars($row_Recreport['report1'])); ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><hr></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><img src="images/bullet.gif" alt="" width="6" height="6"> 跨部門 / 對外部協調簡報 / 問體反應顧客意見 ：</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><?php echo nl2br(htmlspecialchars($row_Recreport['report2'])); ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><hr></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><img src="images/bullet.gif" alt="" width="6" height="6"> 預定隔日工作進度 / 工作同仁問題及協調：</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><?php echo nl2br(htmlspecialchars($row_Recreport['report3'])); ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><hr></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><img src="images/bullet.gif" alt="" width="6" height="6"> 建議 / 意見事項：</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><?php echo nl2br(htmlspecialchars($row_Recreport['report4'])); ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><hr></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><img src="images/bullet.gif" alt="" width="6" height="6"> 讀書心得報報告：</td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><?php echo nl2br(htmlspecialchars($row_Recreport['report5'])); ?></td>
                    </tr>
                    <tr>
                      <td width="20">&nbsp;</td>
                      <td colspan="2"><hr></td>
                    </tr>
                  </table>
<?php } /*end db_input script*/ ?>
	          <?php } while ($row_Recreport = mysql_fetch_assoc($Recreport)); ?>
	        <br>
	        <table width="100%" border="0" cellspacing="0" cellpadding="0">
	          <tr>
	            <td width="20">&nbsp;</td>
	            </tr>
	          <tr>
	            <td align="right"><span class="style6">|<a href="#" onClick="history.go(-1);"> 返回原頁面</a> &raquo;</span></td>
	            </tr>
	          </table>
	        </form>
	        <br>
	        <p><br>
            </p></td>
	      <td width="55">&nbsp;</td>
        </tr>
	  </table></td>
	  <td><img src="images/間距.gif" width="1" height="17" alt="" /></td>
  </tr>
  <tr>
		<td>
	<img src="images/間距.gif" width="1" height="35" alt="" /></td>
</tr>
	<tr>
		<td>
			<img src="images/間距.gif" width="1" height="333" alt="" /></td>
	</tr>
	<tr>
		<td colspan="7">
			<img src="images/layout_13.jpg" width="980" height="14" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="1" height="14" alt="" /></td>
	</tr>
	<tr>
		<td colspan="4" rowspan="2">
			<img src="images/layout_14.jpg" width="786" height="120" alt="" /></td>
		<td colspan="2">
			<img src="images/layout_15.jpg" width="179" height="80" alt="" /></td>
		<td rowspan="2">
			<img src="images/layout_16.jpg" width="15" height="120" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="1" height="80" alt="" /></td>
	</tr>
	<tr>
		<td colspan="2"><iframe src="jumpmenu.html" width="179" height="40" scrolling="no" frameborder="0" marginwidth="0" marginheight="0" ></iframe></td>
		<td>
			<img src="images/間距.gif" width="1" height="40" alt="" /></td>
	</tr>
	<tr>
		<td>
			<img src="images/間距.gif" width="5" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="237" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="18" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="526" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="153" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="26" height="1" alt="" /></td>
		<td>
			<img src="images/間距.gif" width="15" height="1" alt="" /></td>
		<td></td>
	</tr>
</table>

<map name="Map2">
  <area shape="rect" coords="72,79,190,110" href="layout-report.php" target="_top">
  <area shape="rect" coords="71,115,189,145" href="layout-reportmanagement.php" target="_top">
  <area shape="rect" coords="74,148,190,179" href="layout-dailyreportadd.php" target="_top">
  <area shape="rect" coords="73,183,190,214" href="layout-restaurantreportadd.php" target="_top">
</map>
</body>
</html>
<?php
mysql_free_result($Recuser);

mysql_free_result($Recreport);
?>

搜尋相關Tags的文章： [ 條件是顯示 ] ,
本篇文章發表於2012-02-07 14:01

1樓

最有價值解答

浩瀚星空

不是很確定你的問題點在哪，或許你可以先直接輸出看看這兩個參數是否真的有帶值。因為看你的寫法沒很大的問題。

不過有幾點還是要跟你說一下會比較好

1.你的修改報表因該是一個<A>來處理吧。你怎麼不將整個<A>都隱藏住呢???只隱藏字串??這樣不是容易被人家看到連結嗎??
2.圖片名稱盡量不要使用中文。
3.session_start();不要再兩個地方做宣告。雖然你是有做判斷處理。但還是盡量不要這樣做。

本篇文章回覆於2012-02-07 15:45

== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--

2樓

不錯的參考

皮皮快跑

發問的技巧是：
不要讓別人當電腦的編譯器腦內幫你編譯你的程式。
也不要期待別人會把你的程式COPY下來放到電腦去測(甚至在有SQL的情形下根本沒法測)
另外，請勿將DREAMWEAVER產生的程式碼PO上來，因為DREAMWEAVER產生的程式碼屬於「垃圾無法維護」的等級。
最後：如果是把DREAMWEAVER產生的程式碼拿來問，我可以肯定就算真的弄出了什麼網頁，也很難找到工作。
雖然我一向就是很不明白ADOBE DREAMWEAVER的開發者也是程式設計師，為什麼會搞出DREAMWEAVER自動產生PHP CODE這種製造垃圾的行為。
更慘的是，國內幾個出DREAMWEAVER FOR PHP的作者~~~~~~出這種書是來浪費紙張資源~~~~~~勉強可回收的垃圾？
這就真的不是我要唸他們了。
我能建議原發問者就是：如果你手上有DREAMWEAVER FOR PHP，看你是要丟了還是要燒了都行。
然後重新買一本單純就是PHP的書重頭開始練起。
並且，不要再使用DREAMWEAVER來寫PHP了。
DREAMWEAVER只是個「網頁排版軟體」OK？
他並不是「程式開發環境」，他不夠格，也不合適。

本篇文章回覆於2012-02-08 07:56

== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--

回覆

如要回應,請先登入.