PHP Classes
elePHPant
Icontem

A MySQL Database Class: Run MySQL queries defined from parameter values

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 (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2012-07-16 (2 years ago) RSS 2.0 feedNot enough user ratingsTotal: 2,226 This week: 5All time: 1,660 This week: 208Up
Version License PHP version Categories  
dhruv-mysql 1.0.0Artistic License4.0Databases
Description Author  

This class can run MySQL queries defined from parameter values.

It can connect to a MySQL database server and run SQL SELECT, INSERT UPDATE and DELETE queries composed using parameter values that define table names, field names and values, condition clauses and result limit ranges.

The class can also run queries to get the fields from a table, analyze, optimize, create, alter and drop tables.

Picture of Dhruv Jain
Name: Dhruv Jain <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 126770 in India India
Week rank: 251 Up24 in India India Up

Details provided by the author  
This class was developed by Dhruv Jain aka Hack Archives
You may use this freely unles this notice remains intact
Author Website: http://hackarchives.org

Script is commented for easy usage

Some examples here:

1.Running Queries
$query = $db->exec("YOUR QUERY HERE");

2.Selecting rows
$result = $db->select("*","users","username='dhruv'","LIMIT 10");

3.Show number of rows
$num = $db->num_rows($result);

4.Fetch Array
$fet = $db->fetch_array($result);

YOu can perform many Mysql functions using this class.All major functions have been included.Please read through comments for better usage


Regards,
Dhruv Jain
http://hackarchives.org
  Files folder image Files  
File Role Description
Plain text file dbclass.php Class The main class file
Accessible without login Plain text file ReadMe.txt Doc. A Small Documentation

 Version Control Unique User Downloads Download Rankings  
 0%Total:2,226All time:1,660
 This week:5This week:208Up
 User Comments (1)  
 
The mysql_connect, _query, etc.
2 years ago (Malte Dreyer)
22%StarStar