Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $result='';
- if(isset($_POST['username']) && isset($_POST['password']))
- {
- $username = $_POST['username'];
- $password = $_POST['password'];
- $_SESSION['username'] = $_POST['username'];
- $sql = 'SELECT * FROM login WHERE username = :username AND password = :password';
- $stmt = $conn->prepare($sql);
- $stmt->bindParam(':username', $username, PDO::PARAM_STR);
- $stmt->bindParam(':password', $password, PDO::PARAM_STR);
- $stmt->execute();
- if($stmt->rowCount())
- {
- $result="true";
- }
- elseif(!$stmt->rowCount())
- {
- $result="false";
- }
- echo $result;
- }
- ?>
- <?php
- include 'DatabaseConfig_Apk.php';
- session_start();
- $professor = $_SESSION['username'];
- // Create connection
- $conn = new mysqli($HostName, $HostUser, $HostPass, $DatabaseName);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT NomComplet FROM Info WHERE UserProfessor = '$professor' ";
- $result = $conn->query($sql);
- if ($result->num_rows >0) {
- while($row[] = $result->fetch_assoc()) {
- $tem = $row;
- $json = json_encode($tem);
- }
- } else {
- echo "No Results Found.";
- }
- echo $json;
- $conn->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement