Can't select just inserted data from php client
| From: | Keeper | Date: | Tue, 21 Aug 2001 07:41:30 +0000 |
| Subject: | Can't select just inserted data from php client | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11584@lists.php.net to get a copy of this message | ||
When I insert some data into table, select through php ifx_ functions don't
return these newly inserted values. Can anyone tell me why this happens?
In dbaccess I can select all values.
I use apache 1.3.20, php 4.0.5 and IDS 2000 on SunOS 5.7.
This problem bugs me for some time now and I'm really pissed.
I inserted data through a stored procedure and I'm trying to select data
like this:
$conn_id=ifx_connect ($database, $username, $password);
if (! $conn_id) {
echo "<b>Ne mogu se spojiti na bazu</b>";
exit;
}
$select = pripremi_upit($ime, $prezime, $zavod, $telefon, $email, $izbor);
echo "<br>" . $select . "<br>";
$rid = ifx_prepare ($select, $conn_id);
if (! $rid) {
printf("Došlo je do pogreške u radu\n");
zavrsi($conn_id);
}
$rowcount = ifx_affected_rows($rid);
if (! ifx_do ($rid)) {
printf("Ne mogu izvršiti upit nad bazom podataka\n");
zavrsi($conn_id);
}
$rowcount = ifx_num_rows($rid);
$row = ifx_fetch_row ($rid, "NEXT");
echo "Pretraživanje završeno.<br>Pronadjeno je <b>" .
$rowcount .
"</b> zapis(a)<br><br>";
echo "<h1>Rezultati pretraživanja:</h1>";
while (is_array($row)) {
for (reset($row); $fieldname = key($row); next($row)) {
$rez = array_values($row);
echo "<font > <font face=\"Arial, Helvetica, sans-serif\">";
echo "<table width=\"75%\" border=\"2\">";
echo "<tr>";
echo "<b>Prezime: </b>" . $rez[2] . "<br>";
echo "<b>Ime: </b>" . $rez[1] . "<br>";
echo "<b>Tel. broj interni: </b>" . $rez[3] . " (alt.:" .
$rez[7] .
")" . "<br>";
echo "<b>Tel. broj vanjski: </b>" . $rez[8] . "<br>";
echo "<b>Tel. broj kućni: </b>" . $rez[9] .
"<br>";
echo "<b>Zavod: </b>" . $rez[4] . "<br>";
echo "<b>Krilo: </b>" . $rez[5] . "<br>";
echo "<b>Soba: </b>" . $rez[6] . "<br>";
echo "<b>e-mail: </b> <a href=\"mailto:" . $rez[10] . "\">" .
$rez[10] . "</a>" . "<br>";
echo "</tr>";
echo "</table>";
echo "<br><hr>";
}
printf("\n<br>");
$row = ifx_fetch_row ($rid, "NEXT");
}
echo "Pretraživanje završeno.<br>Pronadjeno je <b>" .
$rowcount .
"</b> zapis(a)<br><br>";
ifx_free_result ($rid);
ifx_close ($conn_id);
Thanks for help!