Freakin Error reporting errors! Trying to catch MySql errors inside class...

[Alex-Grim]

Ok, i have a mysql class, and it's worked fine for months now, it's not the problem. I just created a Bug Reporting class, and it works... when implemented correctly. When something doesn't go as planned, i call the bug class. Well, i was trying to include the Mysql Errors in the bug reports, but i'm not able to freakin catch them!

If i say mysql_query($blah) or die (mysql_error());
It's fine, it KILLS the script, and give the error. BUT, if i do this:

	function Q($sql){
		$query = mysql_query($sql) or $this->bugout($sql);
		return $query;
	}

I get NOTHING;

I've also tried this:

	function Q($sql){
		$query = mysql_query($sql);
		if ($query == false){
			$B =  new Bug("There was an error in a query. Details: " . mysql_error());
		}else{
			return $query;
		}
	}

and this (con being the connection object.)

	function Q($sql){
		$query = mysql_query($sql);
		if ($query == false){
			$B =  new Bug("There was an error in a query. Details: " . mysql_error($this->con));
		}else{
			return $query;
		}
	}

and this

	function Q($sql){
		$query = mysql_query($sql);
		if ($query == false){
			$B =  new Bug("There was an error in a query. Details: " . $sql);
		}else{
			return $query;
		}
	}

And i'm getting NOTHING in return. I get the plain text section of the error, but not the variables or the mysql_error. I could eat glass right now!

Thanx

[Alex-Grim]

I even tried this just now (completely different approach) to no avail

function BugOut($args){
	$this->O();
	$this->Q("insert into BugReports (host,uri,uid,ctime,description)values('{$_SERVER['HTTP_HOST']}','{$_SERVER['REQUEST_URI']}','{$_COOKIE['uid']}','".date("Y-m-d H:i:s")."','$args')");
	$this->C();
	return true;
}



function Q($sql){
	$query = mysql_query($sql);
	if ($query == false){
		$this->BugOut(mysql_error());
		return false;
	}else{
		return $query;
	}
}

[Alex-Grim]

12

[NogDog]

parent::__construct[color=red]()[/color];

[Alex-Grim]

Yeah, i caught it after i posted, but that wasn't the other problem's cause. I still cannot CATCH AND REPORT a freaking error.

[Alex-Grim]

Here, i'm just going to post the whole freakin thing:

I've got an index page. EVERYTHING in the WHOLE site come through the index page.
The index page includes the MySql class, so, it's already available for any other scripts included in the page later.

I have a script that is supposed to insert a record into the database, but i purposely name one of the fields wrong, so that i can test my Bug Class. I will include all the code in a second.

If the query returns FALSE then the Bug Class is called. The Bug class's constructor accepts one argument -- the error details. It has NO OTHER methods. It takes the details, along with some server variables, and inserts them into my Bugs table.

The Bugs class Extends MySql -- which is already included via the index page.

The problem is, i am NOT able to catch the mysql_error and pass it along to the Bug class. BUT, it the MySql class, when calling a query, i can say "or die(mysql_error)", and it will give me the error just fine. This is crap... Here's the codes:

Insert statement:

	$r = $db->Q("insert into WretchedComments (uid,fromid,ctime,message,subject,label,mode)values('".$f->DbSafe($_POST['name'])."','{$_COOKIE['uid']}','".date("Y-m-d H:i:s")."','".$f->DbSafe($_POST['comment'])."','".$f->DbSafe($_POST['subject'])."','unread','$t1')");
	if ($r != true){
		$b =  new Bug("Could not insert new comment: ". mysql_error());
	}

And here's the mysql function for queries:

	function Q($sql){
		$query = mysql_query($sql);// or die(mysql_error());
		return $query;
	}

and here's the bug class:

<?php
class Bug extends MySql{
private $host;
private $uri;
private $uid;
private $desc;
private $ctime;

function __construct($description){
	$this->host= $_SERVER['HTTP_HOST'];
	$this->uri = $_SERVER['REQUEST_URI'];
	if (isset($_COOKIE['uid'])){
		$this->uid = stripslashes(str_replace("'","''",$_COOKIE['uid']));
	}else{
		$this->uid = "Guest, or Not Logged In";
	}
	$this->desc= $description;
	$this->ctime=date("Y-m-d H:i:s");
	parent::__construct();
	parent::O();
	parent::Q("insert into BugReports (host,uri,uid,ctime,description)values('{$this->host}','{$this->uri}','{$this->uid}','{$this->ctime}','{$this->desc}')");
	parent::C();
	echo "<h1>There was a bug, but it was caught and reported. You may be contacted with more questions about this bug at a later time.</h1>";
}

function R(){
}
}
?>

Now, when there IS an ERROR, the bug class will output it's error message, but it won't catch the error from the previous mysql statement, and insert it into the db. One of the ways i was tryig this, it would insert the bug report, but without the mysql_error. Now, i've messed with it so much, it's not even doing that.

[Alex-Grim]

if i add this to the end of my bug report's insert statement, like so:

$con->Q("insert into BugReports (host,uri,uid,ctime,description)values('{$this->host}','{$this->uri}','{$this->uid}','{$this->ctime}','{$this->desc}')") [COLOR="red"]or die (mysql_error())[/COLOR];

It gives me the OTHER INSERT STATEMENT'S error Message!?!? Why would it do this? This must be why it's not getting entered into the DataBase.

[Alex-Grim]

I tried to use mysql_free_result(); but it's not working either. With the following code, i get the following error:

	$r2 = $db->Q("insert into WretchedComments (uid,fromid,ctime,message,subject,label,mode)values('".$f->DbSafe($_POST['name'])."','{$_COOKIE['uid']}','".date("Y-m-d H:i:s")."','".$f->DbSafe($_POST['comment'])."','".$f->DbSafe($_POST['subject'])."','unread','$t1')");
	if ($r2 != true){
		mysql_free_result($r2);

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource

[Alex-Grim]

4 hours wasted on a stupid mistake that i have never made before: forgetting to ESCAPE the single quotes!

Here's the finished product, which works exactly as it should've to begin with:

class Bug extends MySql{

function __construct($description){
	$h = $_SERVER['HTTP_HOST'];
	$q = $_SERVER['REQUEST_URI'];
	if (isset($_COOKIE['uid'])){
		$u = stripslashes(str_replace("'","''",$_COOKIE['uid']));
	}else{
		$u = "Guest, or Not Logged In";
	}
	$d = str_replace("'","''",$description);
	$t = date("Y-m-d H:i:s");
	parent::Q("insert into BugReports (host,uri,uid,ctime,description)values('{$h}','{$q}','{$u}','{$t}','{$d}')");
	echo "<h1>There was a bug, but it was caught and reported. You may be contacted with more questions about this bug at a later time.</h1>";
}
}

[bpat1434]

Umm... wouldn't it just be easier to use [man]mysql_real_escape_string/man?