PHP - Session_set_save_handler To Postgresql

I'm having an issue with sessions and session_set_save_handler.
Note: new at OO PHP

I'm using an MVC written mostly from a tutorial and it all seems to be working, except for sessions.
I've got session_set_save_handler as a class SessionHandler. If I include it into the main index page and create an instance, I get an error 'Undefined variable: _SESSION' for my index view file.
If I instead include a global.php file into the main index page and include the session class into the global.php page, and create an instance, the error goes away and session_set_save_handler saves the session variables into my database.

(1)On my index page for debugging I've got a var_dump of $_SESSION to see which session variables are set.

On my login page I've got a form token that is saved to a session variable. When I go to the login page that session token variable is set and doing a var_dump on the page shows it is indeed being set, however, when I click back to the main index page, the index var_dump(1) shows the session variable is no longer set.
But then if I login it correctly redirects me to a user logged in page and echos the username of the user logged in correctly, but still does not show the form token session variable in the var_dump for index(1). But then if I navigate to the login form page where the form token should be initially set, it now sets it correctly and going to the index page indeed shows the token set.

form token being set on login view page:

Code: [Select]
$login_token = $_SESSION['login_token'] = md5(uniqid(mt_rand(),true));
var_dump on index page before login (even if I navigate to login page then back to index it remains blank when it should instead show the form token session variable)
Code: [Select]
array
  empty
var_dump on index page after login.
Code: [Select]
array
  'lu_user' => string 'admin' (length=5)
  'lu_user_id' => string '6' (length=1)
  'user_sess_time' => int 1326544148

var_dump on index page after login, navigating to login form page (where login_token is set), then navigating back to index:

Code: [Select]
array
  'lu_user' => string 'admin' (length=5)
  'lu_user_id' => string '6' (length=1)
  'user_sess_time' => int 1326544148
  'login_token' => string 'c260e76dd65f0d9b6e881cfc9a4b33e1' (length=32)
Magically the login_token now shows, but only after logging in and setting the other variables. It seems it's not saving the login_token when it's initially set, but only after logging in which it shouldn't be doing.

The same issue arises with any other session variables that I set elsewhere (only displayed after user login).

If I remove session_set_handler the sessions set correctly but naturally the data is no longer added to the database.

If I do var_dump(get_included_files()); it shows the session class is correctly being included.
I was thinking it's an issue with session_start() but if I add that in or try to create another instance of the session class on the other pages, I get an error stating they've already been called and cannot be called again. So then they must be getting called, right?

So now I'm thoroughly confused. More code below, sorry for the long post. Hopefully I've provided all necessary information.

Index includes global.php, which contains:

Code: [Select]
require 'framework/SessionHandler.php';

$sess = new SessionHandler();

And the session handler class is (Database class is included into index which is why you cannot see it instantiated here):

Code: [Select]
<?php

class SessionHandler
{
function __construct()
{
session_set_save_handler
(
array(&$this, 'open'),
array(&$this, 'close'),
array(&$this, 'read'),
array(&$this, 'write'),
array(&$this, 'destroy'),
array(&$this, 'gc')
);

session_start();

ini_set('session.gc-maxlifetime', 1800);

if (isset($_SESSION['lu_user']))
{
if (!isset($_SESSION['user_sess_time']))
{
$_SESSION['user_sess_time'] = time();
}
elseif (time() - $_SESSION['user_sess_time'] > 1800) // 30 mins
{
    session_regenerate_id(TRUE);
    $_SESSION['user_sess_time'] = time();
}
}
}

function open()
{
$this->db = new Database();
}

function close()
{
return $this->db = null;
}

function read($id)
{
$stmt = $this->db->prepare('SELECT * FROM sessions WHERE id = :id');
$stmt->execute(array(':id' => $id));

if ($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
return $data = $row['data'];
}
else
{
return '';
}
}

function write($id, $data)
{
$access = time();

if (isset($_SESSION['lu_user']))
{
$session_id = session_id();
$username = $_SESSION['lu_user'];

$stmt = $this->db->prepare('REPLACE INTO sessions (id, access, data) VALUES (:id, :access, :data)');
$stmt->execute(array(':id' => $id, ':access' => $access, ':data' => $data));
}
}

function destroy($id)
{
if (ini_get("session.use_cookies"))
{
     $params = session_get_cookie_params();
     setcookie(session_name(), '', time() - 42000,
         $params["path"], $params["domain"],
         $params["secure"], $params["httponly"]);
}

$stmt = $this->db->prepare('DELETE FROM sessions WHERE id = :id');
$stmt->execute(array(':id' => $id));
}

function gc($max)
{
$old = time() - $max;

$stmt = $this->db->prepare('DELETE FROM sessions WHERE access < :old');
$stmt->execute(array(':old' => $old));
}

function __destruct()
{
session_write_close();
}
}

Hey guys, I'm new here so please be gentle with me!

I have this php command referencing my postgresql db at present:

'Select'=>$this->MyTable->GetAllSQLSelectFieldNames(array('perc'=>'((firstnumber)::float)/((secondnumber)::float) as perc')),

It is possible for firstnumber to be greater than secondnumber, but I'd like to limit the array output to 1 - ie to represent that firstnumber is greater than or equal to secondnumber without ever returning a number greater than 1.

Can anyone point me in the right direction for this please?

Hi,  Trying PostgreSQL  for the first time but not making much progress.  Get peer failure when not including a host and Ident error when including a host. Never heard of Ident authentication until today and don't know for sure if I even have such a server running.  Using Centos7, PHP7.4 using remi's repo, and PostgreSQL 12 from their repo.  Any thoughts?  Thanks

 

try {
    //use Unix domain sockets
    $dbh = new PDO("pgsql:dbname=postgres", 'postgres', 'secret');
}
catch(Exception $e){
    echo($e->getMessage().PHP_EOL);
}
try {
    $dbh = new PDO("pgsql:host=localhost;dbname=postgres", 'postgres', 'secret');
}
catch(Exception $e){
    echo($e->getMessage().PHP_EOL);
}
try {
    $dbh = new PDO("pgsql:host=127.0.0.1;dbname=postgres", 'postgres', 'secret');
}
catch(Exception $e){
    echo($e->getMessage().PHP_EOL);
}

 

SQLSTATE[08006] [7] FATAL:  Peer authentication failed for user "postgres"
SQLSTATE[08006] [7] FATAL:  Ident authentication failed for user "postgres"
SQLSTATE[08006] [7] FATAL:  Ident authentication failed for user "postgres"

 

Hey again, was making a registration form with php and postgresql and  im stuck at making a 'log out' button, i need to make something simple like - press on a link, it redirects u to the index page and if u try to go 'back' it wouldn't let u..

I found something on google like this:

<a href="test.php?logout=1">Log out</a>


and on test.php:

<?php
if(isset($_GET['logout'])){
session_unset;
session_destroy;
}
?>
Succesfully logged out, go back to index page: <a href="index.php">Home</a>


but i didnt use any sessions at all.. is there something like 'session_destroy' with postgre? i mean smth like 'pg_desroy'?

The following returns strings instead of floats.  Am I able to retrieve floats directly from PDO and/or PostgreSQL or must I manually type cast them afterwards using PHP?  Thanks

$sql='WITH RECURSIVE t AS (bla bla bla) SELECT id, CAST(SUM(slope*value+intercept) AS FLOAT) "value", SUM(slope*prev_value+intercept)::FLOAT "prevValue" FROM t WHERE type=\'physical\' GROUP BY id';
$stmt = $this->pdo->prepare($sql);
$stmt->execute($ids);
$arr = $stmt->fetchAll(\PDO::FETCH_UNIQUE); //returns [123=>['value'=>'123.456', 'prevValue'=>'122.234'], ...]