如何根据我的代码将复选框数据保存到数据库中，知道吗？

Question

我已经谷歌并按照视频教程中的一些步骤操作，但似乎我在复选框中的所有数据都无法发送到数据库中。任何的想法？我对 PHP 代码完全陌生。如果能帮上忙，万分感谢<?php$sqlservername = "127.0.0.1";$sqlusername = "root";$sqlpassword = "";$sqldbname ="test";$conn = new mysqli($sqlservername, $sqlusername, $sqlpassword, $sqldbname);if($conn->connect_error){    die("Connection fail");}session_start();if(isset($_POST['li_submit'])){    $_SESSION['li_username'] = $_POST['username'];    $li_username = $_SESSION['li_username'];    }   if(isset($_POST['submit'])){$id = $username = $password = $location = $description = $employeeNo = $telephoneNo = $designation =  $place = $area = $date = $time = $taken = $management = $action = $remarks = $surveyA = "";if(isset($_POST['username'])){    $id = uniqid($prefix='u_');    $username = $_POST['username'];}if(isset($_POST['password'])){    $password = $_POST['password'];}if(isset($_POST['location'])){    $location = $_POST['location'];}if(isset($_POST['description'])){    $description = $_POST['description'];}if(isset($_POST['employeeNo'])){    $employeeNo = $_POST['employeeNo'];}if(isset($_POST['telephoneNo'])){    $telephoneNo = $_POST['telephoneNo'];}if(isset($_POST['designation'])){    $designation = $_POST['designation'];}if(isset($_POST['place'])){    $place = $_POST['place'];}if(isset($_POST['area'])){    $area = $_POST['area'];}if(isset($_POST['date'])){    $date = $_POST['date'];}if(isset($_POST['time'])){    $time = $_POST['time'];}if(isset($_POST['taken'])){    $description = $_POST['taken'];}if(isset($_POST['management'])){    $management = $_POST['management'];}if(isset($_POST['action'])){    $action = $_POST['action'];}if(isset($_POST['remarks'])){    $remarks = $_POST['remarks'];}if(isset($_POST['surveyA'])){    $surveyA = $_POST['surveyA'];    $A = implode (",",$surveyA);}

Answer 1

这只是如何获取复选框值的示例

假设这是您的复选框：

<input type="checkbox" name='lang' value="PHP"> PHP <br/> 

 and you can get by using this "$_POST['lang']".

Answer 2

试试这个

<?php

$sqlservername = "127.0.0.1";

$sqlusername = "root";

$sqlpassword = "";

$sqldbname ="test";

$conn = new mysqli($sqlservername, $sqlusername, $sqlpassword, $sqldbname);

if($conn->connect_error){

die("Connection fail");

}

session_start();

if(isset($_POST['li_submit'])){

$_SESSION['li_username'] = $_POST['username'];

$li_username = $_SESSION['li_username']; 

} 

if(isset($_POST['submit'])){

$id = $username = $password = $location = $description = $employeeNo = $telephoneNo = $designation = $place = $area = $date = $time = $taken = $management = $action = $remarks = $surveyA = "";

if(isset($_POST['username'])){

$id = uniqid($prefix='u_');

$username = $_POST['username'];

}

if(isset($_POST['password'])){

$password = $_POST['password'];

}

if(isset($_POST['location'])){

$location = $_POST['location'];

}

if(isset($_POST['description'])){

$description = $_POST['description'];

}

if(isset($_POST['employeeNo'])){

$employeeNo = $_POST['employeeNo'];

}

if(isset($_POST['telephoneNo'])){

$telephoneNo = $_POST['telephoneNo'];

}

if(isset($_POST['designation'])){

$designation = $_POST['designation'];

}

if(isset($_POST['place'])){

$place = $_POST['place'];

}

if(isset($_POST['area'])){

$area = $_POST['area'];

}

if(isset($_POST['date'])){

$date = $_POST['date'];

}

if(isset($_POST['time'])){

$time = $_POST['time'];

}

if(isset($_POST['taken'])){

$description = $_POST['taken'];

}

if(isset($_POST['management'])){

$management = $_POST['management'];

}

if(isset($_POST['action'])){

$action = $_POST['action'];

}

if(isset($_POST['remarks'])){

$remarks = $_POST['remarks'];

}

if(isset($_POST['surveyA'])){

$surveyA = $_POST['surveyA'];

$A = implode (",",$surveyA);

}

if(isset($_FILES['profile_pic'])){

$target_dir = "IMG_UPLOAD/";

$target_file = basename($_FILES['profile_pic']["name"]);

$file_type = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

$target_path = $target_dir . uniqid($prefix='img.'). "." .$file_type;

if(!move_uploaded_file($_FILES['profile_pic']['tmp_name'], $target_path)){

$target_path = "";

}

} 

$sql_insert = $conn->prepare("insert into user_info(username, password, location, description, image_path, employeeNo, telephoneNo, designation, place, area, date, time, taken, management, action, remarks, surveyA) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

$sql_insert->bind_param("sssssssssssssssss",$username, $password, $location, $description, $target_path, $employeeNo, $telephoneNo,$designation, $place, $area, $date, $time, $taken, $management, $action, $remarks, $A);

$sql_insert->execute();

$sql_insert->close();

}

$conn->close();

您不需要在查询中定义 id 因为它会在数据库中自动递增。并且还使用 $A 而不是 $surveyA。并假设这是您的复选框：PHP

，您可以使用此“$_POST['lang']”来获取。

我希望这对您的要求有所帮助

Answer 3

你应该插入$A，而不是$surveyA。$surveyA是一个包含复选框值的数组，$A是由implode().

在这里给它一个默认值：

$id = $username = $password = $location = $description = $employeeNo = $telephoneNo = $designation =  $place = $area = $date = $time = $taken = $management = $action = $remarks = $A = "";

然后在bind_param()通话中使用它。

$sql_insert->bind_param("sssssssssssssssss", $id, $username, $password, $location, $description, $target_path, $employeeNo, $telephoneNo,$designation, $place, $area, $date, $time, $taken, $management, $action, $remarks, $A);