PHP

Now a days in PHP and Mysql connection after deprecation of Mysql, PDO [PHP Data Objects] and Mysqli is the best choice. In that PDO is widely used in new frameworks because it has more benefits than Mysql and Mysqli. Here is the list of features of PDO.

Have dirvers for 12 different databases [list them using print_r(PDO::getAvailableDrivers());]
OOP approach
Named parameters
Object mapping
Prepared statements
Fast performance
Stored procedures

Now here I am showing you the class of database connection that I used for my work. In that I use singleton pattern that eliminate the chances of having more than one instance of the class object in memory.

<?php

class database
{
    public $dbc;
    private static $instance;

    private function __construct()
    {
        $this -> dbhc= new PDO('mysql:host=localhost;dbname=example', "root", "");
    }

    //singleton pattern
    public static function getInstance()
    {
        if (!isset(self::$instance))
        {
            $object = __CLASS__;
            self::$instance = new $object;
        }
        return self::$instance;
    }
}

?>

You can use above class using following example code.


//get database connector by calling static method of database class [singleton pattern]
$db = database::getInstance();


        
//insert operation
$sql = "insert into `user` (`username`, `password`, `fullname`, `email`) values (:username, :password, :fullname, :email)";    //named parameters

$query = $db -> dbc -> prepare($sql);

$result = $query -> execute(array(":username" => $username, ":password" => $password, ":fullname" => $fullname, ":email" => $email));    //named parameters value
             
if($result)
    echo "Insert Successfull.";
else
    echo "Insert Fail."


        
//update operation
$sql = "update `user` set `username` = ?,  `password` = ?, `fullname` = ?, `email` = ? where `user_id` = ?";    //prepared statements

$query = $db -> dbc -> prepare($sql);

$result = $query -> execute(array($username, $password, $fullname, $email, $user_id));   //prepared statements value
        
if($result)
    echo "Update Successfull.";
else
    echo "Update Failed.";



//delete operation
$sql = "delete from `user` where `user_id` = ?";   //prepared statements

$query = $db -> dbc -> prepare($sql);

$result = $query -> execute(array($user_id));   //prepared statements value
        
if($result)
    echo "Delete Successfull.";
else
    echo "Delete Failed.";



//select operation
$sql = "select * from `user` where `user_id` = ?";   //prepared statements

$query = $db -> dbc -> prepare($sql);
        
$query -> execute(array($user_id));   //prepared statements value
        
$query -> setFetchMode(PDO::FETCH_ASSOC); // [PDO::FETCH_NUM for integer key value]
        
$result = $query -> fetchAll();

Download database class file here : https://www.mediafire.com/view/lmmlosnf26v5lla/db_config.php

References :

Many times in PHP, we need to delete the folder containing subfolders and files. So we have to check for depth and according to that we have to delete files first and then folders. But if we don’t know the content of it then it will be very difficult task to delete it. I am working on some stuff that need to be delete once it is utilized so I make the function that check for the subfolders and files and recursively delete the contents of it.

Here is the function for delete.

function delFolder($folder) 
{ 
	foreach(glob($folder . '/*') as $file) 
	{ 
		if(is_dir($file)) 
			delFolder($file); 
		else 
			unlink($file); 
	} 
	rmdir($folder); 
}

Here delFolder is the function that perform delete task.

Here we use following of the PHP function.

glob — Find pathnames matching a pattern
is_dir — Tells whether the filename is a directory
unlink — Deletes a file
rmdir — Removes directory

Download the full example with comments here : https://www.mediafire.com/view/winyqdt2fr1jsll/delFolder.php

A Computer Engineer

Just another geek.

PDO connection class in PHP [OOP approach with singleton pattern]

How to delete folder with contents in it in PHP