 |
|
ส่งค่าจากอีก form มี อีก form (Edit_orders.php) ด้วย <A Href='Edit_orders.php?type=edit&id=<?=$rows['id_orders']?>'><center><img src='images/User-Edit.png' width='16' height='16' border='0'></center></a>
ใน form มี UPDATE แต่ไม่ UPDATE เหมือน ฟังชั่น UPDATE ไม่ทำงาน ขอบคุณครับ
Code (PHP)
<form id="orders" name="orders" method="post" action=""onSubmit="return checkorders();">
<?
include("config.php");
$sess_id_orders = $_GET['id'];
$sql = "SELECT origin_go , get_back , date_go , train_go , number_of , n_orders , call_orders FROM orders WHERE id_orders='$sess_id_orders'";
mysql_query("SET NAMES 'UTF-8'");
$result = mysql_query ($sql,$conn);
$record = mysql_fetch_array($result,MYSQL_ASSOC);
$origin_go = $_POST ['origin_go'];
$get_back = $_POST ['get_back'];
$date_go = $_POST ['date_go'];
$train_go = $_POST ['train_go'];
$number_of = $_POST ['number_of'];
$n_orders = $_POST ['n_orders'];
$call_orders = $_POST ['call_orders'];
?>
<h1>Sign-up Edit orders</h1>
<div class="list">
<label for="origin_go">สถานีต้นทาง:</label>
<select name="origin_go" class="list">
<option selected><?php echo $record['origin_go'];?> </option>
<?php
require_once 'config/config.php';
$sql = "select * From station";
$table = mysql_query($sql,$conn) or die("ไม่สามารถเลือกตารางได้");
while($row = mysql_fetch_array($table)){
?>
<option value="<?=$row["id_station"];?>"><?=$row["Station"];?></option>
<?php
}
?>
</select>
<font color=#FF0000> * </font>
</div>
<br>
<div class="list">
<label for="get_back"> </label>
<select name="get_back" class="list">
<option selected><?php echo $record['get_back'];?></option>
<?php
require_once 'config/config.php';
$sql = "select * From station";
$table = mysql_query($sql,$conn) or die("ไม่สามารถเลือกตารางได้");
while($row = mysql_fetch_array($table)){
?>
<option value="<?=$row["id_station"];?>"><?=$row["Station"];?></option>
<?php
}
?>
</select>
<font color=#FF0000> * </font>
</div>
<br>
<label for="date_go">กำหนดวันเดินทาง:</label>
<input name="date_go" type="text" id=" " style="width: 80px;" size="20" maxlength="10" value="<?php echo $record['date_go'];?>"/>
<a href="javascript:displayDatePicker('date_go')"><img border="0" src="images/cal.gif" width="16" height="16"></a>
<font color=#FF0000> * </font>
<br>
<div class="list">
<label for="train_go">ขบวนรถ:</label>
<select name="train_go" class="list">
<option selected><?php echo $record['train_go'];?> </option>
<?php
require_once 'config/config.php';
$sql = "select * From formation";
$table = mysql_query($sql,$conn) or die("ไม่สามารถเลือกตารางได้");
while($row = mysql_fetch_array($table)){
?>
<option value="<?=$row["id_formation"];?>"><?=$row["n_Formation"];?></option>
<?php
}
?>
</select>
<font color=#FF0000> * </font>
</div>
<br>
<label for="number_of">จำนวนผู้เดินทาง:</label>
<input name="number_of" type="text" id="number_of" style="width:30px" size="20" maxlength="3" value="<?php echo $record['number_of'];?>"/>
<font color=#FF0000> * </font>
<br>
<label for="n_orders">ชื่อผู้สั่งจอง:</label>
<input name="n_orders" type="text" id="n_orders" style="width:200" size="20" maxlength="100" value="<?php echo $record['n_orders'];?>"/>
<font color=#FF0000> * </font>
<br>
<label for="call_orders">เบอร์ผู้ติดต่อ:</label>
<?php echo $record['call_orders'];?>
<font color=#FF0000> * </font>
<br>
<button type="submit">Sign-up</button>
<?php
if(isset($_SESSION["ses_status"]))
echo $_SESSION["ses_status"];
session_unregister('ses_status');
?>
<div class="spacer">
<?
include("config.php");
if($_POST['f'] == 1){
$sql2 = "UPDATE orders SET origin_go='$origin_go' ,get_back='$get_back' ,date_go='$date_go' ,train_go='$train_go' ,number_of='$number_of' ,n_orders='$n_orders'
WHERE id_orders='$sess_id_orders'";
mysql_query("SET NAMES 'UTF-8'");
echo "<font color=#00CC00><h3> ข้อมูลได้ถูกแก้ไขเรียบร้อย</h3></font>";
echo "[<a href = edit_userinfo.php>กลับไปดูผล </a>]";
}
mysql_query ($sql2,$conn);
?>
</div>
</body>
</html>
Tag : PHP, MySQL
|
|
 |
 |
 |
 |
Date :
2011-05-08 20:14:07 |
By :
gofgof |
View :
978 |
Reply :
7 |
|
 |
 |
 |
 |
|
|
|
 |