PHP Classes

QuickDB: Query MySQL using values passed pragmatically

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 61%Total: 1,384 All time: 2,808 This week: 455Up
Version License PHP version Categories
quickdb 1.00GNU General Publi...5.0HTML, PHP 5, Databases
Description 

Author

Sarfraz Ahmed

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: 40
All time rank: 5626 in Pakistan Pakistan
Week rank: 195 Up3 in Pakistan Pakistan Up

Details


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 (3)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadquickdb-2009-05-18.zip 6KB
Downloadquickdb-2009-05-18.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,384
This week:0
All time:2,808
This week:455Up
User Ratings User Comments (2)
 All time
Utility:80%StarStarStarStarStar
Consistency:80%StarStarStarStarStar
Documentation:63%StarStarStarStar
Examples:72%StarStarStarStar
Tests:-
Videos:-
Overall:61%StarStarStarStar
Rank:985
 
.
14 years ago (Luigi)		67%StarStarStarStar
This a good class !! But why you dont use DB package (PEAR) ...
15 years ago (José Filipe Lopes Santos)		62%StarStarStarStar
 

  Applications that use this package  
Affinity Dating Application

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


  Pages that reference this package  
When working on different projects, you have to use time-consuming mysql commands every now and then...

Latest pages that reference packages Latest pages that reference packages