Advertisement
Guest User

Untitled

a guest
Mar 28th, 2016
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <?php
  2.  
  3. $host = 'mysql11.000webhost.com';
  4. $user = 'a4466141_antonio';
  5. $pass = 'antonio123';
  6. $my_db = 'a4466141_test';
  7. $dbc = mysqli_connect($host, $user, $pass, $my_db);
  8.  
  9. $broj = $_GET['povecanje']; //ajax zahtjev je poslao varijablu povecanje sa vrijednoscu 100
  10.  
  11. //podignemo vrijednost za 100 u bazi podataka
  12. $query = "UPDATE stepoje SET vrijednost = (vrijednost + $broj) WHERE id=1";
  13. mysqli_query($dbc, $query);
  14.  
  15. //izvucemo novu vrijednost iz baze podataka
  16. $query = "SELECT * FROM stepoje WHERE id=1";
  17. $response = mysqli_query($dbc, $query);
  18.  
  19. while($row = mysqli_fetch_array($response)){
  20. $broj = $row['vrijednost'];
  21. }
  22. mysqli_close($dbc);
  23.  
  24. echo $broj;
  25. exit();
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement