将复选框数据插入到mysql [英] Insert checkbox data to mysql
本文介绍了将复选框数据插入到mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的问题如下.这是我的 mySQL 表和 HTML 表单.我需要找出一个 PHP 代码来将复选框数据插入到 mySQL 表中.
如果复选框被选中,我想将该特定列填充为1",否则将其填充为0".
一次性添加一行.
我正在使用 2 个 PHP 文件.
1) regForm.php
<form method="get" action="regCode.php">ID:<input type="text" name="id"/></br>选择可用日期:</br>星期一 <input type="checkbox" value="monday"></br>周二 <input type="checkbox" value="tuesday"></br>星期三 <input type="checkbox" value="wednesday"></br>星期四 <input type="checkbox" value="thursday"></br>星期五 <input type="checkbox" value="friday"></br><input type="submit" value="Submit"/><br></br></html>
2) regCode.php
<body bgcolor="#FFFCC"><?php$dbhost='localhost';$dbuser='用户名';$dbpass='密码';$conn=mysql_connect($dbhost,$dbuser,$dbpass);如果(!$conn){die('无法连接'.mysql_error());}$sql="INSERT INTO available_days (星期一、星期二、星期三、星期四、星期五) VALUES()";mysql_select_db('testdb');$retval=mysql_query($sql,$conn);如果(!$retval){die('无法添加数据'.mysql_error());}$message="成功添加ID号:".mysql_insert_id();echo "<script type='text/javascript'>alert('$message'); window.location.href='regForm.php';</script>";mysql_close($conn);?></html>
解决方案
# 请在代码下方重试.#<?phpif($_SERVER['HTTP_HOST'] == 'localhost:8080') {$servername = "本地主机";$用户名 = "root";$密码 = "";$db = '测试';}$conn = mysql_connect($servername, $username, $password);如果($conn){mysql_select_db($db, $conn) or die('无法选择数据库.');}if(isset($_POST['提交'])){$monday = isset($_POST['day_name']['monday']) ?$_POST['day_name']['monday'] : 0;$tuesday = isset($_POST['day_name']['tuesday']) ?$_POST['day_name']['tuesday'] : 0;$wednesday = isset($_POST['day_name']['wednesday']) ?$_POST['day_name']['wednesday'] : 0;$thursday = isset($_POST['day_name']['thursday']) ?$_POST['day_name']['thursday'] : 0;$friday = isset($_POST['day_name']['friday']) ?$_POST['day_name']['friday'] : 0;//echo "INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."','".$wednesday."', '".$thursday."', '".$friday."')";$sql_add = mysql_query("INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')");如果(!$sql_add){die('无法添加数据'.mysql_error());}$message="成功添加ID号:".mysql_insert_id();echo "<script type='text/javascript'>alert('$message'); window.location.href='index6.php';</script>";}?><form action="<?php echo $_SERVER['PHP_SELF']; ?>"method="post" name="contact_form" enctype='multipart/form-data'><div class="form-group" ><input type="checkbox" name="day_name[monday]" value="1">Mon<br><input type="checkbox" name="day_name[tuesday]" value="1">周二<br><input type="checkbox" name="day_name[wednesday]" value="1">周三<br><input type="checkbox" name="day_name[thursday]" value="1">周四<input type="checkbox" name="day_name[friday]" value="1">周五<input name="submit" type="submit" class="btn btn-default" style="border-radius: 0px; background-color:midnightblue; box-shadow: 2px 2px 2px #888888; color: white;>
</表单>
My problem is as follows. This is my mySQL table, and HTML form. I need to findout a PHP code to insert the checkbox data to mySQL table.
If a checkbox is checked I want to fill that particular column as "1" else fill it as "0".
A single row is added in one time.
I am using 2 PHP files.
1) regForm.php
<html>
<form method="get" action="regCode.php">
ID: <input type="text" name="id"/></br>
Select Available dates: </br>
Monday <input type="checkbox" value="monday"></br>
Tuesday <input type="checkbox" value="tuesday"></br>
Wednesday <input type="checkbox" value="wednesday"></br>
Thursday <input type="checkbox" value="thursday"></br>
Friday <input type="checkbox" value="friday"></br>
<input type="submit" value="Submit"/><br></br>
</html>
2) regCode.php
<html>
<body bgcolor="#FFFCC">
<?php
$dbhost='localhost';
$dbuser='username';
$dbpass='password';
$conn=mysql_connect($dbhost,$dbuser,$dbpass);
if(!$conn)
{
die('could not connect'.mysql_error());
}
$sql="INSERT INTO available_days (monday, tuesday, wednesday, thursday, friday) VALUES
()";
mysql_select_db('testdb');
$retval=mysql_query($sql,$conn);
if(!$retval)
{
die('could not add data'.mysql_error());
}
$message="Successfully Added ID No: ".mysql_insert_id();
echo "<script type='text/javascript'>alert('$message'); window.location.href='regForm.php';</script>";
mysql_close($conn);
?>
</body>
</html>
解决方案
# Please Try again below code. #
<?php
if($_SERVER['HTTP_HOST'] == 'localhost:8080') {
$servername = "localhost";
$username = "root";
$password = "";
$db = 'test';
}
$conn = mysql_connect($servername, $username, $password);
if ($conn) {
mysql_select_db($db, $conn) or die('Could not select database.');
}
if(isset($_POST['submit'])){
$monday = isset($_POST['day_name']['monday']) ? $_POST['day_name']['monday'] : 0;
$tuesday = isset($_POST['day_name']['tuesday']) ? $_POST['day_name']['tuesday'] : 0;
$wednesday = isset($_POST['day_name']['wednesday']) ? $_POST['day_name']['wednesday'] : 0;
$thursday = isset($_POST['day_name']['thursday']) ? $_POST['day_name']['thursday'] : 0;
$friday = isset($_POST['day_name']['friday']) ? $_POST['day_name']['friday'] : 0;
//echo "INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')";
$sql_add = mysql_query("INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')");
if(!$sql_add)
{
die('could not add data'.mysql_error());
}
$message="Successfully Added ID No: ".mysql_insert_id();
echo "<script type='text/javascript'>alert('$message'); window.location.href='index6.php';</script>";
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="contact_form" enctype='multipart/form-data'>
<div class="form-group" >
<input type="checkbox" name="day_name[monday]" value="1">Mon<br>
<input type="checkbox" name="day_name[tuesday]" value="1"> Tues<br>
<input type="checkbox" name="day_name[wednesday]" value="1"> Wed<br>
<input type="checkbox" name="day_name[thursday]" value="1"> Thu<br>
<input type="checkbox" name="day_name[friday]" value="1"> Fri<br>
<input name="submit" type ="submit" class="btn btn-default" style="border-radius: 0px; background-color: midnightblue; box-shadow: 2px 2px 2px #888888; color: white;">
</div>
</form>
这篇关于将复选框数据插入到mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文