Login   Register  
PHP Classes
elePHPant
Icontem

File: mysql_db_connect.Readme.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Albert van Dam  >  MySQL_DB_Connect  >  mysql_db_connect.Readme.txt  >  Download  
File: mysql_db_connect.Readme.txt
Role: Documentation
Content type: text/plain
Description: Readme File
Class: MySQL_DB_Connect
MySQL database connection manager
Author: By
Last change: Updated documentation
Date: 2003-01-13 23:25
Size: 3,242 bytes
 

Contents

Class file image Download
			***********************************************
			***                                         ***
			***          MySQL_DB_Connect               ***
			***             Version 1.0                 ***
			***                                         ***
			***          Albert van Dam                 ***
			***          Email: rhodevos@net4u.co.za    ***
			***                                         ***
			***********************************************
			***                                         ***
			***                   README                ***
			***                                         ***
			***********************************************

MySQL_DB_Connect is a database connection handler making use of PHP. It shouldn't be too hard to be 
able to work on PostgreSQL, MSSql, Oracle, etc. If you require this please change the 
mysql_db_connect.inc.php file to suit your needs.

Please make sure you have the following files:
	* mysql_db_connect.cfg.php       : Database settings
	* mysql_db_connect.Functions.txt : Summary of functions
	* mysql_db_connect.inc.php       : Database handler
	* mysql_db_connect.Readme.txt    : This file
	
To get it to work, edit the mysql_db_connect.cfg.php file as follows:

	$host        :  The address where your server is located
	$db          :  The database you want to connect to
	$user        :  The username required to login to the server
	$pwd         :  The password for the user specified above.
	$keeplog     :  Whether a log of all queries should be kept
	$logpath     :  Path where log should be kept
	$fullErr     :  How you want errors to be displayed
	$rollBackSup :  If your database has transactional support (InnoDB)

In every PHP script you will be using MySQL_DB_Connect add the following code:

		require("mysql_db_connect.inc.php");
		$databaseLinkVariable = new mysql_db_connect();
		
To perform a query call:

		$databaseLinkVariable->db_qry($query);
		
To get the number of rows retrieved in the query call:

		$numberOfRows = $databaseLinkVariable->row_count();
		
To retrieve a row from the result set call:
	
		$oneRowFromResult = $databaseLinkVariable->get_data();
		
	The result will be given in a array with indexes using the field names and indexes starting at 0 and ending at the number of fields 
	minus one. If you retrieve 9 fields with values F1, F2, F3, F4, F5, F6, F7, F8, F9 the array would 
	look something like this:

$oneRowFromResult:
+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|  [0]  |  [1]  |  [2]  |  [3]  |  [4]  |  [5]  |  [6]  |  [7]  |  [8]  |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+
|  F1   |  F2   |  F3   |  F4   |  F5   |  F6   |  F7   |  F8   |  F9   |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+
		
To retrieve the names of the fields in the result set call:

		$fieldNames = $databaseLinkVariable->get_fields();
		
	The result will be given in an array as above

Check the summary of functions for more functionality, or bug me when neccesary at the above email 
address. 

If you make changes, please send me a copy.

// !!!! SOUTH AFRICA ROCKS !!!! \\