bwahahahaha!

van__

Kept running this...

if (!is_array($exists)) {
$stmt = "INSERT INTO myAppraisers (agentID,apprsID) VALUES (".
"'" . $agent[0]['agentID'] . "','" . $GLOBALS['uID'] . "')".
$this->DBI($stmt);
echo $stmt;

}

and wondering why the database wasn't updating.

Never got an error from PHP or MySQL
and the query ran just fine when I copied and pasted the echo'd statement.

10 minutes later I see the "." at the end of the query instead of a ";"...

Sneaky lil typo bastage...
looks good, doesn't run, but doesn't error.

[deleted]

Errors bigtime, if you check for errors...

van__

Really?

I have this in my loading class constructor...
if (defined('ERROR_LEVEL')) {
error_reporting(ERROR_LEVEL);
}

which is currently at E_ALL since I'm in development and I want things devoid of warnings and notices as well as errors.

And it never made a peep.
Just to make sure...
I tried echoing a non-existent array key,
warned just like it should.

But, it could be with how things are scoped.
$this->DBI() is in another object that extends the current objects parent object...
so that may be why you got an error and I didn't.

I thought it was strange that it didn't output anything for the reference to $this->DBI() though... since that always returns a hash table. But, like I said, could just be with the funky scoping... The object library actually goes into a wormhole and turns inside out when I run it.
Which is pretty damned handy actually.
Because everything takes place in a scope that doesn't truly exist... it's in a class that's a non-object because it's extended by it's children which kill it when they spawn.

Pretty tricky.
Made me sit and think for a bit when I first descovered that... still don't understand as to why, since it is there, but it isn't at the same time. But it's fun to play with and runs well.

Anon

Depends on what was in $stmt. You probably successfully nothing at all.

van__

No $stmt worked fine on it's own.
That's the first thing I check is the query itself by copy/pasting the echo'd query into the MySQL monitor.

Here, it was a line of code that read as valid but was never properly executed.

Anon

$stmt = "INSERT INTO myAppraisers (agentID,apprsID) VALUES (".
	  	  "'" . $agent[0]['agentID'] . "','" . $GLOBALS['uID'] . "')".

I find it easier to see the SQL statements if I assign them like this:

$stmt = <<<SQL
INSERT INTO myAppraisers (agentID, apprsID)
VALUES ('$agent[0]["agentID"]', '$GLOBALS["uID"]');
SQL;

That way the statements don't get cluttered down with "."'s

/Niklas

Anon

The echo happened after the assignment to $stmt. The query was run as part of the concatenation, before anything was assigned.

Anon

test

van__

not so.

if (is_array($agent)) {
$stmt = "SELECT agentID FROM myAppraisers WHERE agentID='".$agent[0]['agentID'].
"' AND apprsID='".$GLOBALS['uID']."'";
$exists = $this->DBI($stmt);

if (!is_array($exists)) {
$stmt = "INSERT INTO myAppraisers (agentID,apprsID) VALUES (".
	  	  "'" . $agent[0]['agentID'] . "','" . $GLOBALS['uID'] . "')";
$this->DBI($stmt);
}

}

You see, it was a nested condition in a class method. I see no need to post the entire method though... but just so you know that $stmt was assigned.

If the query caused the MySQL client to bitch, the site would have parsed a pretty error tamplate for display in the {CONTENT_BODY} section of the page and then would have emailed me.

if the var $stmt was not assigned, it would have output a warning about use of an unassigned variable since I am working in E_ALL error_reporting level while I develop to ensure the site is free of any and all notices and warnings as well as errors.

So I have error reporting more than covered.
I just thought it was funny that I made a syntax error that operated as valid code.

van__

Ya, but I've been concat'ng my SQL since PHP3 and old habits die hard man.

But, that is a very good point.

tomhath

Exactly my point. The code you initially posted would've executed the "SELECT agentID ... a second time. Then catenated the return from $this->DBI... onto the end of the statement you meant to execute.

if (!is_array($exists)) {
$stmt = "INSERT INTO myAppraisers (agentID,apprsID) VALUES (".
"'" . $agent[0]['agentID'] . "','" . $GLOBALS['uID'] . "')".
$this->DBI($stmt);
echo $stmt;
}

van__

Ya, but it didn't return anything.
I would've expected it to print 'array' at the end there, since DBI() always returns an array on success.

In any event, this was posted because I thought it was a funny thing to have happen rather than being an actual problem or issue.