getOrderList PHP Exemples de code

Exemple #1

0

Afficher le fichier

Fichier : add.php.php Projet : Zerolone/soutuan8

}
?>
><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;
?>

Exemple #2

0

Afficher le fichier

Fichier : cate.php.php Projet : Zerolone/mybbs

      <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>&nbsp;<?php 
        echo $cate['title'];
        ?>
</td>
      <td>&nbsp;<a href="qa.php?cateid=<?php 
        echo $cate['id'];
        ?>
">下级列表</a></td>
      <td>&nbsp;<a href="cate_edit.php?id=<?php 
        echo $cate['id'];
        ?>
">修改</a></td>

Exemple #3

0

Afficher le fichier

Fichier : orders.php Projet : DV8FromTheWorld/Pizza-Order-Website

<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 {
            }
        }

Exemple #4

0

Afficher le fichier

Fichier : class_add.php.php Projet : Zerolone/mybbs

    <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>

Exemple #5

0

Afficher le fichier

Fichier : list.php.php Projet : Zerolone/soutuan8

    </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>&nbsp;<?php 
        echo subString($tuan['title'], 80);
        ?>
</td>
      <td>&nbsp;<?php 
        echo $tuan['price'];
        ?>
</td>
      <td>&nbsp;<a href="#" onClick="ffClick('tuan/edit.php?tid=<?php 
        echo $tuan['id'];
        ?>
&pagenum=<?php

Exemple #6

0

Afficher le fichier

Fichier : navbar.php.php Projet : Zerolone/mybbs

  <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>&nbsp;<select name="order[]" class="inputbox"><?php 
        echo getOrderList($navbar['order']);
        ?>
</select></td>
      <td>&nbsp;<?php 
        echo encode($navbar['title']);
        ?>
</td>
      <td>&nbsp;<?php 
        echo encode($navbar['url']);
        ?>
</td>
      <td>&nbsp;<?php 
        echo $navbar['active_txt'];
        ?>
</td>
			<td><input name="del[]" type="checkbox" id="del<?php

Exemple #7

0

Afficher le fichier

Fichier : list.php.php Projet : Zerolone/soutuan8

		<?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>&nbsp;<?php 
        echo $tuanlist['ttitle'];
        ?>
</td>
      <td>&nbsp;<?php 
        echo $tuanlist['turl'];
        ?>
</td>
      <td>&nbsp;<a href="#" onClick="ffClick('tuanlist/edit.php?tid=<?php 
        echo $tuanlist['tid'];
        ?>

Exemple #8

0

Afficher le fichier

Fichier : special.php.php Projet : Zerolone/mybbs

    <?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>&nbsp;
        <?php 
        if ($article['url'] != '') {
            ?>
        [<a href="<?php 
            echo $article['url'];
            ?>
" target="_blank" title="原始地址：<?php 
            echo $article['url'];
            ?>
">原</a>]
        <?php 
        }

Exemple #9

0

Afficher le fichier

Fichier : group.php.php Projet : Zerolone/mybbs

    </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>&nbsp;<?php 
        echo $group['title'];
        ?>
</td>
			<td><input name="del[]" type="checkbox" id="del<?php 
        echo $group['id'];
        ?>
" value="<?php 
        echo $group['id'];
        ?>
">删除</td>
      <td>&nbsp;<a href="group_edit.php?id=<?php 
        echo $group['id'];

Exemple #10

0

Afficher le fichier

Fichier : cycle.php.php Projet : Zerolone/mybbs

    </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>&nbsp;<input type="hidden" name="id[]" value="<?php 
        echo $cycle['id'];
        ?>
"><select name="order[]" class="inputbox"><?php 
        echo getOrderList($cycle['order']);
        ?>
</select></td>
      <td>&nbsp;<?php 
        echo $cycle['title'];
        ?>
</td>
			<td>&nbsp;<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'];

Exemple #11

0

Afficher le fichier

Fichier : special.php.php Projet : Zerolone/mybbs

      <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>&nbsp;<?php 
        echo $special['title'];
        ?>
</td>
      <td>&nbsp;<a href="module.php?parentid=<?php 
        echo $special['id'];
        ?>
">下级模块</a></td>
      <td>&nbsp;<a href="update.php?id=<?php 
        echo $special['id'];
        ?>
&mode=html">生成</a></td>

Exemple #12

0

Afficher le fichier

Fichier : add.php.php Projet : Zerolone/mybbs

  </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>
          <?

Exemple #13

0

Afficher le fichier

Fichier : module.php.php Projet : Zerolone/mybbs

      <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>&nbsp;<?php 
        echo $module['kind_text'];
        ?>
</td>
      <td>&nbsp;<?php 
        echo $module['title'];
        ?>
</td>
      <td>&nbsp;<a href="module_edit.php?id=<?php 
        echo $module['id'];
        ?>
&parentid=<?php

Exemple #14

0

Afficher le fichier

Fichier : gallery.php.php Projet : Zerolone/mybbs

      <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>&nbsp;<?php 
        echo $ad['hits'];
        ?>
</td>
      <td>&nbsp;<?php

Exemple #15

0

Afficher le fichier

Fichier : announce.php.php Projet : Zerolone/mybbs

		<?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>&nbsp;<select name="level[]" class="inputbox"><?php 
        echo getForumsList($MyDatabase, $announce['level']);
        ?>
</select></td>
      <td>&nbsp;<?php 
        echo $announce['title'];
        ?>
</td>
      <td>&nbsp;<?php 
        echo $announce['startdate'];
        ?>
</td>

Exemple #16

0

Afficher le fichier

Fichier : add.php.php Projet : Zerolone/soutuan8

      <form name="admin_frm" method="POST">
<tr bgcolor="#6A6A6A">
    <td colspan="2" height="26"><b><font color="#FFFFFF">&nbsp;团购管理 &gt;&gt; 团购操作</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;
?>

Exemple #17

0

Afficher le fichier

Fichier : article.php.php Projet : Zerolone/mybbs

      <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>&nbsp;<input type="hidden" name="id[]" value="<?=$article['id']?>">
        <select name="order[]" class="inputbox">
          <?=getOrderList($article['order'])?>
        </select></td>
        	  <td>&nbsp;<?=$article['id']?></td>
        	  <td>&nbsp;<?=$article['flag_txt']?></td>

      <td>&nbsp;<?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>&nbsp;<?=$article['posttime']?></td>
      <td>&nbsp;<?=$article['hits']?></td>
      <td><input name="selectid[]" type="checkbox" id="select<?=$article['id']?>" value="<?=$article['id']?>"></td>
      <td>&nbsp;<a href="edit.php?id=<?=$article['id']?>&pagenum=<?=$pagenum?>">修改</a></td>
    </tr>
	  </label>
    <?php
				}
		}	
		?>

PHP getOrderList Exemples