ik ben zonet begonnen met een login script die ik voor het eerst (dus me eerste script) zelf schrijf en geen kant en klare download.
maar nu stuit ik op 3 problemen
1. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/marco/public_html/Projecten/login-zelfscript/config.php on line 27
2. als ik inlog komt er te staan
Verkeerde Gebruikersnaam of Wachtwoord
3. opgelost!
config.php -> ****** is alleen voor prive verder is het goed ingevult.
PHP
<?php
$host="******";
$username="******";
$password="******";
$db_name="******";
$tbl_name="******";
mysql_connect("$host", "$username", "$password") or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$username=$_POST['username'];
$password=$_POST['password'];
$email=$_POST['email'];
$username = stripslashes($username);
$password = stripslashes($password);
$email = stripslashes($email);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
$email = mysql_real_escape_string($email);
mysql_query()
$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if($count==1){
session_start();
$_SESSION["username"] = 'username';
$_SESSION["password"] = 'password';
$_SESSION["email"] = 'email';
header("location:login_panel.php");
}
else{
echo "Verkeerde Gebruikersnaam of Wachtwoord";
}
?>login.php
PHP
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="config.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Login Systeem (made by marcoboekholt)</strong></td>
</tr>
<tr>
<td width="78">Gebruikersnaam</td>
<td width="6">:</td>
<td width="294"><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td>Wachtwoord</td>
<td>:</td>
<td><input name="password" type="password" id="password"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</body>
</html>login-panel.php
PHP
<?
session_start();
if(!session_is_registered(username)){
header("location:login.php");
}
?>
<html>
<body>
<p>Welkom <?php echo $_SESSION['username'] ?></p>
<p>
<input type="submit" name="logout" id="logout" value="logout" onClick="logout.php"></p>
</p>
</body>
</html>logout.php
PHP
<?
session_start();
session_destroy();
?>groetjes,
Marco Boekholt
