undefined var

Ika

Why my php can't read passing variable ? Here's the error :
Notice: Undefined variable: id in c:\rsim\bp\tes2.php on line 8

The code was simple :
<body>
<a href="tes2.php?id=8">Tes 2</a>
</body>

and on tes2.php i just type :
<? echo $id; ?>

I am using PHP on Windows2000 Server dan Interbase database. something wrong with php.ini setting again ???

Tia
Ika

LordShryku

where are you getting $id from?

LordShryku

nevermind, i just caught that.

Your post variables are probably set to off in php.ini

Someone correct me on this....but
I think that is $HTTP_GET_VAR['id']

LordShryku

It used to be $HTTP_GET_VARS, now it's $GET, so use $GET['id']

Ika

Thx 🙂
But i still got this error :
88 // this is the id, passed from previous form
Warning: ibase_query(): Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 35 $ in c:\rsim\bp\hsr_d.php on line 6

Warning: ibase_fetch_object(): supplied argument is not a valid InterBase result resource in c:\rsim\bp\hsr_d.php on line 7

Warning: ibase_free_result(): supplied argument is not a valid InterBase result resource in c:\rsim\bp\hsr_d.php on line 11

Here's my code :
<? echo $id;
$stmt = 'SELECT * FROM hsr_d where hsrid = $id';
$sth = ibase_query($dbh, $stmt);
$row = ibase_fetch_object($sth);
echo "<tr><td>$row->HSRID</td></tr>";

ibase_free_result($sth);
ibase_close($dbh);

?>
Familiar with this error ? 🙂 It's not easy to deal with interbase i guess. Mysql still the best for PHP.

Ika

LordShryku

You need to setup your query as a string with single quotes around the variable:

$stmt = "SELECT * FROM hsr_d where hsrid = '$id'";