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: 235 All time: 8,057 This week: 171Up
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: 51 packages by
Country: Pakistan Pakistan
Age: 21
All time rank: 86711 in Pakistan Pakistan
Week rank: 247 Up7 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 5x

Details

PHP MYSQL Manipulation Class

PHP MYSQL Manipulation Class

Feature

- 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

<?php
//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.
$mysql->Close();

to-do

- 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 readme.md 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  
 100%
Total:235
This week:0
All time:8,057
This week:171Up