PHP Classes

Simple PHP MySQLi: Access MySQL database wrapper using MySQLi

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 61%Total: 2,489 This week: 1All time: 1,548 This week: 42Up
Version License PHP version Categories
simple-php-mysqli 2.0.21GNU General Publi...5.0PHP 5, Databases
Description 

Author

This class can Access MySQL database wrapper using MySQLi. It can:

- Connect to a given MySQL server
- Execute arbitrary SQL queries
- Retrieve the number of query result rows, result columns and last inserted table identifier
- Retrieve the query results in a single array
- Escape a single string or an array of literal text values to use in queries
- Determine if one value or an array of values contain common MySQL function calls
- Check of a table exists
- Check of a given table record exists
- Return a query result that has just one row
- Execute INSERT, UPDATE and DELETE queries from values that define tables, field names, field values and conditions
- Truncate a table
- Send email messages with MySQL access errors

Picture of Bennett Stone
Name: Bennett Stone <contact>
Classes: 3 packages by
Country: United States United States

Details

SimpleMysqli ============= PHP class to access MySQL database wrapper using MySQLi This class can: - Connect to a given MySQL server - Execute arbitrary SQL queries - Retrieve the number of query result rows, result columns and last inserted table identifier - Retrieve the query results in a single array - Escape a single string or an array of literal text values to use in queries - Determine if one value or an array of values contain common MySQL function calls - Check of a table exists - Check of a given table record exists - Return a query result that has just one row - Execute INSERT, UPDATE and DELETE queries from values that define tables, field names, field values and conditions - Truncate a table - Send email messages with MySQL access and query errors - Display the total number of queries performed during all instances of the class Full usage examples are provided in example.php, using example data provided in example-data.sql

  Files folder image Files (4)  
File Role Description
Plain text file class.db.php Class core class
Accessible without login Plain text file example-data.sql Data Example SQL table and contents
Accessible without login Plain text file example.php Example Example usage file
Accessible without login Plain text file README.md Data Auxiliary data

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:2,489
This week:1
All time:1,548
This week:42Up
User Ratings User Comments (2)
 All time
Utility:89%StarStarStarStarStar
Consistency:78%StarStarStarStar
Documentation:-
Examples:89%StarStarStarStarStar
Tests:-
Videos:-
Overall:61%StarStarStarStar
Rank:1060