<html>
<html>
<head><title> 90s nostalgia </title> </head>
<body style="background-color:powderblue;">
<h1 style="text-align:center">club 90s </h1> </br></br>
<?php
include("c:\wamp\www\conf.php");
if (isset($_POST['user'] ,$_POST['pass']))
{
$login= $_POST['user'];
$password= $_POST['pass'];
$connection=@mysql_connect($host, $user, $pass)or die("Unable to connect!");
mysql_select_db($db, $connection) or die ('Unable to select database!');
$query="select id from user where username='$login' and password='$password'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
if($num>0)
{
setcookie('cookiename', $login, mktime()+3600, '/');
$name= $_COOKIE["cookiename"];
?>
<p style="text-align:center;font-size:30px"> Welcome <?php echo $name ?>!</p>
<p><a href="members.php">To main page</a></p>
<?php
}
else
{
echo "Invalid username!" ;
}
}
?>
</body>
</html>
<html>
<body style="background-color:powderblue;">
<?php
include("c:\wamp\www\login.php");
$name2= $_COOKIE["cookiename"];
$connection=@mysql_connect($host, $user, $pass)or die("Unable to connect!");
mysql_select_db($db, $connection) or die ('Unable to select database!');
$query2= "select title, category, year from movie where user=' $name2'";
$result2=mysql_query($query2);
?>
</br> </br> </br> </br> </br>
<p style"text-align:center;font-size:23"><a name="rubrik">Your proposal:</a></p>
<font size="2"><a href="add.php" >add title</a></font>
<div style="text-align:center">
<table width="800" border="1">
<th>Title</th><th>Category</th><th>Year</th>
<?php
while ($row = mysql_fetch_assoc($result2))
{
echo '<tr>'.
'<td>'.$row['title'].'</td>'.'<td>'.$row['category'].'</td>'.'<td>'.$row['year'].'</td>'.
'</tr>';
}
?>
</table> </div>
</body>
</html>