  <table width="100%" border="0" align="center">
					  <tr>
						<td height="34" colspan="4" align="center" valign="middle"><form id="form2" method="post" action="">
						  <label for="textSerch"></label>
						  <input type="hidden" name="showMenu" value="menu"/>
						  查找
<input type="text" name="textSerch" id="textSerch" />
						  <input type="submit" name="button3" id="button3" value="提交" />
						</form></td>
					  </tr>
					  <tr>
						<td width="24" align="center" bgcolor="#EACA00">菜号</td>
						<td width="211" align="center" bgcolor="#EACA00">菜名</td>
						<td width="66" align="center" bgcolor="#EACA00">餐台价</td>
						<td width="51" align="center" bgcolor="#EACA00">外卖价</td>
					  </tr>
					  
					<?php
						  
						 $sql = "SELECT UserCode,ProductName,UnitPrice,UnitPrice2,ProductID  FROM Products";
						if (!empty($_POST['CategoryID'])) {  $sql .= " where CategoryID=".$_POST['CategoryID']; }  
						if (!empty($_POST['textSerch'])) {  $sql .= " where ProductName like '%".$_POST['textSerch']."%'"; }
					//echo $sql.$_POST['CategoryID'];
$values = $orders->query($sql);
if (is_iterable($values)){
  foreach ($values as $p){ 
$p['UserCode']=loadFromMssql($p['UserCode']);
$p['ProductName']=loadFromMssql($p['ProductName']);

 ?>
							<tr>
							
							<td bgcolor="#D4E300"> <?php echo $p['UserCode']; ?> </td> 
							<td bgcolor="#D4E300">
							  <form id="form1" method="post" action=""><?php //if (!empty($_REQUEST[wechat])) echo '  <input type="hidden" name="wechat" id="wechat" value="'.$_REQUEST[wechat].'"/>'; ?>
							 <?php 
							 if (!empty($_GET['OrderID'])) {
									echo '  <input type="hidden" name="OrderID" id="OrderID" value="'.$_GET['OrderID'].'"/>';  ?> 
									 <input name="Quantity" type="text" style= "width:30px;" value="1" size="5"/>
									 <input type="submit" name="button" id="button" value="<?php echo $p['ProductName']; ?>" />
									 <input type="hidden" name="ProductID" id="ProductID" value="<?php echo $p['ProductID']; ?>"/>
									 <input type="hidden" name="UserCode" id="UserCode" value="<?php echo $p['UserCode']; ?>"/>
									 <input type="hidden" name="ProductName" id="ProductName" value="<?php echo $p['ProductName']; ?>"/>
									 <input type="hidden" name="UnitPrice" id="UnitPrice" value="<?php echo $p['UnitPrice2']; ?>"/>
							 <?php  }else{  echo $p['ProductName'];  }	?>
							  </form>
							  </td> 
							  <td align="center" bgcolor="#D4E300"> <?php echo number_format($p['UnitPrice'],2); ?></td>
							  <td align="center" bgcolor="#D4E300"> <?php echo number_format($p['UnitPrice2'],2); ?></td>
							</tr>
						<?php   }
						}
 					?>
					  
					</table>  