Nieuw lid |
|
ik heb nu dit:
wat is hier niet goed aan want als ik ben ingelogd krijg ik niets te zien
CREATE TABLE `members` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
CREATE TABLE `members` ( `id` int(4) NOT NULL AUTO_INCREMENT, `username` varchar(65) NOT NULL DEFAULT '', `password` varchar(65) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
Index.php:
<form method="post" action="login.php">
<br />Username: <input type="text" id="username" name="username">
<br />Password: <input type="password" id="password" name="password">
<br /><input type="submit" name="Login" value="Login"> </form>
<form method="post" action="login.php"> <br />Username: <input type="text" id="username" name="username"> <br />Password: <input type="password" id="password" name="password"> <br /><input type="submit" name="Login" value="Login"> </form>
Login.php:
<?php
// Database Connect
$host="localhost"; // Host name
$dbusername="arti"; // Mysql username
$dbpassword="jamiel"; // Mysql password
$db_name="members"; // Database name
// Tabel Connect
$tbl="members";
// Connect, Member select
mysql_connect("$host", "$dbusername", "$dbpassword")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$username=$_POST['username'];
$password=$_POST['password'];
$sql="SELECT * FROM $tbl WHERE username='$username' and password='$password'";
$result=mysql_query($sql);
// Row count
$count=mysql_num_rows($result);
// If result matched $username and $password, table row must be 1
if($count==1){
// Register $myusername, and redirect to file "login_success.php"
session_start();
$_SESSION["logged"] = 1;
header("location:login_success.php");
}
else {
$_SESSION["logged"] = 0;
header("location:index.php");
}
?>
<?php // Database Connect $host="localhost"; // Host name $dbusername="arti"; // Mysql username $dbpassword="jamiel"; // Mysql password $db_name="members"; // Database name // Tabel Connect $tbl="members"; // Connect, Member select $username=$_POST['username']; $password=$_POST['password']; $sql="SELECT * FROM $tbl WHERE username='$username' and password='$password'"; // Row count // If result matched $username and $password, table row must be 1 if($count==1){ // Register $myusername, and redirect to file "login_success.php" $_SESSION["logged"] = 1; header("location:login_success.php"); } else { $_SESSION["logged"] = 0; } ?>
Login_success.php
<?php session_start();
if($_POST["id"] == 1){
?>
echo(Hoi);
<?php
}
elseif($_POST["id"] == 2){
?>
echo(Welkom);
<?php
}
?>
if($_POST["id"] == 1){ ?> echo(Hoi); <?php } elseif($_POST["id"] == 2){ ?> echo(Welkom); <?php } ?>
wat is er nou fout aan?
groet,
Jamiel |