PHP DAL: Simplify the access databases using PDO

Recommend this page to a friend!
  Info   View files Documentation   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2020-05-03 (2 months ago) RSS 2.0 feedNot enough user ratingsTotal: 153 All time: 8,793 This week: 226Up
Version License PHP version Categories
dal 1.0.1The PHP License5HTML, PHP 5, Databases
Description Author

This class can simplify the access databases using PDO.

It can connect to a given database supported by the PDO extension taking an array of parameters that define the connection details.

The class can also perform several types of common actions to access the connected database like:

- Execute queries
- Call stored procedures
- Get the list of tables in a database
- Check if a table exists
- Get the table fields
- Insert records in to a table
- Update records of a table
- Delete records of a table
- List and edit records of a table in a HTML page

Picture of mhmd jawad
  Performance   Level  
Name: mhmd jawad <contact>
Classes: 1 package by
Country: Lebanon Lebanon
Age: ???
All time rank: 41495 in Lebanon Lebanon
Week rank: 588 Up2 in Lebanon Lebanon Up

Details

PHP DAL

This class can simplify the access databases using PDO.

It can connect to a given database supported by the PDO extension taking an array of parameters that define the connection details.

The class can also perform several types of common actions to access the connected database like:

  • Execute queries
  • Call stored procedures
  • Get the list of tables in a database
  • Check if a table exists
  • Get the table fields
  • Insert records in to a table
  • Update records of a table
  • Delete records of a table
  • List and edit records of a table in a HTML page

Latest Updates

criteriaUpdate

perform update with multiple criteria for where clause

criteriaDelete

perform delete with multiple criteria for where clause

Class Methods

getDefaultConnection

contains the default configuration for connection connection parameters are: host, database, user, and password

getConnection

@param $DBOCFG [database configuration] will perform a PDO connection using the configuration provided usefull when want to use custom connection other than the default database.

call_sp

@param $q string value of the query @param $p [default empty array] parameters for the prepared statement $p follow the following rule each entry is of the form ["k"=>"value","v"=>"value"] where k is for the key in the query and v is for the value to attach @param $c for connection (null to use the default connection)

execute_query

@param $q string value of the query @param $p [default empty array] parameters for the prepared statement $p follow the following rule each entry is of the form ["k"=>"value","v"=>"value"] where k is for the key in the query and v is for the value to attach @param $c for connection (null to use the default connection)

> call_sp is for when calling a stored procedure or using select query (expecting array result) > execute_query for when performing update/insert/delete or DDL queries (create, drop, ...)

getTables

>documentation todo

table_exist

>documentation todo

TableFields

>documentation todo

insert

>documentation todo

update

>documentation todo

criteriaUpdate

>documentation todo

delete

>documentation todo

criteriaDelete

>documentation todo

genViewTable

>documentation todo

getEditTable

>documentation todo

getFormForTable

>documentation todo

getViewQuery

>documentation todo

getDALT

>documentation todo

class DALT

>documentation todo

function p

print on screen in user-readable format for objects and arrays

README

AUTHOR MhmdJawadZD README Last edit By MHMD JAWAD ZD 2020/05/03

  Files folder image Files  
File Role Description
Plain text file DAL.php Class DataAccessLayer
Accessible without login Plain text file ReadMe.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:153
This week:0
All time:8,793
This week:226Up

For more information send a message to info at phpclasses dot org.