Advertisement
ineedphpsqlhelp

Date Help

Apr 11th, 2024
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | Help | 0 0
  1. EXISTING CODE FOR BANANAS:
  2. if ($player_id == $account_id) {
  3.     $bananaspurchase_more = "<br>Purchased on: $bananas_purchased";
  4. } else {
  5.     $bananaspurchase_more = "";
  6. }
  7.  
  8. HTML FOR HOW IT SHOWS UP ON A PLAYER'S HOMEPAGE:
  9. <tr valign=top><td><b>Bananas:</td><td>$bananas available [$$bananas_fee each: $bpublic] $bananaspurchase_more</td></b>
  10.  
  11. WHAT I ATTEMPTED:
  12. $date=date_create("$bananas_purchased");
  13. date_sub($date,date_interval_create_from_date_string("30 days"));
  14. echo date_format($date,"Y-m-d");
  15.  
  16. ALSO ATTEMPTED TO GET IT TO ADD 30 DAYS TO THE EXISTING DATE IN THE SQL TABLE FOR BANANAS:
  17. $date=date_create("$bananas_purchased");
  18. date_add($date,date_interval_create_from_date_string("30 days"));
  19. echo date_format($date,"Y-m-d");
  20.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement