- 1 php 2 header("Content-Type:text/html;charset=utf-8");
- 3 4 $con = mysql_connect("localhost", "root", "root");
- 5 //当连接数据库出错时执行
- 6
- if (!$con) {
- 7 exit('链接数据库失败 ! ');
- 8
- }
- 9 //当连接表serch出错时执行
- 10
- if (!mysql_select_db('search', $con)) {
- 11 exit(mysqli_errno().":".mysql_error());
- 12
- }
- 13 mysql_select_db('search_table');
- 14 mysql_query("set names utf8");
- 15 16 $search = $_POST["search"];
- 17 18 $sql = "SELECT search_table_content FROM search_table where search_table_content REGEXP BINARY '".$search."'";
- 19 echo $sql."
- ";
- 20 $querry = mysql_query($sql);
- 21 22
- while ($info = mysql_fetch_array($querry)) {
- 23 echo $info['search_table_content'];
- 24 echo "
- ";
- 25
- }
- 26 27 28 ? >
来源: http://www.bubuko.com/infodetail-1858800.html