Tuesday, February 2, 2016

Make Mysql Database Connection using PDO || Very Easy to learn

1.Config.php
<?php
     
        error_reporting(E_ALL);
        try
        {
 $pdo = new PDO('mysql:host='. DB_HOST .';dbname='.$selected_db, DB_USER, DB_PASSWORD);  // with db connect
             $db = new PDO( "mysql:host=localhost", 'root', '' ); without DB.. just an open  connection
        }
        catch (PDOException $e)
        {
            $db='Error: '.$e->getMessage();
            die($db);
        }
        return $db;
?>



2. logic.php
 
   <?php
       $db = include_once('config.php');
        try{
         
         $q_object = $db->query("select password('my_hash_password') as m_password");
     
         $get_data = $q_object->fetch(PDO::FETCH_ASSOC);
         echo '<pre>';
         print_r($get_data);
      }
      catch(PDOException $e){
          echo 'Some Error Found<br />'.$e->getMessage();
          die();
      }

No comments:

Post a Comment