Skip to content

marcus-at-localhost/simple-mysqli

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

PHP class to access MySQL database wrapper using MySQLi

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 100.0%