<?php
    $con = mysqli_connect("localhost", "id951876_advisingappadmin", "abc12345", "id951876_advisingapp");
if ( !$con ) {
  die( 'connect error: '.mysqli_connect_error() );
}

$username= ( isset($_POST['username']) ) ? $_POST['username'] : '';
$password= ( isset($_POST['password']) ) ? $_POST['password'] : '';
$confirm_password= ( isset($_POST['confirm_password']) ) ? $_POST['confirm_password'] : '';
$name= ( isset($_POST['name']) ) ? $_POST['name'] : '';
$email= ( isset($_POST['email']) ) ? $_POST['email'] : '';
$major= ( isset($_POST['major']) ) ? $_POST['major'] : '';
$starting_year = ( isset($_POST['starting_year']) ) ? $_POST['starting_year'] : '';
$status= ( isset($_POST['status']) ) ? $_POST['status'] : '';



 $statement = mysqli_prepare($con, "INSERT INTO user (username, password, confirm_password, name, email, major, starting_year, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
    mysqli_stmt_bind_param($statement, "ssssssis", $username, $password, $confirm_password, $name, $email, $major, $starting_year, $status);
    mysqli_stmt_execute($statement);

    $response = array();
    $response["success"] = true;

    echo json_encode($response);
?>

<?php
    $con = mysqli_connect("localhost", "id951876_advisingappadmin", "cjay777i7", "id951876_advisingapp");

$username= ( isset($_POST['username']) ) ? $_POST['username'] : '';
$password= ( isset($_POST['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, $user_id, $username, $password, $confirm_password, $name, $email, $major, $starting_year, $status);

    $response = array();
    $response["success"] = false;

    while(mysqli_stmt_fetch($statement)){
        $response["success"] = true;
        $response["username"] = $username;
        $response["password"] = $password;
        $response["confirm_password"] = $confirm_password;
        $response["name"] = $name;
        $response["email"] = $email;
        $response["major"] = $major;
        $response["starting_year"] = $starting_year;
        $response["status"] = $status;
    }

    echo json_encode($response);
?>