Tiqspace/verifycheck.php at main · paul-just20/Tiqspace · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tiqspace";


 //session_start();

if (isset($_POST['submitBtn'])){

      //GET VALUES INDEX.PHP INPUTFIELDS


        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);
        // Check connection
        if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
        }
        //pass the login data to php
        $email = $_POST['email'];
        $password = $_POST['password'];
        $rememberMeChk =  $_POST['rememberMe'];


        $sql = "SELECT username, password, usertype FROM users WHERE username ='.$email.' AND password ='.$password.'";
        $result = $conn->query($sql);

        if($result -> num_rows >0){
            echo 'success';
            while($row = $result->fetch_row()){
                echo $row['id']." ".$row['username']." ".$row['password']."".$row['usertype'];
            }
            $_SESSION['setRole'] = $row['usertype'];
            $_SESSION['userID'] = $row['id'];
            $_SESSION['user'] = $row['username'];
            echo "Sessions are set";
            echo $_SESSION['setRole']." ".$_SESSION['userID']." ".$_SESSION['loginState'];
        }else{
            echo "no results";
        }
        $conn->close();


    //  $chkValues = $_POST['skills'];
    // $checkboxValues = "";

     // foreach ($chkValues as $chkValue){
       //  $checkboxValues .= $chkValue.", ";
      //}

      //$conn = new mysqli('localhost', 'root', '', 'mydb');
     // if ($conn -> connect_error){
      //   die ('Connection failed: ' .$conn->connect_error);
    //  }

     // $query = $conn->prepare("INSERT INTO register (firstname, lastname, email, phone_no, house_st, city, zipcode, skills) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
    ///  $query->bind_param("sssissis", $fn, $ln, $email, $phone, $house, $city, $zc, $checkboxValues);
    //  $query->execute();
    //  $query->close();
    //  $conn-> close();

      //echo'<script>alert("Registered Successfully!")</script>';
      //echo '<a href="index.php?login">Back to Registration Page</a>';


     /// sample test login successful
      echo '<script type="text/javascript">';
      echo 'alert("Login Successfully!");';
      echo 'window.location.href = "user.php?main";';
      echo '</script>';

}

// test to return to main index.php

echo '<script type="text/javascript">';
echo 'alert("Please login first!");';
echo 'window.location.href = "index.php?login";';
echo '</script>';
?>