set_charset("utf8"); //2.查詢資料表books $str = ""; if(isset($_POST['t1']))$str = $_POST['t1']; $result = $conn->query("select * from books where 書籍名稱 like '%".$str."%'"); //3.輸出全部資料 $all = $result->fetch_all(MYSQLI_BOTH); ?>

請輸入書名 書籍編號書籍名稱價格"; foreach($all as $v) { $table .= "".$v['書籍編號']."".$v['書籍名稱']."".$v['價格'].""; } $table .= ""; echo $table; ?>

close(); ?>