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

Recommend this page to a friend!
  Info   View files (2)   Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
28%Total: 2,595 All time: 1,458 This week: 255
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.

Recommendations

How to find package ?
I'd like find package for accessing MySQL database.

Picture of Dhruv Jain
Name: Dhruv Jain <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 119869 in India India
Week rank: 762 61 in India India

Details
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  
File Role Description
dbclass.php Class The main class file
ReadMe.txt Doc. A Small Documentation

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,595
This week:0
All time:1,458
This week:255
User Ratings User Comments (2)
 All time
Utility:33%
Consistency:66%
Documentation:50%
Examples:-
Tests:-
Videos:-
Overall:28%
Rank:3320
 
I didn't see a method to connect to the database.
10 months ago (David Domingues)
40%
The mysql_connect, _query, etc.
8 years ago (AccountKiller)
22%
 

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