Hi, I'm trying to create a php form which checks the entered text in the database and displays it..
Code:
<html>
<
head></head>
<
body>
<
form name="Pretraga" action="pretraga.php" method="post">
<
input type="text" name="pretraga">
<
input type="submit" value="Traži">
</
form>
</
body>
</
html
- this is a simple form in which I enter text I would like to search

Code:
<?php
$pretraga
=$_REQUEST['pretraga'];
require_once(
"connection.php");
$cur=odbc_exec($cnx,"SELECT Osobe.ID, Osobe.ImePrezime, Osobe.Slika, Osobe.BrSobe FROM Osobe WHERE 
(((Osobe.ImePrezime) Like \"*\" & \""
.$pretraga."\" & \"*\"));");
if (!
$cur) {
    
Error_handler"Error in odbc_exec( no cursor returned ) " $cnx );
    }
echo 
"<table border=0><tr><td>ID</td><td>Ime i prezime</td><td>Slika</td><td>Broj sobe</td></tr>";
while(
odbc_fetch_row($cur)){
    
$ID=odbc_fetch_row($cur,1);
    
$ImePrezime=odbc_fetch_row($cur,2);
    
$Slika=odbc_fetch_row($cur,3);
    
$BrSobe=odbc_fetch_row($cur,4);
    
    echo 
"<tr><td>$ID</td><td>ImePrezime</td><td><img src=\"".$Slika."\"</td><td>$BrSobe</td></tr>";
    }
echo 
"</table>";
odbc_close($cnx);
    
?>
- and this is the form that should connect to the database and search for entered text.

I get an error saying:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in C:\xampp\htdocs\access\pretraga.php on line 5



Fatal error: Call to undefined function error_handler() in C:\xampp\htdocs\access\pretraga.php on line 7
The query works perfectly in Access, only difference is that instead of SELECT Osobe.ID, Osobe.ImePrezime, Osobe.Slika, Osobe.BrSobe FROM Osobe WHERE
(((Osobe.ImePrezime) Like \"*\" & \"".$pretraga."\" & \"*\"));");
I have [insert text you would like to search] and it displays text box in which I enter the text..

Hope you understood my question..
Thanks in advance for any help..