HTML/PHP无法更新SQL数据库 [英] Html / php not updating sql database
问题描述
我已经为此工作了几个小时，包括重新构建整个代码，我无法弄清楚出什么问题了. HTML表单应该填充患者的SQL数据库，但无法正常工作.我在网站的另一部分使用了类似的表单，该表单可以正常运行，但是似乎无法运行，并且无法弄清原因.
I've been working on this for hours now and including rebuilding my whole code I cannot figure out what is wrong. The HTML form is supposed to populate the patients SQL database but it is not working. I have a similar form that I am using on another part of the website that works flawlessly but this on doesn't seem to and a can't figure out why.
我已经检查了$ _POST是否通过，但是没有，但$ message值没有通过.
I have checked if the $_POST 's are coming through and they are but the $message values are not.
感谢您的帮助 这是数据库字段的图片:数据库字段
thanks for your help Here is a picture of the database fields: database fields
此处提供代码:
<?php
require 'connection.php';
$message = '';
if(!empty($_POST['name']) && !empty($_POST['dob']) && !empty($_POST['nok']) && !empty($_POST['nok_add']) && !empty($_POST['nok_phone'])&& !empty($_POST['doa'])&& !empty($_POST['allergies'])):
// Enter the new user in the database
$sql = "INSERT INTO patients (name, dob, nok, nok_add, nok_phone, doa, allergies) VALUES (:name, :dob, :nok, :nok_add, :nok_phone, :doa, :allergies)";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':name', $_POST['name']);
$stmt->bindParam(':dob', $_POST['dob']);
$stmt->bindParam(':nok', $_POST['nok']);
$stmt->bindParam(':nok_add', $_POST['nok_add']);
$stmt->bindParam(':nok_phone', $_POST['nok_phone']);
$stmt->bindParam(':doa', $_POST['doa']);
$stmt->bindParam(':allergies', $_POST['allergies']);
if( $stmt->execute() ):
$message = 'Successfully created new user';
else:
$message = 'Sorry there must have been an issue creating your account';
endif;
endif;
?>
<html>
<head>
<title>Patient Add</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" type="text/css" href="assets/css/style.css">
<link href="//fonts.googleapis.com/css?fami=Roboto:400,300,200,100&subset=latin,cyrillic" rel="stylesheet">
<style type="text/css">
#headline {
padding: 0.8em;
color: white;
font-family: Roboto, helvetica, arial, sans-serif;
background-color: black;
background-image: url(backgroundimage.jpg);
background-size: cover;
}
</style>
</head>
<body>
<div id="headline">
<div class="container">
<header>
<h1>Patient Add</h1>
<p></p>
</header>
<button onClick="window.location='manager_select.php';" class="_button">Back</button>
<form method="POST" id="add">
<h2>Enter the Patient's Details</h2>
<label for="name">Name:</label>
<input type="text" name="name">
<label for="dob">Date of Birth:</label>
<input type="text" name="dob">
<label for="nok">Next of Kin:</label>
<input type="text" name="nok">
<label for="nok_add">Address:</label>
<input type="text" name="nok_add">
<label for="nok_phone">Phone:</label>
<input type="text" name="nok_phone">
<label for="doa">Date of Admission:</label>
<input type="text" name="dob">
<label for="allergies">Allergies:</label>
<input type="text" name="allergies">
<?php if(!empty($message)): ?>
<p><?= $message ?></p>
<?php endif; ?>
<input type="submit">
</form>
<br>
</div>
</div>
<!-- // [START footer] -->
<footer>
<div class="container">
<p>Copyright Ghyll Court Residental Home 2017</p>
</div>
</footer>
<!-- // [END footer] -->
</script>
<script type="text/javascript">
function init() {
window.matchMedia("(max-width: 600px)").addListener(hitMQ);
}
function hitMQ(evt) {
sampleCompleted("GettingStarted-ContentWithStyles");
}
init();
</script>
</body>
</html>
推荐答案
您的if语句检查!empty($_POST['doa'])，但是您的表单不包含doa:
Your if-statement checks !empty($_POST['doa']), but your form does not contain a doa:
<label for="doa">Date of Admission:</label>
<input type="text" name="dob">
此<input>应该应该具有name="doa"而不是dob.
This <input> should probably have name="doa" instead of dob.
这篇关于HTML/PHP无法更新SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
