?> <tbody> <tr> <td><div align="center"><?php echo $data['CusOr_ID']; ?> </div></td> <td><div align="center"> <?php echo $data['Cus_Name']; ?> <?php echo $data['Cus_lname']; ?> </div></td> <td><div align="center"> <?php echo thai_date4($date); ?> </div></td> <td><div align="center"> <?php echo $data['Pro_Name']; ?> </div></td> <td><div align="center"> <?php echo $data['CusOr_amount']; ?> </div></td> <td><div align="center"> <?php echo $data['CusOr_Status']; ?> </div></td> <td><div align="center"><a href="./edit_Cus_Pro_In_recv.php?Pro_ID=<?php
<?php include "connect/connect.php"; include "function.php"; $find_CusOr_ID = isset($_REQUEST['id']) ? $_REQUEST['id'] : ""; if ($find_CusOr_ID != "") { $sql = "SELECT CusOr_ID, Cus_Name, Cus_lname, CusOr_Date, Pro_Name, CusOr_amount, CusOr_Status "; $sql = $sql . "FROM customer_order co "; $sql = $sql . "LEFT JOIN product_in p ON ( co.Pro_ID = p.Pro_ID ) "; $sql = $sql . "LEFT JOIN customer c ON ( co.Cus_ID = c.Cus_ID ) "; $sql = $sql . "where CusOr_ID= '{$find_CusOr_ID}' "; //echo $sql; $record = mysql_query($sql) or die(mysql_error()); $data = mysql_fetch_assoc($record); $data['CusOr_Date'] = thai_date4(strtotime($data['CusOr_Date'])); echo json_encode($data); } else { echo json_encode(array("error" => "No ID.")); }
$date2 = strtotime($str2); $CS_PAY = $data['CS_PAY']; ?> <tbody> <tr> <td><div align="center"> <?php echo $data['CS_COST']; ?> </div></td> <td><div align="center"><?php echo thai_date4($date); ?> </div></td> <td><div align="center"><?php echo thai_date4($date2); ?> </div></td> <td><div align="center"> <?php echo number_format("{$CS_PAY}", 2); ?> </div></td> <td><img src="images/icons/png/Edit-128.png"></a></div></td> </tr> </tbody> <?php }