Hello,
I'm quite new to PHP development so it could be that I'm going to ask some stupid questions
So I'm making a login script and I'm running to a small problem
I'm getting this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/my_projects/first_test_project/auth.php on line 15
This comes when I perform the login:
my php code:
<?php
require "header.php";
function controle($username,$password){
$sql = "SELECT * FROM klant WHERE Username = '$username' AND Password = '$password'";
}
$username = $_POST['username'];
$password = $_POST['password'];
$login = $_POST['login'];
$result = mysql_query($sql);
if($login && $username && $password){
$num_rows = mysql_num_rows($result);
if($num_rows == 1){
$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
}
}
if(controle($_SESSION['username'], $_SESSION['password']) == false){
?>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">
<table width="200px">
<tr>
<td>Username:</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" name="login" value="Login"></td>
</tr>
</table>
</form>
<?php
}
require "footer.php";
?>
I'm thinking that I made a mistake somewhere, but don't know where ???
