php - 从数据库中填充选中的单选按钮

Question

我有两组单选按钮，即两个不同的上传表单输入。现在我正在尝试制作编辑页面，但我一直坚持在上面填充已经选中的按钮。

首先我从数据库中选择信息

<?php
$sql = "
        SELECT *
        FROM document_upload
        WHERE upload_id = ?                         
        LIMIT 1";

$q = $pdo->prepare($sql);
$q->execute(array($upload_id));
$data = $q->fetch(PDO::FETCH_ASSOC);

$title = $data['upload_title'];
$category = $data['category'];
$skills = $data['skills'];
$description = $data['description']; 
?>

<div class="form-group">
    <label class="control-label col-sm-2" for="title">Title:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="title" id="title" value="<?php echo !empty($title)?$title:'';?>">
        </div>
</div>
<div class="form-group">
    <label class="control-label col-sm-2" for="description">Description:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="description" id="description" value="<?php echo !empty($description)?$description:'';?>">
        </div>
</div>
<div class="form-group">
    <label class="control-label col-sm-2" for="category">Category:</label>  
    <?php
        $pdo = Database::connect();
        $sql="SELECT field_name FROM form_fields WHERE group_id=6";
        foreach ($pdo->query($sql) as $row_category){
                echo '<label class="radio-inline"><input type="radio" name="category" value="'.$row_category['field_name'].'"> '. $row_category['field_name'].'</label>';                               
        }                                               
    ?>                          
</div>  
<div class="form-group">
    <label class="control-label col-sm-2" for="skills">Skills:</label>
        <?php
            $pdo = Database::connect();
            $sql="SELECT field_name FROM form_fields WHERE group_id=7";
                foreach ($pdo->query($sql) as $row_skills){
                        echo '<label class="radio-inline"><input type="radio" name="skills" value="skills"> '. $row_skills['field_name'].'</label>';                                
                }                                               
        ?>                      
</div>

标题和描述不是问题。他们人口众多。

我不知道如何选择数据库中可用的所有单选按钮，然后检查选择了哪个。

Answer 1

使用下面的代码检查单选按钮是否存在值。

<div class="form-group">
    <label class="control-label col-sm-2" for="category">Category:</label>  
    <?php
        $pdo = Database::connect();
        $sql="SELECT field_name FROM form_fields WHERE group_id=6";
        foreach ($pdo->query($sql) as $row_category){
            $checked= (isset($category) && $category == $row_category['field_name']) ?  "checked" : "";
            echo '<label class="radio-inline"><input type="radio" name="category" value="'.$row_category['field_name'].'" "'.$checked.'"> '. $row_category['field_name'].'</label>';                               
        }                                               
    ?>                          
</div>

<div class="form-group">
    <label class="control-label col-sm-2" for="skills">Skills:</label>
        <?php
            $pdo = Database::connect();
            $sql="SELECT field_name FROM form_fields WHERE group_id=7";
                foreach ($pdo->query($sql) as $row_skills){
                    $checkedSkill = (isset($skills) && $skills == $row_skills['field_name']) ?  "checked" : "";
                    echo '<label class="radio-inline"><input type="radio" name="skills" value="'.$row_skills['field_name'].'" "'.$checkedSkill.'"> '. $row_skills['field_name'].'</label>';                                
                }                                               
        ?>                      
</div>