使用PHP将多个选择表单中的数据存储到MYSQL

Question

I am looking for help on storing data from multiple select form to MYSQL using PHP, here is my form

            <form action="" method="post">

            Choose your preferred browser
            <select name="browsers"> 
            <option value="Internet Explorer">
            <option value="Firefox">
            <option value="Chrome">
            <option value="Opera">
            <option value="Safari">
            </select>

            Choose your preferred car
            <select name="carlist">
            <option value="volvo">Volvo</option>
            <option value="saab">Saab</option>
            <option value="opel">Opel</option>
            <option value="audi">Audi</option>
            </select>

            <input type="submit">
            </form> 

Answer 1

$_POST['browser']; and $_POST['carlist']; each hold their own different value. So you can easily fetch each of their values.

$car = $_POST['carlist'];
$browser = $_POST['browser'];

Now it's just a matter of question where you wanna take it from there. F.ex. if you'd like to save it to a database;

// Just make it a standard to secure your database inputs
$car = mysqli_real_escape_string($conn, $_POST['carlist']);
$browser = mysqli_real_escape_string($conn, $_POST['browser']);

$sql = "INSERT INTO someTable (car, browser) VALUES ('".$car."', '".$browser."')";
mysqli_query($conn, $sql);

This is very simplified of course, but I hope it gives you an idea.