t1 = mysql_query($deleteSQL, $connData) or die(mysql_error());
$deleteGoTo = "albumAdminCategory.php";
/*
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
*/
header(sprintf("Location: %s", $deleteGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO albumcategory (ca_name) VALUES (%s)",
GetSQLValueString($_POST['ca_name'], "text"));
mysql_select_db($database_connData, $connData);
$Result1 = my
sql_query($insertSQL, $connData) or die(
mysql_error());
$insertGoTo = "albumAdminCategory.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_connData, $connData);
$query_RecWebInfo = "SELECT * FROM webconfiguration";
$RecWebInfo = mysql_query($query_RecWebInfo, $connData) or die(mysql_error());
$row_RecWebInfo = mysql_fetch_assoc($RecWebInfo);
$totalRows_RecWebInfo = mysql_num_rows($RecWebInfo);
mysql_select_db($database_connData, $connData);
$query_RecCategory = "SELECT albumCategory.ca_id, albumCategory.ca_name, Count(albumMain.album_id) AS AlbumCount FROM albumCategory LEFT JOIN albumMain ON albumCategory.ca_id = albumMain.ca_id GROUP BY albumCategory.ca_id, albumCategory.ca_name";
$RecCategory = mysql_query($query_RecCategory, $connData) or die(mysql_error());
$row_RecCategory = mysql_fetch_assoc($RecCategory);
$totalRows_RecCategory = mysql_num_rows($RecCategory);
?><!DOCTYPE html PUBLIC "-//W3C//DTD X
HTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><?php echo $row_RecWebInfo['webName']; ?></title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="page">
<div id="header">
<div id="webInfo">
<div class="webName"><?php echo $row_RecWebInfo['
webName']; ?> </div>
<div class="webDesc"><?php echo $row_RecWebInfo['webDesc']; ?> </div>
<div class="webNavigation"></div>
</div>
</div>
<div id="sidemenu">
<h2>管理信息 </h2>
<ul>
<li><a href="<?php echo $logoutAction ?>">注销管理</a></li>
<li><a href="adminWebInfo.php">编辑网站信息</a></li>
</ul>
<h2>管理相册</h2>
<ul>
<li><a href="albumAdminCategory.php">相册分类管理</a></li>
<li><a href="albumAdminMain.php">管理相册</a></li>
<li><a href="albumAdminPost.php">添加相册</a></li>
</ul>
</div>
<div id="content">
<h1><a href="#">管理相册</a></h1>
<div class="postContent" id="commentform">
<h2>相册分类管理</h2>
<table width="98%" border="0" align="center" cellpadding="4" cellspacing="1">
<tr>
<th>类别名称</th>
<th width="60" align="center">
<label></label>
相册数</th>
<th width="120" align="center">编辑</th>
</tr>
</table>
<?php do { ?>
<form action="<?php echo $editFormAction; ?>" method="POST" id="form1" name="form1">
<table width="98%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="#F0F0F0">
<tr>
<td><input name="ca_name" type="text" id="ca_name" value="<?php echo $row_RecCategory['ca_name']; ?>" />
<input name="ca_id" type="hidden" id="ca_id" value="<?php echo $row_RecCategory['ca_id']; ?>" /> </td>
<td width="60" align="center"><?php echo $row_RecCategory[