Well, I started modifying one of the scripts I found to do the job.
The first thing I did was strip out all of the excess code. Much of the code seemed to be for features that would only be used if you wanted to create an system like phpMyAdmin! I didn't see any reason to leave the code to do SHOW, DESCRIBE, and EXPLAIN. Also, I didn't need a database create option nor a database select option.
I removed about 50 lines of code and added error checking for DELETE, INSERT, and UPDATE. It isn't the best possible class I could come up with I'm sure but it looks like it will work for now.
I thought about doing the class for PHP 5 using the mysqli functions but it seems that support for that is somewhat limited and I can't say for sure what MySQL and PHP versions the script may end up on. The mysqli extensions seem to be a lot easier to manage but that'll have to wait until I get more time. I guess it would be best if I wrote both then had the master script choose the best class for the server settings like Joomla does.
Fell free to edit or enhance this class in anyway, I would love to see any improvements anyone can make.
<?php
//////////////////////////////////////////////////////////////////////////////////////
/* DBClass v1.3 written by Matthew Manela
Script orginally written for www.Jemts.com
Copyright (C) 2003 Matthew Manela. All rights reserved.
See readme file for instructions on implementing and using this class.
If you have any question about this script please email me at jemts@jemts.com.
Updates to this class will come regularly.
*/
//////////////////////////////////////////////////////////////////////////////////////
//Start of class
class Database{
var $DBname, $DBuser, $DBpass, $DBhost;
var $DBlink, $Result;
var $Connection;
###########################################
# Function: Database - constructor
# Parameters: database name, database username, database password, database host
# Return Type: boolean
# Description: connect to database, and select database, if database doesn't exist create it and selects it
###########################################
function Database($name, $user, $pass, $host){
$this->DBname=$name;
$this->DBuser=$user;
$this->DBpass=$pass;
$this->DBhost=$host;
if(!($this->DBlink = mysql_connect($this->DBhost, $this->DBuser, $this->DBpass))){
echo mysql_errno() . ": " . mysql_error() . "\n";
trigger_error ("Cannot connect to database", E_USER_ERROR);
return FALSE;
}else{
if(!mysql_select_db($this->DBname,$this->DBlink)){
echo mysql_errno() . ": " . mysql_error() . "\n";
trigger_error ("Cannot connect to database", E_USER_ERROR);
return FALSE;
}else{
return TRUE;
}
return TRUE;
}
}#end of database constructor
//////////////////////////////////////////////////////////////////////////////////////
###########################################
# Function: Disconnect
# Parameters: none
# Return Type: boolean
# Description: disconnects from database
###########################################
function Disconnect(){
if(mysql_close($this->DBlink)){
return TRUE;
}else{
echo mysql_errno() . ": " . mysql_error() . "\n";
trigger_error ("Cannot close the database", E_USER_ERROR);
return FALSE;
}
}#end of disconnect
//////////////////////////////////////////////////////////////////////////////////////
###########################################
# Function: Query
# Parameters: sqlstring , type
# Return Type: Either boolean or array depending on type of query
# If it is a delete query returns number of rows affected
# Description: executes any SQL Query statement
###########################################
function Query($Query){
$Query = trim($Query);
if(eregi("^((SELECT))",$Query)){
if($this->Result = mysql_query($Query,$this->DBlink)) {
while ($row = mysql_fetch_array($this->Result)) {
$data[] = $row;
}
mysql_free_result($this->Result);//probably not needed
return $data;
}else{
//no entry exists in database
return FALSE;
}
}else{
$result = mysql_query($Query,$this->DBlink);
if(!isset($result) || is_null($result)){
echo mysql_errno() . ": " . mysql_error() . "\n";
trigger_error ("Query did not succeed", E_USER_ERROR);
return FALSE;
}
elseif(eregi("^((DELETE)|(INSERT)|(UPDATE))",$Query)){
if(@mysql_affected_rows() < 1){
echo mysql_errno() . ": " . mysql_error() . "\n";
trigger_error ("Query did not succeed", E_USER_ERROR);
return FALSE;
}else{
return @mysql_affected_rows();
}
}else{
return true;
}
}
}#end of query function
}#End of class
?>
<?php
$database= new Database("DatabaseName","DatabaseUser","DatabasePass","DatabaseHost");
//$rows = $database->Query("INSERT INTO jos_jstats_iptocountry (IP_FROM,IP_TO,COUNTRY_CODE2,COUNTRY_NAME) VALUES ('321321','321321','RR','Whatever')");
//$rows = $database->Query("DELETE FROM jos_jstats_iptocountry WHERE IP_FROM = '321321'");
$rows = $database->Query("SELECT * FROM jos_jstats_iptocountry");
echo "<pre>";
print_r($rows);
echo "</pre>";
$database->Disconnect();
?>
Actually, there is a large number of classes written for this subject but I don't have the time to download, review, test, and play around with each one.
Thanks for the reply.
