单选按钮php mysql

问题描述：

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 enter image description here

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}

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);

?>

我的单选按钮有问题，我可以编辑和插入，但它没有显示任何内容。我做错了什么？提前感谢您的帮助 p>

单选按钮 p>

 ＆lt; input type =“radio”name =“visible”value =“0”＆lt;？php 
 if（$ id ['visible'] =  = 0）{echo“checked”;  } 
？＆gt;  /＆GT;  {no} 
＆amp; nbsp; 
＆lt; input type =“radio”name =“visible”value =“1”＆lt;？php 
 if（$ id ['visible'] == 1）{echo  “检查”;  } 
？＆gt;  /＆GT;  {是} 
  code>  pre> 
 
  id  p> 
 
 
 输入if（isset（$ _ POST ['id']））{  
 $ id = $ _ POST ['id']; 
} else {
 $ id = $ _ GET ['id']; 
 // echo $ id; 
}这里
 
 
 
 
 
 
  n @ $ query =“SELECT * FROM pictures WHERE id ='$ id'”; 
 // pokazuje co zostalo zmienione 
 echo $ query; 
 
 $ result = mysqli_query（$ connection，$ query）; \  n if（！$ result）{
 die（“zapytanie sie nie powiodlo”）; 
} 
 $ row = mysqli_fetch_array（$ result）; 
 
？＆gt; 
  code>  pre  > 
  div>

答

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.

单选按钮php mysql

相关推荐