PHP Classes

File: readme.md

Recommend this page to a friend!
  Classes of Muhammad Umer Farooq   PHP MySQL Manipulation Class   readme.md   Download  
File: readme.md
Role: Documentation
Content type: text/markdown
Description: Documentation
Class: PHP MySQL Manipulation Class
Compose and execute MySQL queries using PDO
Author: By
Last change: update
Date: 6 years ago
Size: 748 bytes
 

Contents

Class file image Download

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