我试图有我的表单数据存储在mysql数据库。我希望用户输入或点击的所有内容都存储在那里。我能够有我的文本字段存储在mysql成功。我有麻烦弄清楚如何发送多个复选框,单选按钮和下拉列表mysql,并有它存储在那里。我都不知道从何说起。请帮助。
也可以参考这个。
php和mysql -发送复选框,单选按钮和下拉菜单结果从用户到mysql数据库,并存储在那里
session_start();
function logged_in() {
return isset($_SESSION['user_id']);
}
function confirm_logged_in() {
if (!logged_in()) {
redirect_to("contact info.php");
}
}
// Database Constants
define('DB_SERVER', 'localhost');
define('DB_USER', 'root');
define('DB_PASS', '');
define('DB_NAME', 'wer_application');
function check_required_fields($required_array) {
$field_errors = array();
foreach($required_array as $fieldname) {
if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && !is_numeric($_POST[$fieldname]))) {
$field_errors[] = $fieldname;
}
}
return $field_errors;
}
function check_max_field_lengths($field_length_array) {
$field_errors = array();
foreach($field_length_array as $fieldname => $maxlength ) {
if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength) { $field_errors[] = $fieldname; }
}
return $field_errors;
}
function display_errors($error_array) {
echo "<p class='"errors'">";
echo "Please review the following fields:<br />";
foreach($error_array as $error) {
echo " - " . $error . "<br />";
}
echo "</p>";
}
// START FORM PROCESSING
if (isset($_POST['submit'])) { // Form has been submitted.
$errors = array();
// perform validations on the form data
$required_fields = array('id','student_gender', 'student_session_one_preference', 'student_session_two_preference',
'waldron_scholarship', 'jesse_van_anterp_huyck_scholarship', 'edward_raney_scholarship', 'school_type',
'student_statemenet_consent_check_box', 'guardian_statemenet_consent_check_box', 'waiver');
$errors = array_merge($errors, check_required_fields($required_fields, $_POST));
$errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
//Captures what is typed by the user
if(!empty($_POST) && isset($_POST["submit-btn"])){
$student_gender = isset($_POST["student_gender"]) ? $_POST["student_gender"] : "";
$student_session_one_preference = isset($_POST["student_session_one_preference"]) ? $_POST["student_session_one_preference"] : "";
$student_session_two_preference = isset($_POST["student_session_two_preference"]) ? $_POST["student_session_two_preference"] : "";
$waldron_scholarship = isset($_POST["waldron_scholarship"]) ? $_POST["waldron_scholarship"] : "";
$jesse_van_anterp_huyck_scholarship = isset($_POST["jesse_van_anterp_huyck_scholarship"]) ? $_POST["jesse_van_anterp_huyck_scholarship"] : "";
$edward_raney_scholarship = isset($_POST["edward_raney_scholarship"]) ? $_POST["edward_raney_scholarship"] : "";
$school_type = isset($_POST["school_type"]) ? $_POST["school_type"] : "";
$student_statemenet_consent_check_box = isset($_POST["student_statemenet_consent_check_box"]) ? $_POST["student_statemenet_consent_check_box"] : "";
$guardian_statemenet_consent_check_box = isset($_POST["guardian_statemenet_consent_check_box"]) ? $_POST["guardian_statemenet_consent_check_box"] : "";
$waiver = isset($_POST["waiver"]) ? $_POST["waiver"] : "";
//sends the data from the form into our database we made with mysql.
$sql = "INSERT INTO nature VALUES ('id','$student_gender', '$student_session_one_preference', '$student_session_two_preference',
'$waldron_scholarship', '$jesse_van_anterp_huyck_scholarship', '$edward_raney_scholarship', '$school_type',
'$student_statemenet_consent_check_box', '$guardian_statemenet_consent_check_box', '$waiver')";
if(!mysql_query($sql)){
die('Error: ' . mysql_error());
}
}
<html>
<head>
<title>WER Application Packet</title>
<link href="stylesheets/public.css" media="all" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="header">
<h1>WER Application Packet</h1>
</div>
<div id="main">
<table id="structure">
<tr>
<td id="page">
<?php if (!empty($message)) {echo "<p class='"message'">" . $message . "</p>";} ?>
<?php if (!empty($errors)) { display_errors($errors); } ?>
<form action="contact info.php" method="post">
<form method="POST">
<input type="radio" name="student_gender" value="Male">Male<br>
<input type="radio" name="student_gender" value="Female">Female<br>
<select name="student_session_one_preference">
<option value="Session 1">Session 1: June 30 - July 21</option>
<option value="Session 2">Session 2: July 28 - August 18</option>
</select> <br/>
Preference 2:
<select name="student_session_two_preference">
<option value="Session 1">Session 1: June 30 - July 21</option>
<option value="Session 2">Session 2: July 28 - August 18</option>
</select>
<input type="checkbox" name="waldron_scholarship" value="Waldron Scholarship">Waldron Scholarship<br/>
<input type="checkbox" name="jesse_van_anterp_huyck_scholarship" value="Jesse Van Anterp Huyck Scholarship">Jesse Van Anterp Huyck Scholarship<br/>
<input type="checkbox" name="edward_raney_scholarship" value="Edward Raney Scholarship">Edward Raney Scholarship<br/>
<select name="school_type">
<option value="Public">Public</option>
<option value="Private">Private Parochial</option>
<option value="Other">Other</option>
</select>
<input type="radio" name="waiver" value="">I waive any right of access that I may have to information submitted by my referee<br>
<input type="radio" name="waiver" value="">I do not waive any right of access that I may have to information submitted by my referee<br>
<input type="checkbox" name="student_statement_consent_check_box" value="Agree">By checking this box, the student acknowledges <br/> that they have read the statement <br/> of consent and agrees with it.<br>
<input type="checkbox" name="guardian_statement_consent_check_box" value="Agree">By checking this box, the guardian acknowledges <br/> that they have read the statement <br/> of consent and agrees with it.<br>
<input type="submit" value="Submit" name="submit-btn">
</form>
</td>
</tr>
</table>
</div>
<div id="footer"></div>
</body>
</html>
<?php
// 5. Close connection
mysql_close($connection);
?>
CREATE TABLE nature(
ID int NOT NULL auto_increment,
student_gender varchar(6),
student_session_one_preference varchar(30),
student_session_two_preference varchar(30),
waldron_scholarship tinyint,
jesse_van_anterp_huyck_scholarship tinyint,
edward_raney_scholarship tinyint,
school_type varchar(25),
student_statemenet_consent_check_box tinyint,
guardian_statemenet_consent_check_box tinyint,
waiver tinyint,
PRIMARY KEY(ID)
);
试着运行下面的PHP脚本,以发现当您选择和省略某些表单元素时,会发送什么(以及不会发送什么)。
<?php
if (sizeOf($_POST) > 0) print_r($_POST);
?>
<form method="POST" action=".">
<input type="checkbox" name="checkbox" id="checkbox" /> <label for="checkbox">Checkbox</label>
<input type="radio" name="radio" value="1" id="radio_1" /> <label for="radio_1">Radio 1</label>
<input type="radio" name="radio" value="2" id="radio_2" /> <label for="radio_2">Radio 2</label>
<select name="select">
<option value="1">1</option>
<option value="2">2</option>
</select>
<input type="submit" />
</form>
您将看到,如果一个复选框被选中,相应的表单POST值将被设置为"on"。单选按钮将被设置为它的值,select也一样。
请注意,当发送到action
页面时,所有表单元素都由它们的name
键。
您的弃权无线电输入都缺少值,因此$_POST['弃权']将始终为空。修改如下:
<input type="radio" name="waiver" value="yes">
<input type="radio" name="waiver" value="no">
你的复选框字段可以像这样设置变量(只要检查是否设置):
$jesse_van_anterp_huyck_scholarship = isset($_POST["jesse_van_anterp_huyck_scholarship"]) ? 1 : 0;
仅供参考:您的varchar(30)字段可能不够长,无法存储像"Jesse Van Anterp Huyck Scholarship"这样的字符串