PHP Classes

File: readme.txt

Recommend this page to a friend!
  Classes of Marcelo Franco   MySQLi Complete Class   readme.txt   Download  
File: readme.txt
Role: Documentation
Content type: text/plain
Description: README file.
Class: MySQLi Complete Class
Perform SQL queries from parameters using MySQLi
Author: By
Last change: Minimum update.
Date: 7 years ago
Size: 4,576 bytes
 

Contents

Class file image Download
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)