<?php
session_start();
$hostname = "localhost";
$database = "mydb";
$username = "myuser";
$password = "mypsw";
$link = mysql_connect( $hostname , $username , $password ) or
die("Prosoxi!Provlima stin sundesi me ton server : " . mysql_error());
mysql_select_db($database,$link);
$Qcheck_user = "SELECT user.*
FROM `user`
WHERE user.username = '$user'
AND user.password = '$psw' ";
$check_user = mysql_query($Qcheck_user , $link) or
die("Prosoxi!Provlima stin epilogi pinaka user : " . mysql_error());
$number = mysql_num_rows( $check_user );
if ( $number == 0)
{
echo "Πρόβλημα στη σύνδεση. Παρακαλώ ξαναπροσπαθήστε. <br>";
echo "<a href=\"login.php\">Πίσω</a>";
exit;
}
else
{
$user = mysql_fetch_array( $check_user);
$Username = $user[0];
$Name = $user["name"];
$Surname = $user[3];
$Email = $user["email"];
session_register( "Username" , "Name" , "Surname" , "Email" );
header("Location: home.php");
}
?>