PHP Classes

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,634 All time: 1,449 This week: 222Up
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: 119567 in India India
Week rank: 941 Up75 in India India Down

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 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,634
This week:0
All time:1,449
This week:222Up
User Ratings User Comments (2)
 All time
Utility:33%StarStar
Consistency:66%StarStarStarStar
Documentation:50%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:28%StarStar
Rank:3331
 
I didn't see a method to connect to the database.
2 years ago (David Domingues)
40%StarStarStar
The mysql_connect, _query, etc.
9 years ago (AccountKiller)
22%StarStar
 
For more information send a message to info at phpclasses dot org.