Advertisement
overvolt

funzioni.php

Feb 17th, 2018
941
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.98 KB | None | 0 0
  1. <?php
  2. function database_connect(){
  3.   $host = "localhost";
  4.   $user = "root";
  5.   $password = "overvolt";
  6.   $database = "overnotes";
  7.   $db = new mysqli($host, $user, $password, $database);
  8.   if($db->connect_error){
  9.     return 0;
  10.     }
  11.     else{
  12.         return $db;
  13.   }
  14. }
  15.  
  16. function check_login(){
  17.     session_start();
  18.     $db = database_connect();
  19.     if(isset($_SESSION['login_user'])){
  20.         $userid=$_SESSION['login_user'];
  21.         $result = $db->query("select * from sessioni where userid='".$db->escape_string($userid)."'") or die('ERRORE: ' . $db->error);
  22.         $rows = $result->num_rows;
  23.         if ($rows>=1){
  24.             $row = $result->fetch_assoc();
  25.             $time = $row['time'];
  26.             if(time()-$time>2700){
  27.                 $db->close();
  28.                 header('Location: include/logout.php');
  29.                 return -1;
  30.             }
  31.             $user=$row['user'];
  32.             $db->query("UPDATE sessioni SET time=".time()." WHERE user='".$db->escape_string($user)."'");
  33.             $db->close();
  34.             return $user;
  35.         }
  36.         else{
  37.             $db->close();
  38.             return -1;
  39.         }
  40.     }
  41.     else return -1;
  42. }
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement