Code
<?php
include("../config.inc.php") ;
mysql_select_db($db) ;
if($receiver_name=="" || $receiver_address=="" || $receiver_amper=="" || $receiver_province=="" || $receiver_zipcode=="") {
echo "<meta http-equiv='refresh' content='0; url=order.php'>" ;
exit() ;
}
if((isset($ok)) and ($ok!="ok_pass")) {
echo "<meta http-equiv='refresh' content='0; url=order.php'>" ;
exit() ;
}
$order_date = date("j/n/").(date("Y")+543) ;
$receiver_name = $_POST['receiver_name'];
$receiver_address = $_POST['receiver_address'];
$receiver_amper = $_POST['receiver_amper'];
$receiver_province = $_POST['receiver_province'];
$receiver_zipcode = $_POST['receiver_zipcode'];
$receiver_phone = $_POST['receiver_phone'];
$status = $_POST['status'];
$Submit = $_POST['Submit'];
$sql="select member_id from member order by member_id";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs)){
$sql="INSERT INTO orders(order_id,order_date,member_id) Values('$order_id','$order_date','".$row['member_id']."')";
$ds=mysql_query($sql) ; echo mysql_error();
}
$sql1="select order_id from orders order by order_id";
$rs=mysql_query($sql1);
while($row=mysql_fetch_array($rs)){
$sql1="INSERT INTO order_details(order_id,order_num,receiver_name,receiver_address,receiver_amper,receiver_province,receiver_zipcode,receiver_phone,status) Values('".$row['order_id']."','$order_num','$receiver_name','$receiver_address','$receiver_amper','$receiver_province','$receiver_zipcode','$receiver_phone','$status')";
$ds=mysql_query($sql1) ; echo mysql_error();
}
echo mysql_error();
if($rs) {
$login_true = $user_name ;
session_is_registered("login_true") ;
echo "<center><font size=\"3\" face='MS Sans Serif'><b><br>ระบบได้จัดเก็บข้อมูลเรียบร้อยแล้ว!!!</b></font></center>" ;
echo "<meta http-equiv='refresh' content='4; url=order_detail.php'>" ;
}
else {
echo "<br><br><center><font size=\"3\" face='MS Sans Serif'><b>ล้มเหลวในการเพิ่มข้อมูล</b></font></center>" ;
echo "<meta http-equiv='refresh' content='4; url=order.php'>" ;
}
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
</head>
<body>
</body>
</html>
[Code
head]Code ส่วนที่ติดปัญหาสมาชิกเห็นรายการสั่งของสมาชิกคนอื่นครับ (ตัดมาเฉพาะส่วนของ php ครับ)(PHP)[/head]
<?php
session_start() ;
if(!session_is_registered("login_true")) {
echo "<meta http-equiv='refresh' content='0;url=../index.php'>" ;
exit() ;
}
include("../config.inc.php") ;
mysql_select_db($db) ;
$result = mysql_query("select * from member where user='$login_true'") or die ("Err Can not to result") ;
$dbarr = mysql_fetch_array($result) ;
?>
<?php
ob_start();
session_start();
include("../config.inc.php") ;
mysql_select_db($db) ;
/* $result = mysql_query("select * from member inner join orders on member.member_id = orders.member_id inner join order_details on orders.order_id = order_details.order_id where member.member_id = orders.member_id and orders.order_id=order_details.order_id") or die(mysql_error()); */
/* $result = mysql_query("select * from member inner join orders on member.member_id = orders.member_id inner join order_details on orders.order_id = order_details.order_id order by 'member_id'") or die(mysql_error()); */
/* $result = mysql_query("select member.*,orders.*,order_details.* from member,orders,order_details where member.member_id=orders.member_id=order_details.order_id where member_id='$member_id'") or die(mysql_error());
*/
$result = mysql_query("select member.member_id,orders.order_date,order_details.order_num,order_details.receiver_name,order_details.receiver_address,order_details.receiver_amper,order_details.receiver_province,order_details.receiver_zipcode,order_details.receiver_phone,order_details.status from member,orders,order_details where user='$login_true'") or die(mysql_error());
$dbarr = mysql_fetch_array($result) ;
while($dbarr = mysql_fetch_array($result))
{
?>
รบกวนด้วยนะครับ ติดปัญหาตรงนี้ที่แก้ไม่หายสักทีครับ ขอบคุณครับ
Tag : - - - -
