PHP Classes

Simple PHP MySQLi: Access MySQL database wrapper using MySQLi

Recommend this page to a friend!

  Author Author  
Picture of Bennett Stone
Name: Bennett Stone <contact>
Classes: 3 packages by
Country: United States United States
Age: 38
All time rank: 866115 in United States United States
Week rank: 45 Up4 in United States United States Up


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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

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

  Classes of Bennett Stone  >  Simple PHP MySQLi  >  Download Download .zip .tar.gz  >  Support forum Support forum (7)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Simple PHP MySQLi
Base name: simple-php-mysqli
Description: Access MySQL database wrapper using MySQLi
Version: 2.0.18
PHP version: 5.0
License: GNU General Public License (GPL)
All time users: 2440 users
All time rank: 1589
Week users: 10 users
Week rank: 34 Up
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (95%) Good (80%) - Good (95%) - - Sufficient (65%) 825
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.

  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

Install with Composer Install with Composer - Download Download all files: simple-php-mysqli.tar.gz simple-php-mysqli.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
  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

Install with Composer Install with Composer - Download Download all files: simple-php-mysqli.tar.gz simple-php-mysqli.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.