Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = "localhost";
- $dbuser = "admin";
- $dbpass = "***";
- $dbname = "***";
- mysql_connect($dbhost, $dbuser, $dbpass);
- mysql_select_db($dbname) or die(mysql_error());
- //$sql = mysql_query("SELECT * FROM shipping_instructions WHERE id = 1") or die(mysql_error());
- //$array = mysql_fetch_array($sql);
- $order_number = (int)$_GET['order_number'];
- $check_duplicate = mysql_query("SELECT id FROM shipping_instructions WHERE order_number = '$order_number' LIMIT 1") or die(mysql_error());
- if(mysql_num_rows($check_duplicate) > 0) {
- echo json_encode(array('code' => 0,
- 'result' => "This order number was entered before. Are you sure you want to create this order? <br />
- <span style=padding-left:10px;><a href=shippingI_create_list.php?action=add&order_number=".$order_number."><img src=shippinginstructions/button_yes.png border=0 /></a> <a href=shippingI_create_list.php><img src=shippinginstructions/button_no.png border=0 /></a></span>
- "
- ));
- die;
- }else{
- $sql = mysql_query("SELECT orders_id FROM orders WHERE orders_id = '$order_number' LIMIT 1") or die(mysql_error());
- if(mysql_num_rows($sql) > 0) {
- echo json_encode(array('code' => 2,
- 'result' => "$order_number"
- ));
- die;
- }else{
- echo json_encode(array('code' => 0,
- 'result' => "this order number doesn't exist please enter correct order number ".$order_number.""
- ));
- die;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement