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: 236 This week: 1All time: 8,074 This week: 560Up
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: 52 packages by
Country: Pakistan Pakistan
Age: 22
All time rank: 84611 in Pakistan Pakistan
Week rank: 51 Up3 in Pakistan Pakistan Up
Innovation award
Innovation award
Nominee: 6x

Example

<?php

require_once 'classes/MYSQL.php';

$mysql = new MYSQL('localhost', 'root', '');

/* Creating tables */
//$mysql->CreateDb("PHP");

/* deleting database */
//$mysql->DeleteDb("PHP");

/* creating table */
/*$mysql->CreateTbl("PHP","CREATE TABLE users(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    first_name VARCHAR(30) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    email VARCHAR(70) NOT NULL UNIQUE
)");*/

/* deleting table */
//$mysql->DeleteTbl("PHP","users");

/* inserting records */
//$id = $mysql->Insert('users','PHP',['first_name'=>'Malik Uner','last_name'=> 'Farooq','email'=> 'lablnet01@gmail.com']);

/* updating database */
//$id = 1;
//$mysql->Update(['table'=>'users','db_name'=>'PHP','columns'=>['first_name' => 'Malik Umer'],'wheres'=>['id ='. 1]]);

/* selecting values */
$result = $mysql->Select(['table'=>'users', 'db_name'=>'PHP', 'wheres'=>['email ='.$mysql->Quote('lablnet01@gmail.com')]]);

print_r($result);

/* deleting the records */
//$mysql->Delete(['table'=>'users','db_name'=>'PHP','wheres'=>['id ='. 9]]);

/* Counting the records */
//echo $mysql->Count(['table'=>'users','db_name'=>'PHP','wheres'=>['id ='. 9]]);

//Close the connection its recommended to clsoe connection
$mysql->Close();


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:236
This week:1
All time:8,074
This week:560Up