Guest User

Untitled

a guest
Feb 8th, 2019
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. $orderno =$_POST['order_no'][$i];
  2. $status =$_POST['order_status'][$i];
  3.  
  4. <?php
  5. if(isset($_POST['order_status']))
  6. {
  7. $dbhost = 'localhost';
  8. $dbuser = 'root';
  9. $dbpass = '';
  10. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  11. if(! $conn )
  12. {
  13. die('Could not connect: ' . mysql_error());
  14. }
  15. $orderno =$_POST['order_no'][$i];
  16. $status =$_POST['order_status'][$i];
  17. print_r($_POST['order_no']);
  18. $sql = 'UPDATE Orders SET status="' . '$status'. '" WHERE Orderno="' .'$orderno' . '"';
  19. echo $sql;
  20. mysql_select_db('PurchaseOrders');
  21. $retval = mysql_query( $sql, $conn );
  22. if(! $retval )
  23. {
  24. die('Could not update data: ' . mysql_error());
  25. }
  26. echo "Updated data successfullyn";
  27. mysql_close($conn);
  28. }
  29. ?>
  30.  
  31. $sql = 'UPDATE Orders SET status="' . $status. '" WHERE Orderno="' .$orderno . '"';
  32.  
  33. $sql = "UPDATE Orders SET status='" . $status . "' WHERE Orderno= '" . $orderno . "' ";
  34.  
  35. $sql = "UPDATE Orders SET status='$status' WHERE Orderno='$orderno'";
Add Comment
Please, Sign In to add comment