Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. <?php
  2.  
  3. $con = mysqli_connect("mysql1.000webhost.com", "a3021026_patryk", "haslo123", "a3021026_wallet");
  4.  
  5. $username = $_POST["username"];
  6. $password = $_POST["password"];
  7.  
  8. $statement = mysqli_prepare($con, "SELECT * FROM user WHERE username = ? AND password = ?");
  9. mysqli_stmt_bind_param($statement, "ss", $username, $password);
  10. mysqli_stmt_execute($statement);
  11.  
  12. mysqli_stmt_store_result($statement);
  13. mysqli_stmt_bind_result($statement, $userID, $name, $email, $username, $password);
  14.  
  15. $_SESSION = array();
  16. $_SESSION["success"] = false;
  17.  
  18. while(mysqli_stmt_fetch($statement)){
  19. session_start();
  20. header("http://ratcooding.site88.net/showExpense.php");
  21. $_SESSION["success"] = true;
  22. $_SESSION["name"] = $name;
  23. $_SESSION["email"] = $email;
  24. $_SESSION["username"] = $username;
  25. $_SESSION["password"] = $password;
  26. }
  27.  
  28. echo json_encode($_SESSION);
  29. ?>
  30.  
  31. wyswietlanie
  32.  
  33. <?php
  34.  
  35.  
  36. $con = mysqli_connect("mysql1.000webhost.com", "a3021026_patryk", "haslo123", "a3021026_wallet");
  37.  
  38.  
  39. $sql = "select * FROM expense";
  40. $res = mysqli_query($con,$sql);
  41. $result = array();
  42. while($row = mysqli_fetch_array($res)){
  43. array_push($result,
  44. array('expense'=>$row[0]),
  45. array('description'=>$row[1]
  46. ));
  47. }
  48. echo json_encode(array("expense"=>$result));
  49. mysqli_close($con);
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement