Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. $sql_check_user_orders="select OrderID from tblorderdetails
  2. inner join CustomerID.tblcustomer=CustomerID.tblorderdetails
  3. where CustomerID.tblorderdetails='sql_get_user_id'$.tblcustomer";
  4. $qry_check_user_orders=mysqli_query($con ,$sql_check_user_orders);
  5. if(isset( $qry_check_user_orders)){
  6. $loginDate = date('dmYHs');
  7. $order_date = $qry_check_user_orders;
  8. $datediff = $loginDate - $qry_check_user_orders;
  9.  
  10. $rent_period= ($datediff / (60 * 60 * 24));
  11.  
  12. if($rent_period > 4)
  13. $sql_block_user="update `tblcustomer` set `blocked`='1' where CustomerID='$qry_get_user_id'"
  14. $qry_block_user=mysqli_query($con ,$sql_block_user);
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement