PHP Classes

PHP MySQL Manipulation Class: Compose and execute MySQL queries using PDO

Recommend this page to a friend!
  Info   View files Example   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 230 All time: 8,075 This week: 194Up
Version License PHP version Categories
php-mysql-manipulati 1.0.0MIT/X Consortium ...5PHP 5, Databases
Description Author

This class can compose and execute MySQL queries using PDO.

It can establish a connection to a MySQL database server using the PDO extension.

The class can also compose and execute SQL queries of several types using given parameters, like SELECT, INSERT, UPDATE and DELETE.

Picture of Muhammad Umer Farooq
Name: Muhammad Umer Farooq is available for providing paid consulting. Contact Muhammad Umer Farooq .
Classes: 49 packages by
Country: Pakistan Pakistan
Age: 20
All time rank: 92411 in Pakistan Pakistan
Week rank: 40 Up3 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 5x


PHP MYSQL Manipulation Class

PHP MYSQL Manipulation Class


- Create database. - Delete database. - Create table. - Delete table. - Insert into table. - Update record in table. - Select data form table (Joins,Limits,OrderBy,Wheres debug). - Delete record in table. - Count record in table. - Quote string. - Provide method for close database connection

Simple example

//loading require file.
require_once 'classes/MYSQL.php';
open connection.
$mysql = new MYSQL("host","user",'pass');
//slecting records.
$result = $mysql->Select(['table'=>'table_name','db_name'=>'db_name']);
//closing connection.


- Updating tables - Creating table in efficient ways

  Files folder image Files  
File Role Description
Files folder imageclasses (1 file)
Accessible without login Plain text file index.php Example Example script
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file Doc. Documentation

  Files folder image Files  /  classes  
File Role Description
  Plain text file MYSQL.php Class Class source

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:8,075
This week:194Up
For more information send a message to info at phpclasses dot org.