Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Boa tarde pessoal.
Confesso que não manjo muito de Json, mas estou me esforçando para aprender.
Seguinte:
Tenho esse script de busca:
html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="[http://www.w3.org/1999/xhtml">](http://www.w3.org/1999/xhtml)
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Autocomplete search in PHP, Mysql, Json, Autosuggestion search in PHP, Jquery UI</title>
<meta name="description" content=""/>
<script src="[http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">](http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js)
<script type="text/javascript" src="jquery-ui-1.8.2.custom.min.js"></script>
<link href="css.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
$(function() {
$("#dd_user_input").autocomplete({
source: "global_search.php?cityId=28",
minLength: 2,
select: function(event, ui) {
var getUrl = ui.item.id;
if(getUrl != '#') {
location.href = getUrl;
}
},
html: true,
open: function(event, ui) {
$(".ui-autocomplete").css("z-index", 1000);
}
});
});
</script>
</head>
<body>
<div class="container">
<div class="cnt_left floatL">
<form onsubmit="return false;">
<input id="dd_user_input" type="text" class="search_form" onblur="if(this.value=='')this.value=this.defaultValue;" onfocus="if(this.value==this.defaultValue)this.value='';" value="Type your Input Here"/>
</form>
</div>
</div>
</div>
</body>
</html>php
<?php
/====================== Database Connection Code Start Here ======================= /
define ("DB_HOST", "localhost"); // set database host
define ("DB_USER", "root"); // set database user
define ("DB_PASS",""); // set database password
define ("DB_NAME","tavares"); // set database name
$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
$db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");/====================== Database Connection Code End Here ========================== /
// Here, we will get user input data and trim it, if any space in that user input data
$user_input = trim($_REQUEST['term']);
// Define two array, one is to store output data and other is for display
$display_json = array();
$json_arr = array();
$user_input = preg_replace('/\s+/', ' ', $user_input);
$query = 'SELECT bg.descricao, bg.ema FROM tb_produtos bg WHERE bg.descricao LIKE "%'.$user_input.'%"';
$recSql = mysql_query($query);
$registros = mysql_num_rows($recSql);
if($registros < 10){
if(mysql_num_rows($recSql)>0){
while($recResult = mysql_fetch_assoc($recSql)) {
//$json_arr["id"] = "[http://www.discussdesk.com/".$recResult['ema'].".htm";](http://www.discussdesk.com/)
$json_arr["id"] = "[http://localhost/projetos/ferragenstavares/produtos.php?ema=".$recResult['ema']."";](http://localhost/projetos/ferragenstavares/produtos.php?ema=)
$json_arr["value"] = $recResult['descricao'];
$json_arr["label"] = $recResult['descricao'];
array_push($display_json, $json_arr);
}
}else{
$json_arr["id"] = "#";
$json_arr["value"] = "";
$json_arr["label"] = "No Result Found !";
array_push($display_json, $json_arr);
}
}$jsonWrite = json_encode($display_json); //encode that search data
print $jsonWrite;
?>Onde eu consigo mexer para apecer aquela opção "Mostrar todos os resultados", quando se pesquisa um produto que tem vários itens?
Obrigado!!
Carregando comentários...