php - 将多个复选框值插入到 mySQL 表的三列中

Question

我在数据库表中有三列，想要将复选框中的 0 到 3 个值(主题)添加到这些列中。

HTML:

<ul class="checkbox" id="topicarea">
                                <li><input type="checkbox" name="topic[]" value="AG">Agriculture<br /></li>
                                <li><input type="checkbox" name="topic[]" value="ART">Art<br /></li>
                                <li><input type="checkbox" name="topic[]" value="BIO">Biological Sciences<br /></li>
                                <li><input type="checkbox" name="topic[]" value="BUS">Business<br /></li>
                                <li><input type="checkbox" name="topic[]" value="COM">Communication<br /></li>
                                <li><input type="checkbox" name="topic[]" value="IT">Information Technology<br /></li>
                                <li><input type="checkbox" name="topic[]" value="EDU">Education<br /></li>
                                <li><input type="checkbox" name="topic[]" value="ENGR">Engineering<br /></li>
                                <li><input type="checkbox" name="topic[]" value="ENVS">Environmental Science<br /></li>
                                <li><input type="checkbox" name="topic[]" value="HE">Health<br /></li>
                                <li><input type="checkbox" name="topic[]" value="LANGLIT">Language and Literature<br /></li>
                                <li><input type="checkbox" name="topic[]" value="LAW">Law<br /></li>
                                <li><input type="checkbox" name="topic[]" value="PHR">Philosophy and Religion<br /></li>
                                <li><input type="checkbox" name="topic[]" value="PHYS">Physical Science<br /></li>
                                <li><input type="checkbox" name="topic[]" value="PSY">Psychology and Counseling<br /></li>
                                <li><input type="checkbox" name="topic[]" value="RECFIT">Recreation and Fitness<br /></li>
                                <li><input type="checkbox" name="topic[]" value="CON">Skilled Trade and Construction<br /></li>
                                <li><input type="checkbox" name="topic[]" value="LIBART">Social Sciences and Liberal Arts<br /></li>
                                <li><input type="checkbox" name="topic[]" value="SOCSRV">Social Services<br /></li>
                                <li><input type="checkbox" name="topic[]" value="TRANS">Transportation<br /></li>
                                <li><input type="checkbox" name="topic[]" value="OTHER">Other<br /></li>
                            </ul>

PHP:我设置了三个变量(主题 1、2 和 3)，但我不知道将它们设置为什么。我认为他们必须循环遍历复选框并在找到值时进行设置？如何捕获 0 到 3 个检查值以便插入它们？

<?php
    include('local-connect.php');

    $fname = mysqli_real_escape_string($dbc, $_POST['firstname']);
    $lname = mysqli_real_escape_string($dbc, $_POST['lastname']);   
    $email = $_POST['email'];   
    $password = $_POST['pword'];    
    $address1 = $_POST['lineone'];  
    $address2 = $_POST['linetwo'];  
    $city = $_POST['city'];
    $state = $_POST['state'];
    $zip = $_POST['zip'];   
    $phone = $_POST['phone'];   
    $ageGroup = $_POST['agegroup'];

    $topic1 =       
    $topic2 = 
    $topic3 = 

    $bio = $_POST['bio'];
    $profilePic = $_POST['fileToUpload'];   

    $query = "INSERT INTO teachers(fname, lname, email, pword, address1, address2, city, state, zip, phone, ageGroup, topic1, topic2, topic3, bio, profilePic)" . 
             "VALUES('$fname','$lname','$email','$password','$address1','$address2','$city','$state','$zip','$phone','$ageGroup','$topic','$bio','$profilePic')";

    $result = mysqli_query($dbc, $query) or die('Unable to Connect to Database or the Registration is incomplete!');

    mysqli_close($dbc);

?>

Answer 1

您要查找的数据将位于

$_POST['topic'];

您应该能够像这样获得前三名:

$topic1 = $_POST['topic'][0];      
$topic2 = $_POST['topic'][1];
$topic3 = $_POST['topic'][2];