Hej vac
Nå... så det skal serveres på et sølvfad?? lad gå:
Her kommer den første fil som skal hedde bruger_login.php :
<?php
session_start();
session_destroy();
$check_message = $_GET['sys_message'];
?>
<!--
Bruger login
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title></title>
</head>
<body>
<form name="login" method="post" action="main_table.php">
<table border="0" width="300" cellspacing="1" cellpadding="0" bgcolor="#666666" align="center">
<tr>
<td>
<table width="100%" border="0" cellpadding="4" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td colspan="3" bgcolor="#FFFFFF"><h1>Bruger Login</h1></td>
</tr>
<tr>
<td width="65" bgcolor="#FFFFFF">Username</td>
<td width="6" bgcolor="#FFFFFF">:</td>
<td width="100%" bgcolor="#FFFFFF"><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">Password</td>
<td bgcolor="#FFFFFF">:</td>
<td bgcolor="#FFFFFF"><input type="password" name="password" id="password"></td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF">
<font color="red"><i><?php echo $check_message; ?></i></font></td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="300" cellspacing="0" cellpadding="3" bgcolor="#FFFFFF" align="center">
<tr>
<td bgcolor="#FFFFFF" align="right"><input type="submit" title="login" name="Submit" value="Login"></td>
</tr>
</table>
</form>
</div>
</div>
</body>
</html>
Og her den primære fil som skal hedde main_table.php:
<?php
//database informations
$db_hostname = 'localhost';
$db_database = 'mit_projekt';
$db_username = 'bruger';
$db_password = 'kode';
$db_tbl_member = 'brugere';
$db_user_key = 'bruger_id';
//connect to MySQL
$connect = mysql_connect($db_hostname, $db_username, $db_password);
if (!$connect) die("Unable to connect to MySQL: " . mysql_error());
//make sure the right database is selected
mysql_select_db("$db_database")
or die("cannot select DB");
//CHECK USER
//Get SESSION variables
session_start();
$logged_in_user = $_SESSION["logged_in_user"];
$logged_in_password = $_SESSION["logged_in_password"];
//Check if user is stored in the database
$check_user = "SELECT * FROM $db_tbl_member WHERE username='$logged_in_user'
and password='$logged_in_password'";
$check_user_result=mysql_query($check_user);
// Mysql_num_row is counting number of table row
$count=mysql_num_rows($check_user_result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
?>
<html>
<head>
<title>B Project medlemmer</title>
</head>
<body>
<font color="#666666">Du er logget ind som: <?php echo $_SESSION["logged_in_member_name"]; ?> </font>
<a href="bruger_login.php?sys_message=<?php echo 'Du er nu logget ud af systemet';?>">
<img src="lock_break.png" title="log ud" align="right" alt="" border="0"/></a>
<div id="content">
<table border="0" width="800" cellspacing="1" cellpadding="3" bgcolor="#666666" align="center">
<tr>
<td bgcolor="#FFFFFF" colspan="3" align="center">
<h1>PROJECT - BRUGERE</h1>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="50%">
<font color="#666666">fornavne</font>
</td>
<td width="40%">
<font color="#666666">efternavn</font>
</td>
<td bgcolor="#FFFFFF" width="10%">
<font color="#666666">mobil nr.</font>
</td>
</tr>
<?php
$member_db = "SELECT * FROM $db_tbl_member ORDER BY $db_user_ke";
$result = mysql_query($member_db)
or die("Invalid query: " . mysql_error());
while ($member_row = mysql_fetch_array($result))
{
?>
<tr>
<td bgcolor="#FFFFFF" width="50%">
<?php echo $member_row['fornavne']; ?>
</td>
<td bgcolor="#FFFFFF" width="40%">
<?php echo $member_row['efternavn']; ?>
</td>
<td bgcolor="#FFFFFF" width="10%">
<?php echo $member_row['mobilnummer']; ?>
</td>
</tr>
<?php
}
?>
</table>
</div>
</body>
</html>
<?php
//Echo if user is not logged in
}
else {
?>
<html>
<meta http-equiv="refresh" content="0; URL=bruger_login.php
?sys_message=<?php echo 'Du blev logget ud af systemet';?>">
</html>
<?php
}
//CHECK USER - END
?>
Husk selv at tilret adgangen til mysql og at brugeren skal være oprettet i databasen!!!
Og.. der skal også lægges et lille billede ind i samme mappe som filerne som skal hedde "lock_break.png" (hvis anden filtype må du rette det i koden!
Held og lykke!
Ny bruger
Nybegynder
Opret
Preview
