"; if(!$stmt) { echo "An error occurred in parsing the sql string.\n"; exit; } oci_execute($stmt); $_SESSION["loggedin"] = "true"; $_SESSION["fname"] = $fnamenew; $_SESSION["lname"] = $fnamenew; $_SESSION["email"] = $fnamenew; oci_close($connect); } //code for logging in $emaillogin = $_POST["email"]; $password = $_POST["password"]; if($emaillogin != "") { $query = "SELECT * FROM users WHERE EMAIL LIKE '$emaillogin' AND PASSWORD LIKE '$password'"; //case insensitive //echo("$query"); /* Set oracle user login and password info */ $dbuser = "lmacfarl"; /* your deakin login */ $dbpass = "newpassword"; /* your deakin password */ $db = "SSID"; $connect = oci_connect($dbuser, $dbpass, $db); if (!$connect) { echo "An error occurred connecting to the database"; exit; } /* check the sql statement for errors and if errors report them */ $stmt = oci_parse($connect, $query); //echo "SQL: $query
"; if(!$stmt) { echo "An error occurred in parsing the sql string.\n"; exit; } oci_execute($stmt); while (oci_fetch_array($stmt)) { $_SESSION["loggedin"] = "true"; $_SESSION["fname"] = oci_result($stmt,"FIRSTNAME"); $_SESSION["lname"] = oci_result($stmt,"LASTNAME"); $_SESSION["email"] = oci_result($stmt,"EMAIL"); oci_close($connect); } } if($action == 'logout') { $_SESSION["loggedin"] = "false"; $_SESSION["fname"] = ''; $_SESSION["lname"] = ''; $_SESSION["email"] = ''; } ?>