README

💻 full-Stack:

Connecting to MySQL in PHP using PDO with Session Manager

PDO is a database access layer that provides a fast and consistent interface for accessing and managing databases in PHP applications. Every DBMS has a specific PDO driver that must be installed when you are using PDO in PHP applications. -: I'm highly experienced in large-size web portals:-

Old version PHP error

Tips: If you use an old PHP version like 7 or 8, edit your PHP version in composer.json and composer.lock and enter the command "composer dump-autoload -o".

PDO Configuration

Installation

▶️ composer require pdo/secure-connector

Important: if you're installing from the composer you have to modify the ENV file path it will

function : name _CreateVars()
Location : vendor\pdo\connecter\src\helper.php
Line Number: 56
Modify : self::$Path = "/.env"; | to -> self::$Path = "vendor/pdo/connecter/src/.env";

and if you're cloning the GitHub repository and use the same structure, Please share your feedback

require_once("vendor/autoload.php");
use Src\Connect_me;

 -- How to use it --
$db = new Connect_me();
$qry = $db->conn->prepare("SELECT * FROM `tablename` WHERE 1");
$qry->execute();
$row = $qry->fetch(PDO::FETCH_OBJ);
echo $row->user_code;

Secure Session Package

If you're on a shared host and use sessions for storing sensitive data, it's a good idea to store session files in your custom location and encrypt them.

Installation

require_once("vendor/autoload.php");
use Src\create_session;
-------------------------
 And use it
$session->set('name', 'John');

Configuration

💰 You can help me by Donating