PHP Classes

QuickDB: Query MySQL using values passed pragmatically

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2009-05-18 (6 years ago) RSS 2.0 feedStarStarStarStar 64%Total: 1,355 All time: 2,732 This week: 1,173Up
Version License PHP version Categories  
quickdb 1.00GNU General Publi...5.0HTML, PHP 5, Databases
Description Author  

This class can be used to query MySQL using values passed pragmatically.

It can connect to a MySQL database and execute SELECT, INSERT, UPDATE and DELETE queries from arguments that define tables, fields, field values, conditions and order clauses.

The class can also display HTML tables with data from SELECT query results, count the rows of a table, insert or update a table record depending on whether the record that matches a condition already exists, and get information about the table.

Picture of Sarfraz Ahmed
Name: Sarfraz Ahmed <contact>
Classes: 3 packages by
Country: Pakistan Pakistan
Age: 31
All time rank: 6689 in Pakistan Pakistan
Week rank: 107 Up3 in Pakistan Pakistan Up

In order to use the example here, you need to create a table,
just execute the following SQL lines using your MySQL client:

CREATE TABLE `quickdbtest` (
  `catid` int(11) NOT NULL auto_increment,
  `catname` varchar(255) default NULL,
  PRIMARY KEY  (`catid`)

insert  into `quickdbtest`(`catid`,`catname`) values (1,'Big'),(2,'Small'),(3,'Average'),(4,'Light'),(5,'Huge');
  Files folder image Files  
File Role Description
Accessible without login Plain text file index.php Example example file
Accessible without login Plain text file quickdb.class.php Class main class file
Plain text file ReadMe.txt Doc. ReadMe file

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,355All time:2,732
 This week:0This week:1,173Up
User Ratings User Comments (2)  
 All time
5 years ago (Luigi)
This a good class !! But why you dont use DB package (PEAR) ...
6 years ago (Josť Filipe Lopes Santos)