|
 |
| |
list menu...ขอ code ดึงข้อมูลจาก database (mysql) มาใส่ list menu หน่อยค่ะ |
| |
 |
|
|
 |
 |
|
Code (PHP)
<?php
<?
include "connect.inc.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 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=windows-874" />
<title>Untitled Document</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="report1_data.php">
<div align="center">
<table width="474" border="0">
<tr>
<td width="127"><div align="center" class="bg_main">Customer Name </div></td>
<td width="75"><div align="center" class="bg_main">Model</div></td>
<td width="103"><div align="center" class="bg_main">P/O Date </div></td>
<td width="159"><div align="center" class="bg_main">Delivery Cycle </div></td>
</tr>
<tr bgcolor="#DEE8FE">
<td><div align="center">
<select name="customer_name" size="1" class="inputbox">
<?
/////////////////////// CUSTOMER_NAME ////////////////////
$sql1 = "select customer_name from master";
$customer_query = mysql_query($sql1,$con);
while($customer = mysql_fetch_array($customer_query))
{ ?>
<option> <? echo $customer['customer_name']; ?></option>
<? } ?>
</select>
</div></td>
<td><div align="center">
<select name="model" size="1" class="inputbox">
<?
/////////////////////// MODEL ////////////////////
$sql2 = "select distinct(model) from master";
$model_query = mysql_query($sql2,$con);
while($model_row = mysql_fetch_array($model_query))
{ ?>
<option> <? echo $model_row['model']; ?></option>
<? } ?>
</select>
</div></td>
<td><div align="center">
<select name="po_date" size="1" class="inputbox">
<?
/////////////////////// P/O DATE ////////////////////
$sql3 = "select distinct(po_date) from scan order by po_date";
$po_query = mysql_query($sql3,$con);
while($po_row = mysql_fetch_array($po_query))
{?>
<option><? echo $po_row['po_date']; ?></option>
<? } ?>
</select>
</div></td>
<td><table width="152" border="0">
<tr align="center">
<td width="52"><select name="cycle1" size="1" class="inputbox">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</select>
-</td>
<td width="52"><select name="cycle2" size="1" class="inputbox">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</select>
-</td>
<td width="41"><select name="cycle3" size="1" class="inputbox">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</select></td>
</tr>
</table></td>
</tr>
</table>
<p>
<input name="submit" type="submit" class="inputbox" value="Send" /></p>
</div>
</form>
</body>
</html>
?>
|
 |
 |
 |
 |
| Date :
2009-05-14 08:36:07 |
By :
panyapol |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
โทดที โพสต์ผิดห้อง
|
| |
|
|
| |
| Date :
2009-05-14 08:40:38 |
By :
mai_sao |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com Tutorial</title>
</head>
<?
mysql_connect("localhost","root","root") or die(mysql_error());
mysql_select_db("mydatabase");
?>
<body>
<form action="phpLlistmenuDatebase2.php" method="post" name="form1">
List Menu<br>
<select name="lmName1">
<option value=""><-- Please Select Item --></option>
<?
$strSQL = "SELECT * FROM customer ORDER BY CustomerID ASC";
$objQuery = mysql_query($strSQL);
while($objResuut = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResuut["CustomerID"];?>"><?=$objResuut["CustomerID"]." - ".$objResuut["Name"];?></option>
<?
}
?>
</select>
<input name="btnSubmit" type="submit" value="Submit">
</form>
</body>
</html>
<?
mysql_close();
?>
|
| |
|
|
| |
| Date :
2011-06-09 21:54:43 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
@ webmaster
กำลังหาพอดีเลย
ขอบคุณมากเลยครัช
|
| |
|
|
| |
| Date :
2013-12-05 16:05:10 |
By :
Brokenza |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 00
|
