pdo_connecting_database's Introduction

Connecting to MySQL in PHP using PDO

Connecting to MySQL with PDO. it easy for you and secure for your company project

Installation

You have to edit "connect_me.php" Path: "app/config/connect_me.php"

/*** MYSQL HOSTNAME ***/
protected $db_host = "localhost"; // Put your Host name here...

/*** MYSQL DATABANSE NAME  ***/
protected $db_name = "test"; // Put your Database name here...

/*** MYSQL USERNAME ***/
protected $db_user = "irfanahmed";  // Put your MYSQL Username here

/*** MYSQL PASSWORD ***/
protected $db_pass = "***mikmikmik***";  // Put Your MYSQL Password here

require or include in your project page, where you need to connect your database.r.

define('ACCESS_ALLOW',true);
require('app/config/connect_me.php');

You can change define the text "ACCESS ALLOW" as you want. if you what to change the text. Search file path: "app/config/connect_me.php" in this file, you can change "defined('ACCESS_ALLOW')"

private static function Block_Access()
{ return (!defined('ACCESS_ALLOW')) ? true : false;  }

When you have changed it. !defined('ACCESS_ALLOW') to !defined('Something') you'll use with changes:

define('something',true);
require('app/config/connect_me.php');

it just block direct access file

How to use it

Create a class Object:

$pdo = new connect_me();

Database resource:

$this->conn   //Database handler queries
$q = $pdo->conn->prepare("SELECT * FROM `user`");    /** Example of query */

Basic Example

define('ACCESS_ALLOW',true);
require('app/config/connect_me.php');
    
$pdo = new connect_me();
$q = $pdo->conn->prepare("SELECT * FROM `user`");
$q->execute();
while($row = $q->fetch(PDO::FETCH_OBJ))
{
echo $row->user_name."<br>";
}