$dbhost = "IP位址";
$dbuser = "帳號";
$dbpass = "密碼";
$dbname = "資料庫";
$bdtable = "資料庫底下的某個table";
$mysqli = new mysqli($dbhost,$dbuser,$dbpass,$bdname);
// 連接有問題底下這是用來除錯的
if ($mysqli->connect_error) {
die("Connection failed: " . $mysqli->connect_error);
}
// 以防亂碼
$mysqli->query("SET NAMES utf8");
$contact_person = $_POST['contact_person'];
$email = $_POST['email'];
$contact_phone = $_POST['contact_phone'];
$companyname = $_POST['companyname'];
$company_address = $_POST['company_address'];
$pc_volume = $_POST['pc_volume'];
$apply_for = $_POST['apply_for'];
$description = $_POST['description'];
$stmt = "INSERT INTO $dbname.$bdtable ( uniq_id, contact_person, email, contact_phone, companyname, company_address, pc_volume, apply_for, description) VALUES('456','$contact_person','$email','$contact_phone','$companyname','$company_address','$pc_volume','$apply_for','$description')";
// 溫馨提醒
if ($mysqli->query($stmt) === TRUE) {
$_SESSION['success'] = "親愛的用戶您好,已收到您的申請表單,我們會馬上安排人員與您聯繫,請耐心等候,謝謝";
} else {
echo "Error: " . $stmt . "<br>" . $mysqli->error;
}
$mysqli->close();