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: 229 All time: 8,048 This week: 313Up
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: 46 packages by
Country: Pakistan Pakistan
Age: 19
All time rank: 95111 in Pakistan Pakistan
Week rank: 56 Up3 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 4x

 

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:229
This week:0
All time:8,048
This week:313Up

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