PHP Classes

Simple PHP MySQLi: Access MySQL database wrapper using MySQLi

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (7)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2024-01-09 (2 months ago) RSS 2.0 feedStarStarStarStar 61%Total: 2,476 All time: 1,561 This week: 122Up
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
Age: 39
All time rank: 858115 in United States United States
Week rank: 314 Up41 in United States United States Up

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  
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

 Version Control Unique User Downloads Download Rankings  
 100%
Total:2,476
This week:0
All time:1,561
This week:122Up
User Ratings User Comments (2)
 All time
Utility:89%StarStarStarStarStar
Consistency:78%StarStarStarStar
Documentation:-
Examples:89%StarStarStarStarStar
Tests:-
Videos:-
Overall:61%StarStarStarStar
Rank:1043