Witam
Probuje stworzyc skrypt logowania, ogladam kurs Pana Miroslawa ale cos mi nie wychodzi. To znaczy nie przekierowywuje mnie na strone glowna:
kod:
LOGIN.PHP
<?php
require_once "connect_with_db.php";
$connect = @new mysqli($host, $db_user, $db_password, $db_name);
if($connect->connect_errno!=0)
{
echo "Error: ".$connect->connect_errno;
}
else
{
$login = $_POST ['Login'];
$password = $_POST ['Password'];
$sql_connect = "SELECT * FROM users WHERE userName = '$login' AND userPassword = '$password'";
if(($result_of_connect = @$connect->query($sql_connect)))
{
$how_much_users_is_in_db = $result_of_connect->num_rows;
if($how_much_users_is_in_db>0)
{
$line = $result_of_connect->fetch_assoc();
$user = $line['userName'];
$result_of_connect->free_result();
header('Location: hfs_homepage.php');
}else{
}
}
$connect -> close();
}
?>
CONNECT_WITH_DB.PHP
<?php
/**
* Created by PhpStorm.
* User: kryst
* Date: 13.11.2016
* Time: 16:22
*/
$host = "localhost";
$db_user = "root";
$db_password = "";
$db_name = "hfsusers";
?>
INDEX:PHP
<!DOCTYPE HTML>
<html lang = "de">
<head>
<meta charset = "utf -8" />
</head>
<body>
<form action = "login.php" method = "POST" />
Username:
<br />
<input type = "text" name = "Login" />
<br />
Password:
<br />
<input type = "text" name = "Password" />
<br />
<br />
<input type = "submit" value = "Login" /n>
</body>
</html>
z tego co widze problem jest w lini 18 w pliku login.php, poniewaz ten if sie nie wykonuje, gdy dodac else do kodu to pokazuje mi sie wszystko co tam wpisze... Dodam ze baze danych mam w folderze z projktem i jest tylko jeden uzytkownik.
Tutaj ss bazy:
<a href=https://zapodaj.net/4f02195b73f6e.png.html>baza.png</a>
Albo tak:
https://zapodaj.net/4f02195b73f6e.png.html
Pozdrawiam i milego wieczorku zycze :)