}
?>
><label for="tcode2">GBK GB2312</label>
</td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">顺 序：</font></td>
<td bgcolor="#FFFFFF"><select name="torder" class="inputbox" id="torder"><?php
echo getOrderList($torder);
?>
</select></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">团 顺 序：</font></td>
<td bgcolor="#FFFFFF"><select name="tuanorder" class="inputbox" id="tuanorder"><?php
echo getOrderList($tuanorder);
?>
</select></td>
</tr>
<tr>
<td width="100" height="20" align="right" bgcolor="#999999"><font color="#FFFFFF">内容规则：</font></td>
<td bgcolor="#FFFFFF"><textarea name="content" cols="45" rows="1" id="content" style="width:500"><?php
echo $content;
?>
</textarea></td>
</tr>
<tr>
<td width="100" height="20" align="right" bgcolor="#999999"><font color="#FFFFFF">标题规则：</font></td>
<td bgcolor="#FFFFFF"><textarea name="title" cols="45" rows="1" id="title" style="width:500"><?php
echo $title;
?>
<td width="40" bgcolor=#999999><font color="#FFFFFF">修改</font></td>
<td width="40" bgcolor=#999999><font color="#FFFFFF">删除</font></td>
</tr>
<form name="form1" action="cate_update.php" method="post">
<?php
if (isset($cate_list)) {
foreach ($cate_list as $cate) {
?>
<tr>
<td>
<input type="hidden" name="id[]" value="<?php
echo $cate['id'];
?>
">
<select name="order[]" class="inputbox"><?php
echo getOrderList($cate['order']);
?>
</select>
</td>
<td> <?php
echo $cate['title'];
?>
</td>
<td> <a href="qa.php?cateid=<?php
echo $cate['id'];
?>
">下级列表</a></td>
<td> <a href="cate_edit.php?id=<?php
echo $cate['id'];
?>
">修改</a></td>
<head>
<?php
include_once 'connect.php';
$items = array();
$itemQuery = mysqli_query($GLOBALS['conn'], "SELECT name FROM Items;");
while ($value = mysql_fetch_array($itemQuery)) {
$items[] = $value;
}
$pizzas = array();
$pizzaQuery = mysqli_query($GLOBALS['conn'], "SELECT name FROM Pizza WHERE pizzaId < 10;");
while ($value = mysql_fetch_array($pizzaQuery)) {
$pizzas[] = $value;
}
echo "I am le orders<br><br>";
getOrderList();
function getOrderList()
{
$details = "<pre> ";
$order = mysqli_query($GLOBALS['conn'], "SELECT orderId FROM Orders;");
while ($row = mysqli_fetch_array($order)) {
echo 'orderId: ' . $row['orderId'] . "<br>";
$order_details = mysqli_query($GLOBALS['conn'], "SELECT itemId, quantity, pizzaId FROM Order_Details\n WHERE orderId={$row['orderId']} ORDER BY itemId ASC;");
while ($row2 = mysqli_fetch_array($order_details)) {
if ($row2['itemId'] == 1) {
$pizza = mysqli_fetch_array(mysqli_query($GLOBALS['conn'], "SELECT name,cost,pizzaSize FROM Pizza WHERE pizzaId={$row2['pizzaId']};"));
echo sprintf("<pre> %s, \$%.2f, %s, Quantity: %d", $pizza['name'], $pizza['cost'], $pizza['pizzaSize'] == 0 ? "Medium" : "Large", $row2['quantity']);
echo "<br>";
} else {
}
}
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">所属专题：</font></td>
<td bgcolor="#FFFFFF"><select name="specialid" id="specialid">
<?php
if(isset($special_list)){
foreach ($special_list as $special){
?>
<option value="<?=$special['id']?>" <?=$special['selected']?>>
<?=$special['title']?>
</option>
<?
}
}
?>
</select></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">顺 序：</font></td>
<td bgcolor="#FFFFFF"><select name="order" class="inputbox"><?=getOrderList($order)?></select></td>
</tr>
<tr>
<td bgcolor="#999999"></td>
<td bgcolor="#FFFFFF">
<input type="hidden" name="id" value="<?=$id?>" />
<input type="hidden" name="mode" value="<?=$mode?>" />
<input type="button" value="<?=$mode_title?>" name="B1" class="inputbox" accesskey="Y" onClick="update_check();" /></td>
</tr>
</form>
</table>
</tr>
<form name="form1" action="update.php" method="post">
<?php
if (isset($tuan_list)) {
foreach ($tuan_list as $tuan) {
?>
<label for="del<?php
echo $tuan['id'];
?>
">
<tr>
<td><input type="hidden" name="id[]" value="<?php
echo $tuan['id'];
?>
"><select name="order[]" class="inputbox" id="order[]"><?php
echo getOrderList($tuan['order']);
?>
</select>
</td>
<td> <?php
echo subString($tuan['title'], 80);
?>
</td>
<td> <?php
echo $tuan['price'];
?>
</td>
<td> <a href="#" onClick="ffClick('tuan/edit.php?tid=<?php
echo $tuan['id'];
?>
&pagenum=<?php
<form name="form1" action="navbar_update.php" method="post">
<?php
if (isset($navbar_list)) {
foreach ($navbar_list as $navbar) {
?>
<label for="del<?php
echo $navbar['id'];
?>
">
<tr>
<input type="hidden" name="id[]" value="<?php
echo $navbar['id'];
?>
">
<td> <select name="order[]" class="inputbox"><?php
echo getOrderList($navbar['order']);
?>
</select></td>
<td> <?php
echo encode($navbar['title']);
?>
</td>
<td> <?php
echo encode($navbar['url']);
?>
</td>
<td> <?php
echo $navbar['active_txt'];
?>
</td>
<td><input name="del[]" type="checkbox" id="del<?php
<?php
if (isset($tuanlist_list)) {
foreach ($tuanlist_list as $tuanlist) {
?>
<label for="del<?php
echo $tuanlist['tid'];
?>
">
<tr>
<td><input type="hidden" name="tid[]" value="<?php
echo $tuanlist['tid'];
?>
">
<!---->
<select name="torder[]" class="inputbox" id="torder[]"><?php
echo getOrderList($tuanlist['torder']);
?>
</select>
<!---->
</td>
<td> <?php
echo $tuanlist['ttitle'];
?>
</td>
<td> <?php
echo $tuanlist['turl'];
?>
</td>
<td> <a href="#" onClick="ffClick('tuanlist/edit.php?tid=<?php
echo $tuanlist['tid'];
?>
<?php
if (isset($article_list)) {
foreach ($article_list as $article) {
?>
<tr>
<label for="select<?php
echo $article['id'];
?>
">
<td><input type="hidden" name="id[]" value="<?php
echo $article['id'];
?>
">
<select name="order[]" class="inputbox">
<?php
echo getOrderList($article['order']);
?>
</select></td>
<td>
<?php
if ($article['url'] != '') {
?>
[<a href="<?php
echo $article['url'];
?>
" target="_blank" title="原始地址：<?php
echo $article['url'];
?>
">原</a>]
<?php
}
</tr>
<form name="form1" action="group_update.php" method="post">
<?php
if (isset($group_list)) {
foreach ($group_list as $group) {
?>
<label for="del<?php
echo $group['id'];
?>
">
<tr>
<td><input type="hidden" name="id[]" value="<?php
echo $group['id'];
?>
"><select name="order[]" class="inputbox"><?php
echo getOrderList($group['order']);
?>
</select></td>
<td> <?php
echo $group['title'];
?>
</td>
<td><input name="del[]" type="checkbox" id="del<?php
echo $group['id'];
?>
" value="<?php
echo $group['id'];
?>
">删除</td>
<td> <a href="group_edit.php?id=<?php
echo $group['id'];
</tr>
<form name="form1" action="update.php" method="post">
<?php
if (isset($cycle_list)) {
foreach ($cycle_list as $cycle) {
?>
<label for="del<?php
echo $cycle['id'];
?>
">
<tr>
<td> <input type="hidden" name="id[]" value="<?php
echo $cycle['id'];
?>
"><select name="order[]" class="inputbox"><?php
echo getOrderList($cycle['order']);
?>
</select></td>
<td> <?php
echo $cycle['title'];
?>
</td>
<td> <a href="<?php
echo $cycle['pic'];
?>
" target="_blank">[预览]</a></td>
<td><input name="del[]" type="checkbox" id="del<?php
echo $cycle['id'];
?>
" value="<?php
echo $cycle['id'];
<td width="40" bgcolor=#999999><font color="#FFFFFF">修改</font></td>
<td width="40" bgcolor=#999999><font color="#FFFFFF">删除</font></td>
</tr>
<form name="form1" action="update.php" method="post">
<?php
if (isset($special_list)) {
foreach ($special_list as $special) {
?>
<tr>
<td>
<input type="hidden" name="id[]" value="<?php
echo $special['id'];
?>
">
<select name="order[]" class="inputbox"><?php
echo getOrderList($special['order']);
?>
</select>
</td>
<td> <?php
echo $special['title'];
?>
</td>
<td> <a href="module.php?parentid=<?php
echo $special['id'];
?>
">下级模块</a></td>
<td> <a href="update.php?id=<?php
echo $special['id'];
?>
&mode=html">生成</a></td>
</table>
</div>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<form name="admin_frm" method="POST">
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">标 题：</font></td>
<td bgcolor="#FFFFFF"><input name="title" type="text" class="InputBox" id="title" style="width:300" onMouseOver="select();" value="<?=$title?>" size="80"></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">静态页面：</font></td>
<td bgcolor="#FFFFFF"><input name="html" type="text" class="InputBox" id="html" style="width:300" onMouseOver="select();" value="<?=$html?>" size="80"></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">顺 序：</font></td>
<td bgcolor="#FFFFFF"><select name="order" class="inputbox">
<?=getOrderList($order)?>
</select></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">所属模板：</font></td>
<td bgcolor="#FFFFFF"><select name="templateid" id="templateid">
<?php
if(isset($template_list))
{
foreach ($template_list as $template)
{
?>
<option value="<?=$template['id']?>" <?=$template['selected']?>>
<?=$template['title']?>
</option>
<?
<td width="40" bgcolor=#999999><font color="#FFFFFF">修改</font></td>
<td width="40" bgcolor=#999999><font color="#FFFFFF">删除</font></td>
</tr>
<form name="form1" action="module_update.php" method="post">
<?php
if (isset($module_list)) {
foreach ($module_list as $module) {
?>
<tr>
<td>
<input type="hidden" name="id[]" value="<?php
echo $module['id'];
?>
">
<select name="order[]" class="inputbox"><?php
echo getOrderList($module['order']);
?>
</select>
</td>
<td> <?php
echo $module['kind_text'];
?>
</td>
<td> <?php
echo $module['title'];
?>
</td>
<td> <a href="module_edit.php?id=<?php
echo $module['id'];
?>
&parentid=<?php
<td width="40" bgcolor=#999999><font color="#FFFFFF">修改</font></td>
<td width="40" bgcolor=#999999><font color="#FFFFFF">删除</font></td>
</tr>
<form name="form1" action="update.php" method="post">
<?php
if (isset($ad_list)) {
foreach ($ad_list as $ad) {
?>
<tr>
<td>
<input type="hidden" name="id[]" value="<?php
echo $ad['id'];
?>
">
<select name="order[]" class="inputbox"><?php
echo getOrderList($ad['order']);
?>
</select>
</td>
<td><a target="_blank" href="<?php
echo $ad['filename'];
?>
"><?php
echo $ad['filename'];
?>
</a></td>
<td> <?php
echo $ad['hits'];
?>
</td>
<td> <?php
<?php
if (isset($announce_list)) {
foreach ($announce_list as $announce) {
?>
<label for="del<?php
echo $announce['id'];
?>
">
<tr>
<td>
<input type="hidden" name="id[]" value="<?php
echo $announce['id'];
?>
">
<select name="order[]" class="inputbox"><?php
echo getOrderList($announce['order']);
?>
</select>
</td>
<td> <select name="level[]" class="inputbox"><?php
echo getForumsList($MyDatabase, $announce['level']);
?>
</select></td>
<td> <?php
echo $announce['title'];
?>
</td>
<td> <?php
echo $announce['startdate'];
?>
</td>
<form name="admin_frm" method="POST">
<tr bgcolor="#6A6A6A">
<td colspan="2" height="26"><b><font color="#FFFFFF"> 团购管理 >> 团购操作</font></b></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">标 题：</font></td>
<td bgcolor="#FFFFFF">
<input name="title" type="text" class="InputBox" id="title" style="width:300" value="<?php
echo $title;
?>
" size="80"></td>
</tr>
<tr>
<td align="right" width="100" bgcolor="#999999" height="20"><font color="#FFFFFF">顺 序：</font></td>
<td bgcolor="#FFFFFF"><select name="order" class="inputbox" id="order"><?php
echo getOrderList($order);
?>
</select></td>
</tr>
<tr>
<td width="100" height="20" align="right" bgcolor="#999999"><font color="#FFFFFF">价格：</font></td>
<td bgcolor="#FFFFFF"><input name="price" type="text" class="InputBox" id="price" style="width:300" value="<?php
echo $price;
?>
" size="80"></td>
</tr>
<tr>
<td width="100" height="20" align="right" bgcolor="#999999"><font color="#FFFFFF">图片：</font></td>
<td bgcolor="#FFFFFF"><input name="pic" type="text" class="InputBox" id="pic" style="width:300" value="<?php
echo $pic;
?>
<td width="40" bgcolor=#999999><font color="#FFFFFF">点击数</font></td>
<td width="24" bgcolor=#999999><font color="#FFFFFF">选定</font></td>
<td width="30" bgcolor=#999999><font color="#FFFFFF">修改</font></td>
</tr>
<form name="form1" action="update.php" method="post">
<?php
if(isset($article_list))
{
foreach ($article_list as $article)
{
?>
<label for="select<?=$article['id']?>">
<tr>
<td> <input type="hidden" name="id[]" value="<?=$article['id']?>">
<select name="order[]" class="inputbox">
<?=getOrderList($article['order'])?>
</select></td>
<td> <?=$article['id']?></td>
<td> <?=$article['flag_txt']?></td>
<td> <?php if($article['url']!=''){?>[<a href="<?=$article['url']?>" target="_blank" title="原始地址：<?=$article['url']?>">原</a>]<?php } ?><a href="preview.php?id=<?=$article['id']?>" target="_blank" title="预览页面">[预]</a><a href="../../aaa.php?id=<?=$article['id']?>" target="_blank"><?=$article['title']?></a></td>
<td> <?=$article['posttime']?></td>
<td> <?=$article['hits']?></td>
<td><input name="selectid[]" type="checkbox" id="select<?=$article['id']?>" value="<?=$article['id']?>"></td>
<td> <a href="edit.php?id=<?=$article['id']?>&pagenum=<?=$pagenum?>">修改</a></td>
</tr>
</label>
<?php
}
}
?>
