pdo/secure-connector

Secure PDO Connection plugin for custom websites

1.0.0 2024-08-23 15:53 UTC

Requires

• php: ^8.1

MIT

• Irfan Ghuorio

• framework
• php
• pdo
• website
• PDO connecter

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

Method	OOP Code Script
Basic Usage	$session = new Session($prefix);
Second way	$session->prefix('test_')->set('name', 'Irfan'); it will set the session as "test_name"
Get the session prefix	$sesssion->getPrefix(); will return the session prefix
Get all session keys	$sesssion->all();
Add new session	$session->set($key, $value);
Session by Chaining method	$session->set('name', 'Irfan')->set('age', 19)->set('city', 'Baghdad');
session by providing an array	$session->set(['name' => 'Irfan', 'location' => [ 'country' => 'iraq' ]]);
Get one session by key	$sesssion->get($key); // will use the default prefix
Get All Session by specific prefix	$session->fromPrefix('test'); Returns an array of all sessions that have a "test" prefix
Check if the session exists	Session::has($key);
Remove Session by key	$sesssion->remove($key);
by chaining method	$session->remove('name')->remove('age')->remove('location');
by providing an array of keys	$session->remove(['name', 'age', 'location']);
or just like this	$session->remove('name', 'age', 'location');
Get the session id	$sesssion->id(); will return the id of the session.
Regenerate the session id	$sesssion->regenerate_id(); will return the id of the session.
Remove all session at one	$session->destroy();

💰 You can help me by Donating