问从表单中检索数据库php单选按钮

EN

if ($model=="Jetta") {...

$model = $_POST['model'];
if ($model=="Jetta") {

<?php
    $host = '127.0.0.1';
    $user = 'root';
   $pass = '';
   $database = 'blub';

    try { 
        $pdo = new PDO('mysql:host=' . $host . ';dbname=' . $database, $user, $pass);
    }catch(PDOException $e) {
        echo 'Could not connect to database: ' . $e->getMessage();
        exit;
    }

<?php
    include('connect.php'); //only connect once

    $sql = 'SELECT * FROM carforsale'; //default query
    $parms = array();
    $parameters = '';
    
    if (isset($_POST['model'])) {
        $sql .= ' WHERE modelName IN ({parameters})'; //adjust query when checkbox was selected
       foreach($_POST['model'] as $checkbox) {
        $parms[] = $checkbox;
        $parameters. = '?,';//forsee a placeholder for this checkbox
    }
        $parameters =      rtrim($parameters, ',');//remove last comma from ?,?,?, 
        $sql = str_replace('{parameters}', $parameters);//inject parameters when needed
    try {
        $stmt = $pdo->prepare($sql); //use PDO with prepared statements instead of mysql_query (see comment above)
        $stmt->execute($parms); //inject the model name in the parameter ? in the sql if needed
        $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    }catch(PDOException $e) {
        echo 'Query failed: ' . $e->getMessage(); //always check SQL errors
        exit;
    }
    
    $table  = '<table border="1">';
    $table .= '<tr><th>Manufacturer</th><th>Model</th><th>Price</th></tr>';
    foreach($rows as $row) {
            $table .= '<tr>';
            $table .= '<td>'. $row['manufacturerName'].' </td><td>'.$row['modelName'].'</td><td>'.$row['acquisitionPrice'].'</td>';
            $table .= '</tr>';
    }
    $table .= '</table>';
?>
<!DOCTYPE html>
<html>
    <head>
        <title>Cars</title>
    </head>
    <body>
        <form action="#" method="POST">
            <fieldset>
                <input type="checkbox" name="model[]" value="Jetta" />Jetta
                <input type="checkbox" name="model[]" value="Laguna" />Laguna
                <input type="checkbox" name="model[]" value="Focus" />Focus
                <input type="checkbox" name="model[]" value="Tico" />Tico
                <input type="checkbox" name="model[]" value="Avensis" />Avensis
                
                <input type="submit" name="submit" value="Register" /> </div>   
                <input type="hidden" name="submitted" value="TRUE"/>
            </fieldset>
        </form>
        <?= $table ?>
    </body>
</html>