Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2017
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. <?php
  2. $dsn = "mysql:host=localhost;dbname=mg";
  3. $username = "root";
  4. $password = "";
  5. $options = array(
  6. PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
  7. );
  8.  
  9. try{
  10. $conn = new PDO($dsn,$username,$password,$options);
  11. } catch (PDOException $e){
  12. echo "Error!".$e->getMessage();
  13. }
  14.  
  15. ?>
  16.  
  17. <?php
  18. session_start();
  19. if(isset($_SESSION['user'])){
  20. header("location: general message.php");
  21. }
  22. require "connection.php";
  23.  
  24. if(isset($_POST['login'])){
  25. $user = $_POST['username'];
  26. $pass = md5($_POST['password']);
  27. $messeg = "";
  28.  
  29. if(empty($user) || empty($pass)) {
  30. $messeg = "Username/Password con't be empty";
  31. } else {
  32. $sql = "SELECT username, password FROM users WHERE username=? AND
  33. password=? ";
  34. $query = $conn->prepare($sql);
  35. $query->execute(array($user,$pass));
  36.  
  37. if($query->rowCount() >= 1) {
  38. $_SESSION['user'] = $user;
  39. $_SESSION['time_start_login'] = time();
  40. header("location: general message.php");
  41. } else {
  42. $messeg = "Username/Password is wrong";
  43. }
  44. }
  45. }
  46.  
  47. ?>
  48.  
  49. //The lives of session is one hour 60*60=3600
  50.  
  51. <?php
  52. session_start();
  53.  
  54. if(isset($_SESSION['user'])){
  55. if((time() - $_SESSION['time_start_login']) > 3600){
  56. header("location: logout.php");
  57. } else {
  58. $_SESSION['time_start_login'] = time();
  59. }
  60. } else {
  61. header("location: logout.php");
  62. }
  63. ?>
  64.  
  65. <?php
  66. session_start();
  67. session_destroy();
  68. header("location: index.php");
  69. ?>
  70.  
  71. // 60*60=3600 one hour
  72.  
  73. <meta http-equiv="Refresh" content="3600" >
  74.  
  75. <?php
  76. require ('site life.php');
  77. ?>
  78.  
  79. try{
  80. $conn = new PDO($dsn,$username,$password,$options);
  81. } catch (PDOException $e){
  82. echo "Error!".$e->getMessage();
  83. }
  84.  
  85. if($query->rowCount() >= 1) {
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement