PHP Classes
elePHPant
Icontem

class.database: Build and execute MySQL database queries

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 (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-05-13 (10 years ago) RSS 2.0 feedStarStar 37%Total: 2,065 All time: 1,809 This week: 1,204Up
Version License Categories  
class_database_php 1.0GNU General Publi...Databases
Description Author  

This class can build and execute MySQL database queries

It provides a function named db_sknife (short name for database swiss knife) that can build repetitive select queries from a few parameters. It can also establish a database connection, execute the queries, and return the result values.

Picture of Suneel Kanuri
Name: Suneel Kanuri <contact>
Classes: 1 package by
Country: India India
Age: 34
All time rank: 136074 in India India
Week rank: 1471 Down111 in India India Down

Details provided by the author  
Introduction to class.database.php

Thanks for having a peek at my class. I have been using this class for a long time 
even before i started using PEAR::DB, and now in conjunction with PEAR::DB.

It's capabilities to handle mundane tasks such as establishing a database connection, executing 
a query and committing the query would help RAD developers extensively without getting to do it
over again for each site they deploy. All it expects is a database name, username and password.
In addition you can specify them or default them inside the class too.  

In addition it goes a step ahead and makes the process of making fairly complex queries involving
multiple parameters comparision and grouping as a function call. With proper understanding of the
needed parameters one can easily make a query without even writing  a SQL query.

The package consists of:

	- class.database.php - the core database source file
	-  test.php which shows an example usage
	- finance.sql a sample SQL DDL Query which is needed to test the class
	
Now, if anybody has more questions or suggestions  regarding this class please email me at suneel.kanuri@gmail.com 
and i would try to help you with more examples and explanation of how to deploy it.

Cheers !!
Suneel Kanuri
http://jmanage.coolguide.net 
The Job Search Manager

  Files folder image Files  
File Role Description
Plain text file class.database.php Class Main Source File
Accessible without login Plain text file finance.sql Data Sample SQL file
Accessible without login Plain text file README.txt Doc. Little Explanation
Accessible without login Plain text file test.php Example Example File

 Version Control Unique User Downloads Download Rankings  
 0%Total:2,065All time:1,809
 This week:0This week:1,204Up
 User Ratings  
 
 All time
Utility:41%StarStarStar
Consistency:58%StarStarStar
Documentation:58%StarStarStar
Examples:50%StarStarStar
Tests:-
Videos:-
Overall:37%StarStar
Rank:2299