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

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 28%Total: 2,591 This week: 1All time: 1,462 This week: 261Up
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.


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

Name: Dhruv Jain <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 120269 in India India
Week rank: 243 Up26 in India India Up

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

Dhruv Jain
  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  
This week:1
All time:1,462
This week:261Up
User Ratings User Comments (2)
 All time
I didn't see a method to connect to the database.
9 months ago (David Domingues)
The mysql_connect, _query, etc.
7 years ago (AccountKiller)

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