Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $con = mysqli_connect("mysql1.000webhost.com", "a3021026_patryk", "haslo123", "a3021026_wallet");
- $username = $_POST["username"];
- $password = $_POST["password"];
- $statement = mysqli_prepare($con, "SELECT * FROM user WHERE username = ? AND password = ?");
- mysqli_stmt_bind_param($statement, "ss", $username, $password);
- mysqli_stmt_execute($statement);
- mysqli_stmt_store_result($statement);
- mysqli_stmt_bind_result($statement, $userID, $name, $email, $username, $password);
- $_SESSION = array();
- $_SESSION["success"] = false;
- while(mysqli_stmt_fetch($statement)){
- session_start();
- header("http://ratcooding.site88.net/showExpense.php");
- $_SESSION["success"] = true;
- $_SESSION["name"] = $name;
- $_SESSION["email"] = $email;
- $_SESSION["username"] = $username;
- $_SESSION["password"] = $password;
- }
- echo json_encode($_SESSION);
- ?>
- wyswietlanie
- <?php
- $con = mysqli_connect("mysql1.000webhost.com", "a3021026_patryk", "haslo123", "a3021026_wallet");
- $sql = "select * FROM expense";
- $res = mysqli_query($con,$sql);
- $result = array();
- while($row = mysqli_fetch_array($res)){
- array_push($result,
- array('expense'=>$row[0]),
- array('description'=>$row[1]
- ));
- }
- echo json_encode(array("expense"=>$result));
- mysqli_close($con);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement