category_num_form.php

来自「The Shift Log is a database entry and di」· PHP 代码 · 共 57 行

	<?PHP
			//Display category by the order id
			$conn;
			$query="SELECT * FROM category ORDER BY o_id";
			$result=mysql_query($query);
			if (mysql_num_rows($result) > 0) 
				{
   				echo'<table align="left" width="20%"  border="1" cellpadding="4" cellspacing="0" id="cat_order">';
					echo "<tr>";
					echo "<td colspan=\"2\">";
					echo "Category List";
					echo "</td>";
					echo "</tr>";
   				while ($row = mysql_fetch_assoc($result)) 
					{
					$name = $row['catname'];
					$o_id = $row['o_id'];
					print("</tr><tr>");
					echo "<td align=\"right\">";		
					echo $name;
					echo "</td>";
					echo "<td align=\"right\">";
					echo $o_id;
					echo "</td>";
  					echo "</tr>";
					}
   				echo '</table>';
			 }
	
		$oid = $_POST['id'];
		$conn;
		$query="SELECT * FROM category WHERE cat_id= '$oid'";
		$result=mysql_query($query);
		$line = mysql_fetch_assoc($result);
	?>
	<form name="pas_reset" action="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>" method="post">
	<table bgcolor="#CCCCCC" width="35%"  border="1">
  		<tr>
  			<td colspan="2" align="center"><p><strong>Change User Password</strong></p>
		    </td>
    	</tr>
  		<tr>
    		<td width="45%">Category:</td>
    		<td width="55%" align="center"><?PHP echo $line['catname']; ?></td>
  		</tr>
		  <tr>
    		<td>Order Number: </td>
    		<td align="center"><input type="text" name="order" value="<?PHP echo $line['o_id']; ?>">
			</td>
  		</tr>
		<input name="c_id" type="hidden" value="<?PHP echo $line['cat_id']; ?>">
  		<tr>
    		<td align="center">&nbsp;</td>
    		<td><input type="submit" name="oidreset" value="Submit" /></td>
  		</tr>
	</table>
	</form>