dhtml/dhtmlsql

An ultra-modern, advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension.

DHTMLSQL

, _(*1)

What am I looking at?

You are looking at An advanced, compact and lightweight MySQL database wrapper library, built around PHP's mysqli extension. It provides methods for interacting with MySQL databases that are more powerful and intuitive than PHP’s default ones., _(*2)

Features

• It uses the mysqli extension for communicating with the database instead of the old mysql extension, which is officially deprecated as of PHP v5.5.0 and will be removed in the future; again, this is not a wrapper for the PDO extension which is already a wrapper in itself
• It offers lots of powerful methods for easier interaction with MySQL
• It provides a better security layer by encouraging the use of prepared statements, where parameters are automatically escaped.
• It has comprehensive documentation and examples of usage included
• It allows easy ways of backing up and restoring your database.

Installation and Usage

One of the main goals of DHTMLSQL is to be zero setup., _(*3)

Download the archive and simply, _(*4)

<?php
require 'dhtmlsql.php';

Or, if you use Composer:, _(*5)

"require": {
   "dhtml/dhtmlsql": "^1.0"
}

Or just run composer require dhtml/dhtmlsql, _(*6)

That's it, you can now use DHTMLSQL to run your queries:, _(*7)

Requirements

PHP 5+ with the mysqli extension activated, MySQL 4.1.22+, _(*8)

How to use

Connect to a database, _(*9)

<?php
require "library/dhtmlsql.php";

// Connection data (server_address, name, password,  database)
$db=DHTMLSQL::connect('localhost','admin','pass','dbtest');
?>

A SELECT statement, _(*10)

select(
    'column1, column2',
    'table',
    'criteria = ?',
    array($criteria)
);

// after this, one of the "fetch" methods can be run:

// to fetch all records to one associative array
$records = $db->fetch_assoc_all();

// or fetch records one by one, as associative arrays
while ($row = $db->fetch_assoc()) {
    // do stuff
}
?>

An INSERT statement, _(*11)

insert(
    'table',
    array(
        'column1' => $value1,
        'column2' => $value2,
    )
);
?>

An UPDATE statement, _(*12)

update(
    'table',
    array(
        'column1' => $value1,
        'column2' => $value2,
    ),
    'criteria = ?',
    array($criteria)
);

?>

Support

Visit the project page for documentation, configuration, and more advanced usage examples., _(*13)

You can also read the complete API documentation here or even discuss it here., _(*14)

Author

Anthony Ogundipe a.k.a dhtml, _(*15)

Special thanks to Marcellinus Okeke and Oyebanji Jacob Mayowa for their contributions to this library., _(*16)

License

Licensed under the MIT License, _(*17)