From 5d19d133d1ae140507e0cf3f5872b95e6e87480a Mon Sep 17 00:00:00 2001
From: Jean-Marc Pigeon <jmp@safe.c>
Date: Wed, 3 Sep 2025 20:35:44 -0400
Subject: [PATCH] Able to store cookies within database

---
 www/devsql.php | 10 ++++++++--
 www/gessql.php |  7 ++++++-
 www/home.php   |  1 -
 3 files changed, 14 insertions(+), 4 deletions(-)

diff --git a/www/devsql.php b/www/devsql.php
index be9e5f6..a73995f 100644
--- a/www/devsql.php
+++ b/www/devsql.php
@@ -25,11 +25,17 @@ class devsql     {
     }
 
   // Insert a row/s in a Database Table
-  public function Insert() {
+  public function Insert($statement="" ,$parameters=[]) {
+    try {
+      $stmt=$this->connection->prepare($statement);
+      return $stmt->execute($parameters);
+    } catch(Exception $e) {
+      throw new Exception($e->getMessage());
+      }
     }	
 
   // Select a row/s in a Database Table
-  public function Select($statement = "",$parameters = []) {
+  public function Select($statement="",$parameters=[]) {
     try {
       return $this->executeStatement($statement,$parameters);
     } catch(Exception $e) {
diff --git a/www/gessql.php b/www/gessql.php
index afedc9c..74de8bb 100644
--- a/www/gessql.php
+++ b/www/gessql.php
@@ -46,7 +46,12 @@ while ($proceed==true) {
     case 4      :       //everything fine
       $random=(string)rand(0,9999999); 
       $uniqid=uniqid("",true);
-      setcookie(getenv("APPNAME"),"$random$uniqid",time()+(24*3600),"/");
+      $delay=time()+(24*3600);
+      $limit=date("Y-m-d H:i:s",$delay);
+      setcookie(getenv("APPNAME"),"$random$uniqid",$delay,"/");
+      $fields="cookuuid,email,expire";
+      $values="'$random$uniqid','$logname','$limit'";
+      $dbsql->Insert("Insert into cookies ($fields) values ($values)");
       $isgood=true;
       break;
     default     :       //SAFE Guard
diff --git a/www/home.php b/www/home.php
index 9ac1def..9196aaa 100644
--- a/www/home.php
+++ b/www/home.php
@@ -54,7 +54,6 @@ if ($_SERVER["REQUEST_METHOD"] == "POST") {
       echo "</script>";
       break;
     default     :
-      setcookie("ABC","myuuid",time()+(86400*1),"/");
       header('Location: mailleur.php');
       break;
     }
-- 
2.47.3