Thanks for the input Weed. I am having a realy hard time figuring out how to seperate the HTML from the SuccessError class.
I have extended the Success Error class into my mysql_con_trans class and call it in place of the error code I had before.
Can anyone give me a heads up if this would considered ok? I can't realy see how I can seperate the HTML from this class because it builds the page around itself outputing the message that was sent.
Thanks!
SuccessError Class
class SuccessError{
function ErrorMessage($msg,$email){
require("topnav.php");
require("sidenav.php");
?>
<td valign=top>
<br>
<p><b>Error: <?php echo $msg; ?></b><br>
If this error persists please write us an email by <a href="<?php echo $email; ?>">clicking here</a>
</td>
<?php
require("footer.php");
}//end ErrorMessage
function SuccessMessage($msg,$forward, $forwardWhere) {
require("topnav.php");
require("sidenav.php");
?>
<td valign="top">
<br>
<p><b>Success:</b> <?php echo $msg; ?>
<br>
<br>
Your are now being forwarded <a href="<?php echo $forward; ?>"><u><font color="#9C5B4C"><b><?php echo $forwardWhere; ?></b></font></u></a> If you are not transferred please click <a href="<?php echo $forward; ?>"><u><font color="#9C5B4C"><b>here</b></font></u></a>
<META HTTP-EQUIV="refresh" CONTENT="3; URL=<?php echo $forward; ?>">
</td>
<?php
require("footer.php");
}//end SuccessMessage
}//end class SuccessError
mySQLConTrans Class
include("successerror.class.php");
class mySQLConTran extends SuccessError{
var $con;
var $numRows;
var $result;
var $errorArray = array();
var $lastError;
// Open Database connection ---------
function dbOpen($name,$host,$user,$password){
$this->con = @mysql_connect($host, $user, $password)or die (parent::ErrorMessage("Error Connecting To The Database","john@somedomain.com"));
@mysql_select_db($name, $this->con) or die (parent::ErrorMessage("Error Selecting Database!","john@somedomain.com"));
}//end dbOpen
// Close Database Connection --------
function dbClose(){
@mysql_close($this->con);
}//end dbClose
// INSERT, UPDATE, DELETE, CREATE, DROP etc... --------
function dbCommand($sql){
$this->result = @mysql_query($sql);
if(!$this->result){
$this->lastError = mysql_error();
$this->errorArray[] = mysql_error();
return false;
}else{
return true;
}//end if
}//end dbIUD
// SELECT FROM Database --------
function dbSelect($sql){
$this->result = @mysql_query($sql);
$this->numRows = @mysql_num_rows($this->result);
if(!$this->result){
$this->lastError = mysql_error();
$this->errorArray[] = mysql_error();
return false;
}else{
return true;
}//end if
}//end dbSelect
// Get first row of dbSelect --------
function getFirstRow(){
$firstRow = @mysql_fetch_array($this->result);
return $firstRow;
}//end getFirstRow
// Get last row of dbSelect --------
function getLastRow(){
@mysql_data_seek($this->result,$this->numRows-1);
$lastRow = @mysql_fetch_array($this->result);
return $lastRow;
}//end getLastRow
// Get any row of dbSelect index starts with 0--------
function getAnyRow($rowNum){
if($rowNum > $this->numRows || $rowNum < 0){
return false;
}else{
@mysql_data_seek($this->result,$rowNum);
$anyRow = @mysql_fetch_array($this->result);
return $anyRow;
}//end if
}//end getLastRow
// Get number of rows from dbSelect --------
function getNumRows(){
return $this->numRows;
}//end getNumRows
// Get number of mysql_errors --------
function getErrorCount(){
return count($this->errorArray);
}//end getErrorCount
// Get error array --------
function getErrorArray(){
return $this->errorArray;
}//end getErrorArray
// Get Last mysql_error --------
function getLastError(){
return $this->lastError;
}//end getLastError
}//end mySQLConTran Class -------------------------------