PHP Classes
elePHPant
Icontem

MySQL Connector: MySQL database access wrapper

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  
2005-11-04 (9 years ago) RSS 2.0 feedNot enough user ratingsTotal: 844 All time: 3,861 This week: 1,336Up
Version License Categories  
mysqlconnector 1.0GNU General Publi...Databases
Description Author  

This class is a wrapper around MySQL database access functions.

It features:

- Establish persistent or non persistent database connections
- Execute SQL queries
- Fetch query result set rows as arrays. The array indexes can be column numbers or names.
- Retrieve the number of rows in a result set.
- Retrieve the number of rows affected by an INSERT, UPDATE or DELETE query
- Get the table identifier value of the last inserted row with an auto-increment field
- Retrieve the error message associated to the last query query that failed - Close non-persistent database connections

Picture of S Lake
Name: S Lake <contact>
Classes: 2 packages by
Country: Canada Canada
Age: 42
All time rank: 166139 in Canada Canada
Week rank: 895 Up17 in Canada Canada Up

Details provided by the author  
MySQL Connector class 

Class developed to wrap up common native PHP mysql functions for use in projects from small to large.
This class makes it simple to use mysql in scripts as well as to aggregate these functions 
into other classes that make up a project. 

Please note this class is a work in progress and more functionality will be included in successive updates.

Getting started 

1) Create a config file (or add to existing config file) using either of the following conventions:
	Defined as Constants (Recommended)
	-> define('HOST','localhost'); //Host your database server is on...most cases localhost is where the server is located, however check with your Host to make sure of this
	-> define('USER','mysql_username'); //Your MySQL Username to access the database defined below
	-> define('PASS','mysql_user_password'); //Your mySQL password
	-> define('DATABASE','mysql_database'); //The database you want to work with
	-> define('CTYPE','Connectiontype'); //Connection type to create, Non Persistent or persistent, 1 for non persistent (Default) and 2 for persistent
	
	Defined as variables
	-> $host = "localhost";  //Host your database server is on...most cases localhost is where the server is located, however check with your Host to make sure of this
	-> $user = "mysql_username";  //Your MySQL Username to access the database defined below
	-> $pass = "mysql_user_password"; //Your mySQL password
	-> $database = "MySQL Database"; //The database you want to work with
	-> $ctype = "Connectiontype"; //Connection type to create, Non Persistent or persistent, 1 for non persistent (Default) and 2 for persistent

2) Create an object name to use the class in an application page
	a) If using constants in a config file: 
		-> $mysql = new mysqlconnection(HOST,USER,PASS,DATABASE,CTYPE); //if CTYPE is not included then defaults to 1 (Non Persistent)
	b) If using variables in your config file:
		-> $mysql = new mysqlconnector($host,$user,$pass,$database,$ctype); //if $ctype is not included then defaults to 1 (Non Persistent)
	
	To create more then one connection to the database or to use another database at the same time 
	then create an object name for the connection with a number appended to it, also create 
	additional parameters in your config file similar to the above but with a number appended to 
	these as well: 
	Example: 
	-> $mysql = new mysqlconnection(HOST,USER,PASS,DATABASE,CTYPE); //Database connection 1
	-> $mysql2 = new mysqlconnection(HOST,USER2,PASS2,DATABASE2,CTYPE2); //Database connection 2

3) Simple mysql connection example:

-----------------------------------
require_once "includes/config.inc.php"; //Require the config file
require_once "includes/mysql.class.php"; //Require the mysql connector class

$mysql = new mysqlconnector(HOST,USER,PASS,DATABASE); //Create connection to database 

//Create a sql query 
$sql = "SELECT * FROM example";

//Execute the query
$mysql->execute_query($sql);

//Check to see if the resultset has records
if($mysql->numRows() <= 0) {
	print "no records found"; //no records were found
} else {
	// print out each row using associative indices
	while($row = $mysql->fetchrow(3)) {
		print $row['field1'] ."<br />";
	}
} 	

$mysql->closeDB();
-----------------------------------

This was just a simple script example, however you can also use this class aggregated in another
class just as easy.

Functions:

-> persistent or non persistent functions
-> execute_query - Used to execute a query on the database
-> fetchRow - returns the result set array, array can be in the form of associative and number indices or both (Default is both)
   arguments for this function are: 1 - Both number and Associative Indices (default) 2 - As Number indices 3 - Associative indices
-> numRows - Returns the number of rows in a database query 
-> affectedRows - Returns the number of rows affected by an INSERT, UPDATE or DELETE query 
-> getInsertID - Returns the ID of the last inserted record in an INSERT query  
-> errorMsg - Returns the error message if a query fails 
-> closeDB - closes all non persistent Database connections, although this is not expressly required as PHP will close these connections when a page is loaded completely and all scripts have run
 
  Files folder image Files  
File Role Description
Plain text file mysqlconnector Class Base Class file
Accessible without login Plain text file readme Doc. The readme file for this class

 Version Control Unique User Downloads Download Rankings  
 0%Total:844All time:3,861
 This week:0This week:1,336Up
 User Comments (1)  
 
Excellent
5 years ago (kishore kumar)
70%StarStarStarStar