set_charset("utf8"); //2.刪除記錄 $str = ""; if(isset($_POST['t1']))$str = $_POST['t1']; if($conn->query("delete from books where 書籍編號=".$str)) echo "成功刪除"; else echo "無法刪除"; //3.查詢最新的資料表books $result = $conn->query("select * from books"); //4.輸出全部資料 $all = $result->fetch_all(MYSQLI_BOTH); ?> Document
請輸入想刪除的書籍編號 書籍編號書籍名稱價格"; foreach($all as $v) { $table .= "".$v['書籍編號']."".$v['書籍名稱']."".$v['價格'].""; } $table .= ""; echo $table; ?>
close(); ?>