Oto kod pliku index.php
<!DOCTYPE html> <html lang="pl"> <head> <title>Fiszki</title> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Bootstrap --> <link href="res/css/bootstrap.css" rel="stylesheet"> <link href="res/css/bootstrap-theme.css" rel="stylesheet"> <link href="res/css/style.css" rel="stylesheet"> <script type="text/javascript" src="res/js/bootstrap.min.js"></script> </head> <body> <a name="up"></a> <!-- *************************************************************************** --> <?php include("init.php"); $view = $_GET['view']; if($_GET['view'] != 'v_index'){ if(!checkLoginStatus()){ } } $view = 'v_login'; } else { $view = 'v_index'; } switch($action){ case 'index': break; // -------------------------Podstawowe akcje------------------------------ case 'register': if(checkUsername($_POST['login'], $_POST['email'])){ if(checkRegisterData($_POST['login'], $_POST['email'], $_POST['password'], $_POST['password2'])){ register($_POST['login'], $_POST['email'], $_POST['password']); } } break; case 'login': if(login($_POST['login'], $_POST['password'])){ } break; case 'logout': logout(); break; // -------------------------Zarządzanie fiszkami------------------------------ case 'addgroup': if(checkLoginStatus() && isSubmit()){ addgroup($_POST['name'], $_POST['lang'], $_POST['share']); } break; case 'delgroup': if(checkLoginStatus()){ delgroup($_GET['id_gr']); } break; case 'add': if(checkLoginStatus() && checkOwnership($_GET['id_gr'], $_SESSION['id']) && isSubmit()){ add($_GET['id_gr'], $_POST['pl'], $_POST['lg'], $_POST['sub']); } break; case 'del': if(checkLoginStatus() && checkOwnership($_GET['id_gr'], $_SESSION['id'])){ del($_GET['id_fi']); } break; case 'startgroup': if($log = checkLoginStatus() && !startedGroup($_GET['id_gr'])){ startGroups($_GET['id_gr']); } else if($log) { $_SESSION['alert'][] = 'Już rozpocząłeś ten kurs'; } break; case 'learn': break; case 'share': if(checkLoginStatus() && checkOwnership($_GET['id_gr'], $_SESSION['id'])){ share($_GET['id_gr']); } break; case 'nshare': if(checkLoginStatus() && checkOwnership($_GET['id_gr'], $_SESSION['id'])){ nshare($_GET['id_gr']); } break; case 'sendmail': if($_POST['antyspam'] == 'iksleigna' && isSubmit()){ $subject = $_POST['name'] . ' - ' . $_POST['email']; $_SESSION['alert'][] = "Pomyślnie wysłano wiadomość."; } else { $_SESSION['alert'][] = "Niestety nie udało się wysłać wiadomości."; } } else { $_SESSION['alert'][] = "Błąd: Źle przepisany tekst antyspamowy"; } break; } ?> <div class="container"> <div class="row"> <div class="col-md-12"> <div class="well"> <fieldset> <p style="text-align: center; font-weight: bold; color: #ff9900;"> <?php showAlert($_SESSION['alert']); ?> </p> </fieldset> </div> </div> </div> </div> <?php } include('views/' . $view . '.php'); ?> <!-- *************************************************************************** --> </body> </html>
I jeszcze funkcja login
function login($login, $pass){ $db = db(); $query= $db->stmt_init(); //Musi to być aby zwróciło wynik if($query = $db->prepare("SELECT id FROM uzytkownicy WHERE login = ? and haslo = ?")) { $password = sha1($pass); $query->bind_param("ss", $login, $password); $query->execute(); $result = $query->get_result(); $row = $result->fetch_assoc(); if($row['id']) { $_SESSION['id'] = $row['id']; $_SESSION['login'] = $login; $query->close(); return TRUE; } else { $_SESSION['alert'][] = 'Błędny login lub hasło'; return FALSE; } } else { $_SESSION['alert'][] = 'Wystąpił błąd. Przepraszamy.'; return FALSE; } $db -> close(); }
Strona jest obecnie pod adresem fiszki.opx.pl
Login i hasło do użytkownika testowego to L: testowy3, H: 123456
Na XAMPPie wszystko działa jak należy.