Query DB USING ID?

vexer007

Hello, Greetings to you,

I am writting a code which basically its a url like below

<a href="http://cms.gre.uk/project/singleproduct.php?ID=<?php echo "".$id->value.""; ?>">View</a>

The above seems to work as the new URL now has the Value of the ID something like

http://cms.gre.uk/project/singleproduct.php?ID=3

But I was told that I can now perform a DB query with the value on the next page, this is giving errors I dont think the variable is been passed through to the next page. can somebody help me please?

Query is:

$rs = $conn->Execute("SELECT * FROM products WHERE id = '".$id->value."'");

Error: Fatal error: Call to a member function on a non-object in e:\project\singleproduct.php on line 8

Help Please, Thank you for your time! :queasy:

drew010

that object $id no longer exists, it died as soon as the last page finished loading in your browser, you can however access the value from the query string like this:
$rs = $conn->Execute("SELECT * FROM products WHERE id = '" . $_GET['ID'] . "'");

vexer007

Hi, Thank you for your reply.

I modified the code as advised, but now get this error message:

Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. in e:\webareas\ou301\project\singleproduct.php on line 12

Fatal error: Call to a member function on a non-object in e:\webareas\ou301\project\singleproduct.php on line 14

The Id field in my db is autonumber, if that will make it a bit clearer.

Just In Case, here is the modified query version:

$rs = $conn->Execute("SELECT * FROM products WHERE id = '" . $_GET['id'] . "'");

Thanks

Frederick

It maybe you query itself.

<a href="http://cms.gre.uk/project/singleproduct.php?ID=<?php echo "".$id->value.""; ?>">View</a>

$rs = $conn->Execute("SELECT * FROM products WHERE id = '" . $_GET['id'] . "'");

Your variable does not match your link ( ID )

If you are using an include() to pull in your DB connection with the variable $conn, you do not have to add that to your query. Try the below.

$rs = "SELECT * FROM products WHERE id = ".$_GET["ID"]." ";
$result = mysql_query($rs);

vexer007

Hi, Thanks for your reply.

I have written the code like this:

$var = $_GET['id'];
$rs = $conn->Execute("SELECT * FROM products WHERE id = $var");

BUT I GET THIS ERROR:

Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id ='. in e:\webareas\ou301\project\singleproduct.php on line 11

Fatal error: Call to a member function on a non-object in e:\webareas\ou301\project\singleproduct.php on line 14

COULD THIS BE BECAUSE AM USING AN ACCESS DB?

Frederick

PHP is case sensitive, so ID and id are different.

$rs = "SELECT * FROM products WHERE id = ".$_GET["ID"]." "; 
$exc = odbc_exec($conn,$rs) or die (odbc_errormsg());
$row = odbc_fetch_array($exc);
echo $row["prod_name"];

vexer007

Hi, I wrote the code like this

$var = $_GET['ID'];
$rs = "SELECT * FROM products WHERE id = '".$var."'"
$exc = odbc_exec($rs,$conn) or die (odbc_errormsg());
$row = odbc_fetch_array($exc);
echo $row["product_name"];

BUT IS GIVING ME THIS ERROR

Parse error: parse error in e:\webareas\ou301\project\singleproduct.php on line 16

which is the : $exc = odbc_exec($rs,$conn) or die (odbc_errormsg()); LINE

tsinka

Hi,

the ; is missing at the end of the $rs = ... line

Thomas

vexer007

Thanks, I have Correted it, BUT am getting this error

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in e:\webareas\ou301\project\singleproduct.php on line 17

How can I rectify this?

tsinka

Did you use odbc_connect to connect to the data source ?

Thomas

vexer007

I Use Access ADOBD

$strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn->open($strConn);

tsinka

Looks like you're using a db class. But in the last code you posted you have

$exc = odbc_exec($rs,$conn) or die (odbc_errormsg());

Shouldn't that be

$exec = $conn->Execute($rs);
....
.....

Thomas

vexer007

Thanks, Ive now done that but it gives me this error,

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in e:\webareas\ou301\project\singleproduct.php on line 18

tsinka

How does the query look like if you print it ?

echo $rs;

EDIT: Which type does the column have ?

vexer007

It comes up with this,

tsinka

Ok,

that looks like $var points to the instance of a class.

Please post the complete code (maybe as attachment) so we can see what might be wrong.

Additionally, add
print_r($GET);
to the code to see how the $GET array looks like and post the results.

Thomas