Login   Register  
PHP Classes
elePHPant
Icontem

PHP MySQL Wrapper Class: MySQL database access wrapper

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (12)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings  
2014-10-29 (27 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 592 This week: 8All time: 4,783 This week: 200Up
Version License PHP version Categories  
mysql-access-wrapper 1.17GNU General Public Lice...4.3Databases
Description Author  

This class implements a generic MySQL database access wrapper. It can:

- Connect to a given MySQL server
- Set the connection character set encoding
- Execute arbitrary queries and return the results in arrays
- Retrieve the columns of a table
- Execute UPDATE or INSERT queries from parameters that define the tables, fields, field values and conditions
- Execute multiple INSERT or UPDATE queries at once
- Count the number of rows of a table that match a given condition
- Get the next value of an auto-incremented table field
- Delete table rows that match a given condition
- Export, import, update table using CSV files
- Create table from CSV file
- Export query to CSV file
- Replace values in a given table for defined columns
- Rename, copy, truncate or drop table
- Get database size
- Log queries and errors with backtrace information

Picture of Radovan Janjic
Name: Radovan Janjic is available for providing paid consulting. Contact Radovan Janjic .
Classes: 14 packages by
Country: Serbia Serbia
Age: 26
All time rank: 4044 in Serbia Serbia
Week rank: 29 Up1 in Serbia Serbia Up
Innovation award
Innovation award
Nominee: 3x

  Files folder image Files  
File Role Description
Files folder imagetest_files (7 files)
Accessible without login Plain text file example.php Example Example script
Accessible without login Plain text file LICENSE Data Auxiliary data
Accessible without login Plain text file log-mysql.txt Output Log file
Plain text file MySQL_wrapper.class.php Class class
Accessible without login Plain text file README.md Data Auxiliary data

  Files folder image Files  /  test_files  
File Role Description
  Accessible without login Plain text file countrylist.csv Data Auxiliary data
  Accessible without login Plain text file countrylist1.csv Data Auxiliary data
  Accessible without login Plain text file test-1.txt Doc. Documentation
  Accessible without login Plain text file test-2.txt Doc. Documentation
  Accessible without login Plain text file test-3.txt Doc. Documentation
  Accessible without login Plain text file test-4.txt Doc. Documentation
  Accessible without login Plain text file test-query2csv.csv Data Auxiliary data

 Version Control Reuses Unique User Downloads Download Rankings  
 100%1Total:592All time:4,783
 This week:8This week:200Up