| Ratings | | Unique User Downloads | | Download Rankings |
| Not yet rated by the users | | Total: 235 | | All time: 8,057 This week: 171 |
|
| 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.
| |
 |
|
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
| |
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
Download .zip
Example
