PHP Classes

PHP Database Adapter class: Perform SQL database access operations using PDO

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 43%Total: 687 All time: 4,746 This week: 455Up
Version License PHP version Categories
database-adapter 1.0Free For Educatio...5.2PHP 5, Databases
Description 

Author

This class can perform SQL database access operations using PDO.

It provides a general interface to access SQL databases using the PDO extension.

The class can establish connections, execute SQL queries composed using parameters, and retrieve results into arrays.

Picture of satyam kumawat
  Performance   Level  
Name: satyam kumawat <contact>
Classes: 1 package by
Country: India India

Details

Version : 1.0 Author : Satyam Kumawat <satyam2707@gmail.com> =================================================== This program is free package This program is distributed in the hope that it will be useful, This package is based on PHP AND PDO (PHP DATA OBJECT) Please Send your suggestion and feedback at satyam2707@gmail.com ======================= GENERAL INTRUCTIONS ======================= There are three files in this package. 1. DbAdapter.php (class contain all the functions for database operations) 2. DbAdapterInterface.php (Interface having function which should be defined in DbAdapter class. All the function are commented for better understanding) 3. demo.php (It is a demo file which which illustrate how to use this adaptor) Below are the steps which supposed to be followed for better understanding. --------------------------------------------------------------------------- 1. Include Adaptor Class : <?php require_once 'DbAdapter.php';?> 2. Creating Adaptor Object : <?php $connection = array ('dsn' =>'mysql:dbname=databasename;host=localhost', 'username' => 'root', 'password' => '', ); $dbObj = new DbAdapter($connection); ?> 3. Perform Your First Query : <?php //for single row $dbObj->select(array(*)) ->from($table) ->fetch(); //for All row $dbObj->select(array(*)) ->from($table) ->fetchAll(); ?> 4. Please follow demo.php file for all posible operations.

  Files folder image Files (4)  
File Role Description
Accessible without login Plain text file Readme.txt Doc. Documentation File
Accessible without login Plain text file demo.php Example example script
Plain text file DbAdapterInterface.php Class Interface of adaptor
Plain text file DbAdapter.php Class Adaptor file

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:687
This week:0
All time:4,746
This week:455Up
User Ratings User Comments (1)
 All time
Utility:55%StarStarStar
Consistency:50%StarStarStar
Documentation:55%StarStarStar
Examples:55%StarStarStar
Tests:-
Videos:-
Overall:43%StarStarStar
Rank:3572