Skip to content

Latest commit

 

History

History
89 lines (62 loc) · 5.68 KB

File metadata and controls

89 lines (62 loc) · 5.68 KB

Behance Facebook LinkedIn Pinterest

💻 full-Stack:

PHP JavaScript CSS3 Apache Groovy AssemblyScript Nodemon NodeJS FastAPI Xamarin Apache Apache Airflow MySQL MariaDB SQLite Sequelize Adobe Adobe Illustrator GitHub Git

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:-

PDO Configuration

Installation


Installation: composer require pdo/connecter

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

BuyMeACoffee