Script is error'ing out

[simflex]

Hi all,
I have been playing around with this stupid code half a day and still can't get it to work.

I keep getting this error:

Fatal error: Call to a member function on a non-object

I am really new to php and have no idea why I am getting this error.

Thanks in advance.
My entire code is below:

$connectionstring = odbc_connect("counts", "", "") or die(odbc_error());

$cur = $connectionstring->Parse("SELECT fctrafic.*,contentType, FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'");
$cur->Execute;
$res = $cur->fetch();
for ($i=0; $i<12; $i++) {
	$cn = strtoupper($cur->ColumnName($i));
	$$cn = $cur->GetColumn($i);
	$cv = $$cn;
}

[lazzerous]

i think the problem may be in your select statement. When selecting from multiple tables, you have to specify the table name with each field select

SELECT
fctrafic.*,
trafficCountsFiles.contentType, 
trafficCountsFiles.FileData
FROM
trafficCountsFiles,
fctrafic
WHERE
fctrafic.site_Code = trafficcountsFiles.sitecode
AND
fctrafic.site_Code = '$_GET["site_Code"]'

[simflex]

Sorry but that didn't help as I am still getting same error.

The error says line 4 which is between this:

$connectionstring = odbc_connect("counts", "", "") or die("cannot connect to database");

and this:

$cur = $connectionstring->Parse("SELECT fctrafic.*,contentType, FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'");

Being such a novice, it is really hard to pinpoint the problem.

[AstroTeg]

What line number does PHP say the error is on? What is actually on that line?

[simflex]

Hi,

I have deleted all the white lines and the exact line is line 2 which is this line:

$connectionstring = odbc_connect("counts", "", "") or die(odbc_error());

from what I have gathered so far, even though it says line 2, it be between lines 2 and 6.

Again, as stated, I am a complete newbie.

As you can see from my posts, I have tried to alternate between

$connectionstring = odbc_connect("counts", "", "") or die(odbc_error());

and this:

$connectionstring = odbc_connect("counts", "", "") or die("cannot connect to database");

but still get same error.
Please help

[simflex]

I just added this line of code:

$result=odbc_exec($connectionstring,$sql);

and now the same error is on this line below:

$sql = "SELECT fctrafic.site_code,fctrafic.location, fctrafic.location2,fctrafic.distance, fctrafic.direction,trafficCountsFiles.contentType, trafficCountsFiles.FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'";      

I swear someone told me php is easier than asp.

How can error messages jump around like viruses?

[lazzerous]

you aren't slashing out your doible quotes

$sql = "SELECT
fctrafic.site_code, fctrafic.location, fctrafic.location2,fctrafic.distance,
fctrafic.direction,trafficCountsFiles.contentType,
trafficCountsFiles.FileData
FROM
trafficCountsFiles,fctrafic
WHERE
fctrafic.site_Code = trafficcountsFiles.sitecode
AND
fctrafic.site_Code = '" . $_GET['site_Code'] . "'";

That should werk

[Weedpacket]

Originally posted by simflex
How can error messages jump around like viruses?

Is it the same error? Maybe you just have more than one. What is the exact statement of the error message?

I'm pretty sure you mean to use

odbc_exec($connectionstring, $cur)

. I don't know where you got $cur->Execute (or $cur->Execute() which is what you'd want if $cur was an object with an Execute method) from.

[simflex]

Thanks to all of you again for all the help.
Weedpacket and Lazzerous, the our php guy has been gone now for about 2 weeks and will be gone for another 2 weeks.

I am an asp programmer and I was asked to step in and complete the php app he was working.
I didn't realize I would have this much headache with it.

So, here is a script he wrote that does exactly what I am trying to do.
This script works fine and my problem is, if for some reason this script doesn't work for me, there is got to be another method of using that would do exactly what his script does.

Please take a quick look at his script (this is all of it).

[COLOR=blue]
<?php 
include"permissions.php.inc"; 
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> More</title>
</head>
<body bgcolor="#6270B5">
<div align="center">
<?php
$cur = $conn->Parse("select * from spillsMore where record = $record");
$cur->Execute;
$res = $cur->Fetch();

for ($i=0; $i<12; $i++) {
	$cn = strtoupper($cur->ColumnName($i));
	$$cn = $cur->GetColumn($i);
	$cv = $$cn;
}
echo "  <div align=\"center\">
 <table cellpadding='2' cellspacing='2'>
<td class='header'><font size='-3'>CITY</font></td><td class='name'><font size='-3'>$CITY</font></td><td class='header'><font size='-3'> DATE FOUND</font></td><td class='name'><font size='-3'>$DATE_FOUND</font></td></tr>
<tr><td class='header'><font size='-3'>DATE REPAIRED</font></td><td class='name'><font size='-3'>$DATE_REPAI</font></td><td class='header'><font size='-3'>RECEIVING FLOW</font></td><td class='name'><font size='-3'>$RECEIVING_</font></td></tr>
<tr><td class='header'><font size='-3'>COMMISSIONER</font></td><td class='name'><font size='-3'>$COMMISSION</font></td><td class='header'><font size='-3'>COMMISSION DISTRICT</font></td><td class='name'><font size='-3'>$DISTRICT</font></td></tr>
</table><br>
<button name=\"close\" value=\"Close\" onClick='window.close()'>Close</button>
	</div>";

?>
</body>
</html>
[/COLOR] 

There are 2 things different about his script from mine.

One, he uses postgres database and I am using access and they are not stored on the same database.

Second is, he uses, as you can see from the include file, a permissions.php where connection and access to his database is defined.

Mine is defined on the same script.

So there is some minor tweak that needs to be made to my script to work like his and that is where I am asking for you guys help.

And Lazzerous, when you said I need to slash my double quotes, do you mean like this:

'".$_GET["site_Code"].\"'"\;

Believe me, as hard as this seems right now, I will come up to speed.
I believe I had similar problem with asp.

Your assistance is greatly appreciated.

[simflex]

Please allow me to add one more comment here.

If I just use this code:

<?php
// DB connection here.
$connectionstring = odbc_connect("counts", "", "") or die(odbc_error());
$sql = "SELECT fctrafic.site_code,fctrafic.location, fctrafic.location2,fctrafic.distance, fctrafic.direction,trafficCountsFiles.contentType, trafficCountsFiles.FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'";
$result=odbc_exec($connectionstring,$sql);


echo "  <div align=\"center\">
 <table cellpadding='2' cellspacing='2'>
<td class='header'><font size='-3'>SITE CODE</font></td><td class='name'><font size='-3'>" . ((isset($site_Code)) ? $site_Code : 'No Site Code Found') . "</font></td><td class='header'><font size='-3'> TYPE</font></td><td class='name'><font size='-3'>" . ((isset($types)) ? $types : 'Type Not Available') . "</font></td></tr>
<td class='header'><font size='-3'>AADT</font></td><td class='name'><font size='-3'>" . ((isset($aadt)) ? $aadt : 'No Record Found') . "</font></td><td class='header'><font size='-3'> DATE</font></td><td class='name'><font size='-3'>" . ((isset($fdate)) ? $fdate : 'No Date Available') . "</font></td></tr>
<tr><td class='header'><font size='-3'>LOCATION</font></td><td class='name'><font size='-3'>" . ((isset($location)) ? $location : 'No Record Found') . "</font></td><td class='header'><font size='-3'>DISTANCE</font></td><td class='name'><font size='-3'>" . ((isset($distance)) ? $distance : 'No Record Found') . "</font></td></tr>
<tr><td class='header'><font size='-3'>REF LOCATION</font></td><td class='name'><font size='-3'>" . ((isset($location)) ? $location : 'No Record Found') . "</font></td><td class='header'><font size='-3'>DIRECTION</font></td><td class='name'><font size='-3'>" . ((isset($direction)) ? $direction : 'No Record Found') . "</font></td></tr>
<tr><td class='header'><font size='-3'>FILE NAME</font></td><td class='name'><font size='-3'>" . ((isset($filename)) ? $filename : 'No File(s) Found') . "</font></td></tr>
</table><br>
<button name=\"close\" value=\"Close\" onClick='window.close()'>Close</button>
</div>";

?>
</body>
</html>

I don't get any errors.
The only problem with this code is that it only displays the value for site_code.
It doesn't display value for rest of the field names like direction, distance , date, etc.

So looking back at what my partner did (the only I posted last before this one), I realized he used a FOR loop to populate the fieldnames with values.

I just can't figure out how to modify the FOR loop to work for this code.

But as you can see, the connection string I was using and the sql statement are not the problems.

I am reasonably sure the "Fatal error: Call to a member function on a non-object " error I am getting has to do with the FOR loop and the way I am using it in conjunction with the connection method and sql statement.

[simflex]

can anyone, please help?

[drew010]

im pretty sure it has to do with one or all of these lines:

$cur = $connectionstring->Parse("SELECT fctrafic.*,contentType, FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'");
$cur->Execute;
$res = $cur->fetch();

you are calling a class function but nowhere do you have $cur = new someclass();

hence the error description: Fatal error: Call to a member function on a non-object.

$cur is not an object but you are trying to call a class function as if it were an initialized object.

[simflex]

Even after I change that line like this:

$cur = "SELECT fctrafic.site_code,fctrafic.location, fctrafic.location2,fctrafic.distance, fctrafic.direction,trafficCountsFiles.contentType, trafficCountsFiles.FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'";

I still get same error

As long as I use all of them together like this:

$conn = odbc_connect("counts", "", "") or die(odbc_error());
$cur = "SELECT fctrafic.site_code,fctrafic.location, fctrafic.location2,fctrafic.distance, fctrafic.direction,trafficCountsFiles.contentType, trafficCountsFiles.FileData FROM trafficCountsFiles,fctrafic where fctrafic.site_Code = trafficcountsFiles.sitecode and fctrafic.site_Code = '".$_GET["site_Code"]."'";
$result=odbc_exec($conn,$cur);
$res = $cur->fetch();
for ($i=0; $i<12; $i++) {
	$cn = strtoupper($cur->ColumnName($i));
	$$cn = $cur->GetColumn($i);
	$cv = $$cn;

As stated earlier, If I remove

$res = $cur->fetch();
for ($i=0; $i<12; $i++) {
	$cn = strtoupper($cur->ColumnName($i));
	$$cn = $cur->GetColumn($i);
	$cv = $$cn;

The error message disappears; although only the site_code value is returned.

So there is something I am doing wrong on the loop.

Everyone, please forgive me for all the codes I am dumping here.
I am doing them hoping they woudld help me state more clearer what I am trying to accomplish.