<?php
//資料庫設定
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "密碼";
$dbName = "資料庫";

//連線資料庫伺服器
$conn = @mysqli_connect($dbServer, $dbUser, $dbPass, $dbName);

if (mysqli_connect_errno($conn))
  die("無法連線資料庫伺服器");

//設定連線的字元集為 UTF8 編碼
mysqli_set_charset($conn, "utf8");


//刪除欄位/////
if(isset($_POST['表單欄位name'])){
$sql="delete from 資料表 where 欄位=".$_POST['表單欄位name']; 

mysqli_query($conn, $sql); 

if(mysqli_affected_rows($conn)>0)
	echo "已經刪除了".mysqli_affected_rows($conn)."筆記錄";
else
	echo "刪除失敗";

}


////釋放記憶體////////////////////////////
mysqli_free_result($result); // 釋放result物件佔用的記憶體
mysqli_close($conn); //關閉資料庫連接

?>