PHP Singleton Database Class PDO: Connect to many types of database using PDO

Recommend this page to a friend!

Download .zip

Info

Example

View files (4)

Download .zip

Reputation

Support forum (1)

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 156		All time: 8,985 This week: 171

Version		License		PHP version		Categories
`singletondbconnect` 1.0.0		MIT/X Consortium ...		5		PHP 5, Databases, Language

Description

Author

adam berger

This class can connect to many types of database using PDO.

It works as a singleton, so when a new object of the class is created multiple times, it returns the same object created in the first time a new class object was created.

The class provides different functions to setup connections to different types of SQL databases. Currently it supports databases like SQLite, MySQL, Microsoft SQL Server and PostgreSQL .

adam berger

Performance

Level

Name:	adam berger `<contact>`
Classes:	23 packages by adam berger
Country:	Poland
Age:	???
All time rank:	747	21 in Poland
Week rank:	189	4 in Poland

Level 5

Innovation award

Nominee: 8x

Winner: 2x

Example


<?php

        require 'SingletonDB.php';



         try {

            

           // $singletonDB = SingletonDB::getInstance()->connectMysql();

       // $singletonDB = SingletonDB::getInstance()->connectMicrosoftSqlServer();

           // $singletonDB = SingletonDB::getInstance()->connectPostgreSql();

         

           $singletonDB = SingletonDB::getInstance()->connectSQLite();

          $query  = "SELECT `nameUser` FROM `testwielki`";

         // $result = $singletonDB->prepare($query);

          $result = $singletonDB->query($query);

          $result->execute();

          $as = $result->fetchAll();

                  print_r($as);

             echo count($result->fetchAll());

             

       if($result->rowCount() > 0){

          $as = $result->fetchAll();

                print_r($as);

         $result->closeCursor();

           }    

         } catch (Exception $ex) {

              $mesage1  = " ";

         echo $mesage1 .= $ex->getTraceAsString()

                .$ex->getMessage().'<br />'

                .$ex->getCode().'<br />'

                .$ex->getFile().'<br />'

                .$ex->getLine().'<br />'

                .$ex->getPrevious();

         } catch(PDOException $ep){

                  $mesage1  = " ";

             echo $mesage1 .= $ep->getTraceAsString()

                .$ep->getMessage().'<br />'

                .$ep->getCode().'<br />'

                .$ep->getFile().'<br />'

                .$ep->getLine().'<br />'

                .$ep->getPrevious();

             }