Hi guys i'm a beginner with php and html can u help me to solve this problem?
It gives me this error Warning: oci_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login.php on line 15
this is my code :
<?php
session_start();
// connect to database
if (isset($_POST['login_btn'])) {
$username =$_POST['username'];
$password =$_POST['password'];
$conn = oci_connect('socialdb', '12345', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$password = md5($password); // remember we hashed password before storing last time
$sql = oci_parse($conn,"SELECT * FROM ACCOUNT WHERE username='$username' AND password='$password'");
$result =oci_execute($sql);
if (oci_num_rows($result) == 1) {
$_SESSION['message'] = "You are now logged in";
$_SESSION['username'] = $username;
header("location: home.php"); //redirect to home page
} else{
$_SESSION['message'] = "Username/password combination incorrect";
}
}
?>
UPDATE:Maybe the problem is in the HTML form :
<!DOCTYPE html>
<html>
<head>
<title>Register, login and logout user php oracle</title>
<link rel="stylesheet" type="text/css" href="stylea.css">
</head>
<body>
<div class="header">
<h1>Register, login and logout user php oracle</h1>
</div>
<?php
if (isset($_SESSION['message'])) {
echo "<div id='error_msg'>".$_SESSION['message']."</div>";
unset($_SESSION['message']);
}
?>
<form method="post" action="login.php">
<table>
<tr>
<td>Username:</td>
<td><input type="text" name="username" class="textInput"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password" class="textInput"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="login_btn" value="Login"></td>
</tr>
</table>
</form>
</body>
</html>Thank you and sorry for my bad english.
</div>
