DownloadPHP 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
|