| zius |
Дата: Понедельник, 07.11.2011, 12:12 | Сообщение № 1 |
| Новичок
Group: Пользователи
Posts: 1
Reputation: 0
Status: нет меня |
Форма:
<form>
<input type='text' name="company" id='company1' value='' size='40' onkeyup='lookup(this.value)' autocomplete='off' onblur='hide();' >
</form>
<div class='suggestionsBox' id='suggestions' style='display: none;'>
<div class='suggestionList' id='autoSuggestionsList'>
</div>
</div>
СКРИПТ:
function lookup(inputString) {
if(inputString.length == 0)
{
hide();
}
else
{
$.post("find.php", {q: ""+inputString+"" }, function(data)
{
if(data.length > 0)
{
$('#suggestions').show();
$('#autoSuggestionsList').html(data);
}
});
}
}
PHP:
<?
$db = pg_connect("host=... port=... dbname=... user=... password=...")
or die("Could not connect");
pg_set_client_encoding($db,"UTF-8");
if (isset($_POST['q'])) {
$q = pg_escape_string($_POST['q']);
if (strlen($q) > 0) {
if ($qu=pg_query($db,"SELECT DISTINCT name_comp,comp_id FROM comp_all_v WHERE LOWER(name_comp) LIKE LOWER('%$q%') LIMIT 5 ")) {
$row_n=pg_num_rows($qu);
$row=0;
$str_from='"';
$str_to='';
for ($i=0;$i<$row_n;$i++)
{
$data = pg_fetch_object($qu,$row);
$name=str_replace($str_from,$str_to,$data->name_comp);
$comp_id=$data->comp_id;
echo ("<li onclick=\"fill('$name',$comp_id);\">$data->name_comp</li>");
$row++;
};
}
pg_free_result ($qu);
}
pg_close ($db);
}
?> |
| |
| |
