php + informix -> select problem

Anon

Hi!

I have a problem. When I insert data in informix database and later try to get it through select (with php), data is not shown.
In dbaccess I cas select data normaly.

Can anyone help me with this? I really don't know what to do.

I use Informix DS 2000, on Solaris 7 with apache 1.3.19 and php 4.0.5

I use ifx_connect, ifx_query, ifx_prepare and ifx_do functions. If code is needed, I can send it.

Thanks!

Anon

Hard to say without posting the code.

For starters, check the status of each SQL execution and make sure they work properly. Display the status code of each one.

If they are working, double check the field names you're using and make sure they're spelled correctly. I've done that where I selected "case_nbr" and referenced them as "case" giving me a page of nothing.

Hank

Anon

OK here is the code. Maybe is something with cache. I tried adding:
<META HTTP-EQUIV="Expires" CONTENT="Fri, Jun 12 1981 08:20:00 GMT">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
but still is the same.

main.htm:

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css">

</style>
</head>

<body bgcolor="#FFFFFF">
<table background="td-background.jpg" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font ><b> <font face="Arial, Helvetica, sans-serif">Adresar Instituta
Ru<F0>er Bo<B9>kovi<E6>:</font></b></font></td>
</tr>
</table>
<form name="form1" method="post" action="trazi.php">
<div align="left">
<p>  </p>
<table width="75%" border="0" align="center">
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">ime: </font></div>
</td>
<td width="51%">
<div align="left">
<input type="text" name="ime">
</div>
</td>
</tr>
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">prezime:
</font></div>
</td>
<td width="51%">
<div align="left">
<input type="text" name="prezime">
</div>
</td>
</tr>
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">zavod:
</font></div>
</td>
<td width="51%">
<div align="left">
<select name="zavod">
<option value="Knji<BE>nica">Knji<BE>nica</option>
<option value="Ra<E8>unalni centar">Ra<E8>unalni centar</option>
<option value="Slu<BE>ba za odr<BE>avanje i tehni<E8>ke usluge">Slu<BE>ba za
odr<BE>avanje i tehni<E8>ke usluge</option>
<option value="Uprava">Uprava</option>
<option value="Zavod za eksperimentalnu fiziku">Zavod za eksperimentalnu
fiziku</option>
<option value="Zavod za elektroniku">Zavod za elektroniku</option>
<option value="Zavod za fiziku materijala">Zavod za fiziku materijala</option>
<option value="Zavod za fizi<E8>ku kemiju">Zavod za fizi<E8>ku kemiju</option>
<option value="Zavod za istra<BE>ivanje mora">Zavod za istra<BE>ivanje
mora</option>
<option value="Zavod za istra<BE>ivanje mora i okoli<B9>a">Zavod za istra<BE>ivanje
mora i okoli<B9>a</option>
<option value="Zavod za kemiju materijala">Zavod za kemiju materijala</option>
<option value="Zavod za laserska i atomska istra<BE>ivanja i razvoj">Zavod
za laserska i atomska istra<BE>ivanja i razvoj</option>
<option value="Zavod za molekularnu genetiku">Zavod za molekularnu
genetiku</option>
<option value="Zavod za molekularnu medicinu">Zavod za molekularnu
medicinu</option>
<option value="Zavod za organsku kemiju i biokemiju">Zavod za organsku
kemiju i biokemiju</option>
<option value="Zavod za teorijsku fiziku">Zavod za teorijsku fiziku</option>
<option value="svi" selected>cijeli IRB</option>
</select>
</div>
</td>
</tr>
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">telefonski
broj: </font></div>
</td>
<td width="51%">
<div align="left">
<input type="text" name="telefon">
</div>
</td>
</tr>
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">e-mail:
</font></div>
</td>
<td width="51%">
<div align="left">
<input type="text" name="email">
</div>
</td>
</tr>
<tr>
<td width="49%">
<div align="right"><font face="Arial, Helvetica, sans-serif">na<E8>in pretra<BE>ivanja</font></div>
</td>
<td width="51%">
<select name="izbor">
<option value="1"><E8><BE><B9></option>
<option value="2">czs</option>
</select>
</td>
</tr>
<tr>
<td width="49%"><font size="2"></font></td>
<td width="51%"><font size="2"> </font></td>
</tr>
<tr>
<td width="49%"> </td>
<td width="51%"><font size="2">
<input type="submit" name="Submit" value="Tra<BE>i!">
</font></td>
</tr>
</table>
<p align="center">  </p>
<p align="center"><font size="2"> <br>
</font></p>
</div>
</form>
<p> </p>
<div align="left"><font size="2" face="Arial, Helvetica, sans-serif">Upute za
pretra<BE>ivanje: </font>
<ul>
<li><font size="2" face="Arial, Helvetica, sans-serif">Unesite klju<E8> pretra<BE>ivanja.</font></li>
<li><font size="2" face="Arial, Helvetica, sans-serif">Klju<E8> mo<BE>e biti bilo
koji od gore navedenih podataka.</font></li>
<li><font size="2" face="Arial, Helvetica, sans-serif">Klju<E8> mora sadr<BE>avati
<b>najmanje 3 znaka</b>.</font></li>
<li><font size="2" face="Arial, Helvetica, sans-serif">Dozvoljeno je pretra<BE>ivati
po dijelu pojma, npr. po dijelu imena. Ukoliko pretra<BE>ujete po dijelu pojma,
mo<BE>ete se koristiti slijede<E6>im zamjenskim znakovima:</font>
<ul>
<li><font face="Courier New, Courier, mono"><b><font color="#3333FF">%</font></b></font>
zamjenjuje jedan ili vi<B9>e znakova, npr. <font face="Courier New, Courier, mono" color="#3333FF">%nka<
/font>
<E6>e prona<E6>i sve nizove koji zavr<B9>avaju sa "nka". Znak <font face="Courier New, Courier
, mono"><b><font color="#3333FF">%</font></b></font>
se mo<BE>e pojaviti vi<B9>e puta u nizu, npr. <font face="Courier New, Courier, mono" color="#3333FF">%n
ovs%</font>.</li>
<li><b><font face="Courier New, Courier, mono" color="#3333FF"></font></b>
zamjenjuje jedan jedini znak, npr. <font face="Courier New, Courier, mono" color="#3333FF">ario</font>
<E6>e prona<E6>i sve nizove koji se sastoje od dijela "ario", dok
im je prvi znk bilo <B9>to (mario, dario, ...). Znak <font color="#3333FF"></font>
se tako<F0>er mo<BE>e pojaviti vi<B9>e puta u nizu, npr. <font face="Courier New, Courier, mono" color="
#3333FF">ar_o</font>.</li>
</ul>
</li>
<li><font size="2" face="Arial, Helvetica, sans-serif">Postoje dva na<E8>ina
pretra<BE>ivanja:</font>
<ul>
<li><font size="2" face="Arial, Helvetica, sans-serif">kori<B9>tenjem hrvatskih
znakova (<E8><BE><B9>): na<E8>in pretra<BE>ivanja = <E8><BE><B9></font></li>
<li><font size="2" face="Arial, Helvetica, sans-serif">upotrebom czs umjesto
<E8><BE><B9>: na<E8>in pretra<BE>ivanja = czs</font></li>
</ul>
</li>
<li><font size="2" face="Arial, Helvetica, sans-serif">Svejedno je pi<B9>ete
li velikim ili malim slovima.</font></li>
</ul>
</div>
<table align="right">
<tr>
<td align=right nowrap> <font size="2" face="Arial, Helvetica, sans-serif">Izmjene
i dopune <B9>aljite na email <a
href=mailto:imenik@nippur.irb.hr>imenik@nippur.irb.hr</a><br>
Adresar odr<BE>ava Mario Pranji<E6>, Knji<BE>nica</font></td>
</table>
<p> </p>
<p align="center"> </p>
<div align="center"></div>
<p> </p>
<p> </p>
<p align="center"><a href="http://www-4.ibm.com/software/data/informix" target="_top"><img src="pbi.gif" width="95
" height="50" border="0"></a></p>
<p> </p>
</body>

trazi.php:

<head><title> test </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css">

</style>
</head>
<body>
<?php

setlocale("LC_ALL", "hr_HR");

/**********************************************
Funkcija: zavrsi
zatvara konekciju sa bazom
**********************************************/
function zavrsi($conn_id) {
ifx_close ($conn_id);
exit;
}

/***********************************************
Funkcija: csz
znakove C,c,Z,z,S,s,Dj,dj zamjenjuje sa
sto informixu govori da te znakove zamijeni s
bilo kojim znakom
***********************************************/
function czs ($niz) {
$niz = str_replace("C", "", $niz);
$niz = str_replace("c", "", $niz);
$niz = str_replace("Z", "", $niz);
$niz = str_replace("z", "", $niz);
$niz = str_replace("S", "", $niz);
$niz = str_replace("s", "", $niz);
$niz = str_replace("DJ", "", $niz);
$niz = str_replace("dj", "", $niz);
$niz = str_replace("Dj", "", $niz);
$niz = str_replace("dJ", "_", $niz);
return $niz;
}

/***********************************************
Funkcija: cro
Hrvatske dijakriticke znakove pretvara u
sto informixu govori da te znakove zamijeni s
bilo kojim znakom
***********************************************/
function cro ($niz) {
$niz = str_replace("<BE>", "", $niz);
$niz = str_replace("<AE>", "", $niz);
$niz = str_replace("<D0>", "", $niz);
$niz = str_replace("<F0>", "", $niz);
$niz = str_replace("<A9>", "", $niz);
$niz = str_replace("<B9>", "", $niz);
$niz = str_replace("<C8>", "", $niz);
$niz = str_replace("<E8>", "", $niz);
$niz = str_replace("<C6>", "", $niz);
$niz = str_replace("<E6>", "_", $niz);
return $niz;
}

/***********************************************
Funkcija: pripremi_upit
Parsira ulazne podatke i priprema SQL upit
***********************************************/
function pripremi_upit($ime, $prezime, $zavod, $telefon, $email, $izbor) {

    $select ="select osoba.osoba_id, osoba.ime, osoba.prezime, telefon1.tel_broj kucni1, zavod.naziv zavod, kr

ilo.naziv krilo, soba.broj soba, telefon2.tel_broj kucni2, telefon3.tel_broj vanjski, telefon4.tel_broj tel_stan_i
d, osoba.e_mail from osoba, telefon telefon1, telefon telefon2, telefon telefon3, telefon telefon4, soba, krilo, z
avod
where telefon1.tel_id=osoba.irb1_id
and osoba.zavod_id=zavod.zavod_id
and osoba.krilo_id=krilo.krilo_id
and osoba.soba_id=soba.soba_id
and osoba.irb2_id=telefon2.tel_id
and osoba.vanjski_id=telefon3.tel_id
and osoba.tel_stan_id=telefon4.tel_id";

    // ukoliko nista nije bilo upisano u formu
    if ($ime=='' && $prezime=='' && $telefon=='' && $email=='' && zavod == 'svi') {
            echo "Unesite podatke za barem jedno polje!";
            exit;
    }

    /*******************************************
     * ime                                     *
     *******************************************/
    if ($ime != '') {
            if (strlen($ime) < 3) {
                    echo "Klju<E8> <b>ime</b> mora biti dug najmanje 3 znaka!";
                    exit;
            }

            IF ($izbor==1) {

// $ime = cro($ime);
}
else {
$ime = czs($ime);
}
$select = $select . " and UPPER(osoba.ime) LIKE UPPER(\"" . $ime . "\")";
}

    /*******************************************
     * prezime                                 *
     *******************************************/
    if ($prezime != '') {
            if (strlen($prezime) < 3) {
                    echo "Klju<E8> <b>prezime</b> mora biti dug najmanje 3 znaka!";
                    exit;
            }
            if ($izbor==1) {

// $prezime = cro($prezime);
}
else {
$prezime = czs($prezime);
}
$select = $select . " and UPPER(osoba.prezime) LIKE UPPER(\"" . $prezime . "\")";
}

    /*******************************************
     * zavod                                   *
     *******************************************/

    if ($zavod != svi) {
            $select = $select . " and zavod.naziv = \"" . $zavod . "\"";
    }

    /*******************************************
     * telefon                                 *
     *******************************************/
    if ($telefon != '') {
            if (strlen($telefon) < 3) {
                    echo "Klju<E8> <b>telefon</b> mora biti dug najmanje 3 znaka!";
                    exit;
            }
            $select = $select . " and (telefon1.tel_broj LIKE \"%" . $telefon . "%\" or telefon2.tel_broj LIKE

\"%" . $telefon . "%\" or telefon3.tel_broj like \"%" . $telefon . "%\" or telefon4.tel_broj like \"%" . $telefon
."%\")";
}

    /*******************************************
     * e-mail                                  *
     *******************************************/
    if ($email != '') {
            if (strlen($email) < 3) {
                    echo "Klju<E8> <b>e-mail</b> mora biti dug najmanje 3 znaka!";
                exit;
            }
            $select = $select . " and UPPER(osoba.e_mail) like UPPER(\"%" . $email ."%\")";
    }

    /*******************************************
     * group by i order by dodatak             *
     *******************************************/

    $select = $select . " group by osoba.ime, osoba.prezime, osoba.osoba_id, telefon1.tel_broj, zavod.naziv, k

rilo.naziv, soba.broj, telefon2.tel_broj, telefon3.tel_broj, telefon4.tel_broj, osoba.e_mail order by osoba.prezim
e, osoba.ime";

    return $select;

}
// --> kraj funkcije pripremi_upit
/*****************************************************************************/

$indexpolje = array ("Ime: ", "Prezime: ", "Zavod: ", "Krilo: ", "Soba: ", "Ku<E6>ni: ", "alt.: ", "Vanjski: ", "
Privatni: ", "e-mail: ");
$conn_id=ifx_connect ("imenik@meliorshm", "ifxuser", "ifxuser");

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&#353lo je do pogre&#353ke u radu\n");
zavrsi($conn_id);
}

$rowcount = ifx_affected_rows($rid);

if (! ifx_do ($rid)) {
printf("Ne mogu izvr&#353iti upit nad bazom podataka\n");
zavrsi($conn_id);
}

//$rowcount = ifx_num_rows($rid);

$row = ifx_fetch_row ($rid, "NEXT");

echo "<h1>Rezultati pretra&#382ivanja:</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&#263ni: </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&#382ivanje zavr&#353eno.<br>Pronadjeno je <b>" . $rowcount . "</b> zapis(a)<br><br>";

ifx_free_result ($rid);
ifx_close ($conn_id);
?>
</body>

Anon

I don't claim to be a PHP guru, but I'm not sure about the section of code where you reference your array data.

while (is_array($row)) {
for (reset($row); $fieldname = key($row); next($row)) {
$rez = array_values($row);
...
echo "Prezime: " . $rez[2] . "<br>"; <---??????
...

Have you tried

while (is_array($row)) {
echo "<table width=\"75%\" border=\"2\">";
echo "<tr>";
printf("Prezime: %s <br>", $row["ime"]);
printf("Ime: %s <br>", $row["osoba_id"]);
...
}

or possibly

while (is_array($row)) {
echo "<table width=\"75%\" border=\"2\">";
echo "<tr>";
printf("Prezime: %s <br>", $row["osoba.ime"]);
printf("Ime: %s <br>", $row["osoba.osoba_id"]);
...
}

I substituted the column names in your select statement thinking that $rez[2] meant "ime" and $rez[1] meant "osoba_id". If that's wrong, please use the correct column names.
Note: I find using printf instead of echo is easier (for me) since the column names are in quotes.

Hope this helps.

Hank