MySQLi Complete Class: Perform SQL queries from parameters using MySQLi

MySQLi CLASS

------------------------------------------------------------------------------------------------------------------------
Example Table:

CREATE TABLE `_Users` (
	`UserID` INT(11) NOT NULL AUTO_INCREMENT,
	`UserName` VARCHAR(100) NULL DEFAULT NULL,
	`UserMail` VARCHAR(180) NULL DEFAULT NULL,
	PRIMARY KEY (`UserID`)
)
ENGINE=innoDB
;
INSERT INTO `_Users` (`UserName`, `UserMail`) VALUES ('User 01 Name', 'user1@industriavirtual.com.br');
INSERT INTO `_Users` (`UserName`, `UserMail`) VALUES ('User 02 Name', 'user2@industriavirtual.com.br');
INSERT INTO `_Users` (`UserName`, `UserMail`) VALUES ('User 03 Name', 'user3@industriavirtual.com.br');

------------------------------------------------------------------------------------------------------------------------

HOW TO USE (in your PHP code):

1) Define Database Connection:

define("DBHOST", "host");
define("DBUSER", "user");
define("DBPASS", "password");
define("DBNAME", "database");

------------------------------------------------------------------------------------------------------------------------

2) Include Class File:

require_once("mysqli.php");

------------------------------------------------------------------------------------------------------------------------

3) Open Connection:

$db = new dbConn();

------------------------------------------------------------------------------------------------------------------------

3) Record Select Example:

    if ($r = $db->select("UserID, UserName, UserMail", "_Users", "where UserID=1")) { 
        echo $r["UserMail"] . "<br />";
    } else {
        echo "- No Record Found!<br />";
    }
    unset($r);

------------------------------------------------------------------------------------------------------------------------

3) Close Connection:

$db->close();

------------------------------------------------------------------------------------------------------------------------

NOTE: Optional Connection With Other Database:

$db = new dbConn("host", "user", "password", "database");

------------------------------------------------------------------------------------------------------------------------

OTHER INCLUDED FUNCTIONS:

A) Select Group of Records Example:

    $d = $db->selectGroup("*", "_Users", "LIMIT 10");

        while($r = $d->fetch_assoc() ) {
            echo $r["UserMail"] . "<br />";
        }

    $d->close();

------------------------------------------------------------------------------------------------------------------------

B) Insert Example:

    $t = array();
    $t["UserName"] = "Industria Virtual 1";
    $t["UserMail"] = "email1@industriavirtual.com.br";

    $db->insert("_Users", $t)

------------------------------------------------------------------------------------------------------------------------

C) Update Example:

    $t = array();
    $t["UserName"] = "Industria Virtual 2";
    $t["UserMail"] = "email2@industriavirtual.com.br";

    $db->update("_Users", $t, "WHERE UserID=1")

------------------------------------------------------------------------------------------------------------------------

D) Delete Example:

    $db->delete("_Users", "WHERE UserID=1")

------------------------------------------------------------------------------------------------------------------------

E) Free Query Execute:

    $a = $db->query("select * from _Users");
    foreach ($a as $b) {
        echo $b["UserMail"] . "<br />";
    }
    $a->close();

------------------------------------------------------------------------------------------------------------------------

BONUS:

I) List Tables in Database:

    $tables = $db->listTables();
    $arrlength = count($tables);
    for($x = 0; $x < $arrlength; $x++) {
        echo $tables[$x] . "<br />";
    }

------------------------------------------------------------------------------------------------------------------------

II) List Fields from Table:

    $fields = $db->listFields("_Users");
    $arrlength = count($fields);
    for($x = 0; $x < $arrlength; $x++) {
        echo "Field [" . $fields[$x]['name'] . "] - Type [" . $fields[$x]['type'] . " (" . $fields[$x]['code'] . ")] - Max Length [" . $fields[$x]['size'] . "]<br />";
    }

------------------------------------------------------------------------------------------------------------------------

Check file "example.php" for more information.

Contact: Marcelo Franco (codes@industriavirtual.com.br)