Question

php点击按钮查询数据库

<?phpmysql_connect('地址','用户','密码') or die('连接数据库失败!');mysql_select_db('baidujingjia') or die('选择数据库失败!');mysql_query('set baidushangjia utf-8');$sql="SELECT url,guanjianci,shouji FROM baidushangjia WHERE baidu_jingjia='是' and yitianjia='' and kaitong='' and shouji!='' and beizhu='' limit 1;";$result=mysql_query($sql);while($row=mysql_fetch_array($result)){var_dump($row);}?>查询结果乱码,查询结果放在表格里面另外添加一个查询的按钮,点击按钮后执行查询语句;暂时没分了,感激不尽





Answer 1

mysql_query('set names utf-8');//设置字符集有错