IDatabase class: MySQL Database access wrapper using MySQLi

Recommend this page to a friend!
  Info   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 260 All time: 7,689 This week: 304Up
Version License PHP version Categories
idatabase-class 1.0GNU General Publi...5PHP 5, Databases
Description Author

This class is a MySQL Database access wrapper using MySQLi. It can:

- Connect to a MySQL server
- Get MySQL server statistics
- Execute a SELECT SQL query and return all the results into an array
- Execute SQL INSERT, UPDATE and DELETE queries given the SQL query
- Execute SQL INSERT or UPDATE queries given the table name, the list of field names and values
- Get the number of records in a table that match a given condition
- Get a single field or a single row of a table that matches a condition

Picture of Nemeth Zoltan
  Performance   Level  
Name: Nemeth Zoltan is available for providing paid consulting. Contact Nemeth Zoltan .
Classes: 8 packages by
Country: Hungary Hungary
Age: 43
All time rank: 162913 in Hungary Hungary
Week rank: 523 Up5 in Hungary Hungary Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

 

Details
URGENT!
 > First you need change the database access data in IDatabase.class.php line 14 to 17!

-- Sample MySQL table

CREATE TABLE IF NOT EXISTS `sample` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(255) NOT NULL,
  `counter` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

INSERT INTO `sample` (`id`, `date`, `name`, `counter`) VALUES
(1, '2014-03-06 15:45:11', 'test1', 0),
(2, '2014-03-06 15:45:16', 'test2', 0),
(3, '2014-03-06 15:45:21', 'tester1', 0),
(4, '2014-03-06 15:45:27', 'tester2', 0),
(5, '2014-03-06 15:45:34', 'tester3', 0);
  Files folder image Files  
File Role Description
Plain text file EException.class.php Class The exception class for IDatabase class
Plain text file IDatabase.class.php Class The base class file
Accessible without login Plain text file index.php Example Example script fro IDatabase class use
Accessible without login Plain text file readme.txt Doc. Sample table create script for example
Accessible without login Plain text file sample_output.txt Output Sample output

 Version Control Reuses Unique User Downloads Download Rankings  
 0%1
Total:260
This week:0
All time:7,689
This week:304Up

For more information send a message to info at phpclasses dot org.