文本框建议php mysql [英] text box suggestions php mysql
本文介绍了文本框建议php mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨frnds,
即时尝试以下代码,但不适用于建议你可以帮我吗...
php到MYsql
$ q = $ _ GET [ ' q'];
$ my_data = mysql_real_escape_string($ q);
$ mysqli = mysqli_connect(' localhost',' 用户名',' password' ,' databasename')或 die( 数据库错误);
$ sql = SELECT name FROM tag WHERE name LIKE'%$ my_data%'ORDER BY name< /跨度>;
$ result = mysqli_query($ mysqli,$ sql)或 die(mysqli_error()) ;
if($ result)
{
while($ row = mysqli_fetch_array($ result))
{
echo $ row [' name']。 \ n;
}
}
?>
HTML
< title > 自动完成输入框< / title >
< link rel = 样式表 type = text / css href = jquery.autocomplete.css / >
< script type = text / javascript src = jquery.js < span class =code-keyword>> < / script >
< script type = text / javascript src = jquery.autocomplete.js > < / script >
< script >
$( document )。ready( function (){
$( #标记)。autocomplete( autocomplete.php,{
selectFirst : true
});
});
< / script >
< / head >
< body >
< label > 标记:< / label >
< 输入 名称 = tag type = text id = tag size = 20 < span class =code-keyword> / >
< / body >
解决方案
q =
_GET [' q'跨度>];
my_data = mysql_real_escape_string(
hi frnds,
im trying following code but it doesn't works for suggestion can you help me...
php to MYsql
$q=$_GET['q'];
$my_data=mysql_real_escape_string($q);
$mysqli=mysqli_connect('localhost','username','password','databasename') or die("Database Error");
$sql="SELECT name FROM tag WHERE name LIKE '%$my_data%' ORDER BY name";
$result = mysqli_query($mysqli,$sql) or die(mysqli_error());
if($result)
{
while($row=mysqli_fetch_array($result))
{
echo $row['name']."\n";
}
}
?>
HTML
<title>Auto Complete Input box</title>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<script>
$(document).ready(function(){
$("#tag").autocomplete("autocomplete.php", {
selectFirst: true
});
});
</script>
</head>
<body>
<label>Tag:</label>
<input name="tag" type="text" id="tag" size="20"/>
</body>
解决方案
q=
_GET['q'];
my_data=mysql_real_escape_string(
这篇关于文本框建议php mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文