我代码if ($conn) {
$recode = "select * from test";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['tag']] = $row ["pinyin"];
}
}
,本来是从test表中读取tag和pinyin字段。
现在需要改成从test表读取tag,pinyin,jianpin字段。
$array [$row ['tag']] = $row ["pinyin"];
需要怎么修改?
$recode = "select * from test";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['tag']] = $row ["pinyin"];
}
}
,本来是从test表中读取tag和pinyin字段。
现在需要改成从test表读取tag,pinyin,jianpin字段。
$array [$row ['tag']] = $row ["pinyin"];
需要怎么修改?
'pinyin' => $row["pinyin"],
'jianpin' => $row["jianpin"]
);
header("content-type:text/html; charset=utf-8");
$q = strtolower($_GET["q"]);
if (!$q) return;
$conn = @mysql_connect ( "localhost", "root", "" ); //连接数据库
mysql_query("SET NAMES 'utf8'");//处理乱码
mysql_select_db ( "test", $conn ); //选择数据库
$array ;
if ($conn) {
$recode = "select * from test";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['tag']] = $row ["pinyin"];
}
}
foreach ($array as $key=>$value) {
if (strpos(strtolower("$key|$value"), $q) !== false) {
echo "$key|$value\n";
}}
?>
echo "$key|$value['pinyin']|$value['jianpin']\n";
header("content-type:text/html; charset=utf-8");
$q = strtolower($_GET["q"]);
if (!$q) return;
$conn = @mysql_connect ( "localhost", "root", "" ); //连接数据库
mysql_query("SET NAMES 'utf8'");//处理乱码
mysql_select_db ( "test", $conn ); //选择数据库
//$array ;//这行干嘛的? 声明不是这样的
$array = array();
if ($conn) {
$recode = "select * from test";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['tag']] = $row;
}
}
foreach ($array as $key=>$value) {
$pinyin = $value['pinyin'];
$jianpin = $value['jianpin'];
echo $key , '|', $pinyin, '|', $jianpin;
//这里你爱怎么操作怎么操作
}
?>
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\APMServ\www\htdocs\f\demo\a\search.php on line 13
用最初的代码可以输入sun可以得到tag:孙燕姿.我希望的是输入syz后也能得到tag:孙燕姿 2楼的方法输入任何字符都是空白,查不到结果。11楼的方法提示错误。
那这个就是你的sql语句有问题了呀~~
、这个php文档和插件官方提供的html与js文件。也就这个php文档和mysql挂钩,用到的也不过是模糊查询而已。
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource 这个错误,无一例外都是sql语句出现错误。
麻雀虽小,五脏俱全,就算你只用了模糊搜索,你能保证它完全正确么!
谢谢以上朋友的热心答复。
<?php
header("content-type:text/html; charset=utf-8");
$q = strtolower($_GET["q"]);
if (!$q) return;
$conn = @mysql_connect ( "localhost", "root", "" ); //连接数据库
mysql_query("SET NAMES 'utf8'");//处理乱码
//mysql_query ( "SET character_set_connection=gbk , character_set_results=gbk, character_set_client=gbk, sql_mode='' " );
mysql_select_db ( "dmc130260_db", $conn ); //选择数据库 if ($conn) {
$recode = "select * from test";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['tag']] = $row ["pinyin"];
$array_push [$row ['tag']] = $row ["jianpin"];
}
}
foreach ($array as $key=>$value) {
if (strpos(strtolower("$key|$value"), $q) !== false) {
echo "$key|$value\n";
}}
foreach ($array_push as $key=>$value) {
if (strpos(strtolower("$key|$value"), $q) !== false) {
echo "$key|$value\n";
}}?>