单选按钮php mysql

Question

I have a problem with the radio button, I can edit and insert but it does not show me anything. what I'm doing wrong? Thank you in advance for your help

radio button

<input type="radio" name="visible" value="0"<?php 
                if ($id['visible'] == 0) { echo " checked"; } 
                ?> /> {no}
                &nbsp;
                <input type="radio" name="visible" value="1"<?php 
                if ($id['visible'] == 1) { echo " checked"; } 
                ?> /> {yes}

id

enter if(isset($_POST['id'])){
$id=$_POST['id'];
}else{
$id=$_GET['id'];
//echo $id;
} here



@$query  = "SELECT * FROM photographs WHERE id = '$id' ";
    //pokazuje co zostalo zmienione
    echo $query;

    $result = mysqli_query($connection, $query);
    if (!$result) {
        die("zapytanie sie nie powiodlo");
    }
    $row = mysqli_fetch_array($result);

?>

Answer 1

Your array is $row so $id['visible'] should be changed to $row['visible'].

<input type="radio" name="visible" value="0"<?php 
                if ($row['visible'] == 0) { echo " checked"; } 
                ?> /> {no}
                &nbsp;
<input type="radio" name="visible" value="1"<?php 
                if ($row['visible'] == 1) { echo " checked"; } 
                ?> /> {yes}

Side note: your code is vulnerable to SQL Injection. Consider switching to a Prepared Statement.