如何在单选按钮中从数据库加载值？

dsf9zpds 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(324)

我想知道你是否能做这个功能。。。我有一个数据库，它有一个接受0或1值的“布尔”字段，我有一个html页面，其中有一个单选按钮，它的值为ok或no。我必须能够在单选按钮中加载布尔值，因此如果在数据库中，html页面上的布尔变量为1（执行select之后），如果在数据库在html页面上布尔变量为0（执行select之后），单选按钮将没有值
这是我尝试的代码：

<?php
$servername = "localhost";
$username = "progettocantiere";
$password = "";
$dbname = "my_progettocantiere";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$idAffidataria = $_GET['idAffidataria'];
$sql1 = "SELECT * FROM Affidataria WHERE idAffidataria = '{$idAffidataria}'";
    $result = $conn->query($sql1);
    $details = $result->fetch_array();
    $savedNomeCantiere = $details["nomeCantiere"];
    $savedAddettoSicurezza = $details["addettoSicurezza"];
    $savedMailAffidataria = $details["mailAffidataria"];
    $savedContrattoDiAppalto = $details["contrattoDiAppalto"]; // <--- BOOLEAN <----
$result1 = $conn->query($sql1);
echo($nomeCantiere);
?>
<html>
<body>
<table>
 <tr>
    <td colspan="2" bgcolor="#CDECFD" style="font-weight: bold">Cantiere</td>
    <td colspan="4" bgcolor="#CDECFD"><input type="text" class="form-control" style="width: 100%;" name="cantiereAffidataria" id="cantiereAffidataria" value="<?php echo $savedNomeCantiere; ?>"/>&nbsp;</td>
  </tr>
  <tr>
  <td colspan="2" bgcolor="#CDECFD" style="font-weight: bold">ContrattoDiAppalto</td>
  <td bgcolor="#B35556"><form action="">
       OK <input type="radio" name="contrattoDiAppalto" id="contrattoDiAppalto" value="<?php echo $savedContrattoDiAppalto; ?>" onchange="color(this)" /> <BR>
        NO  <input type="radio" name="contrattoDiAppalto" id="contrattoDiAppalto" value="<?php echo $savedContrattoDiAppalto; ?>" onchange="color(this)" checked/>
</form></td>
  </tr>
</table>

换句话说，我必须能够改变单选按钮，根据数据提供的选择对数据库
我试着通过 <?php echo $savedContrattoDiAppalto; ?>" 但我怀疑这是对的。。我没什么主意了。。有人能帮我吗？

mysql php Database JavaScript Html

来源：https://stackoverflow.com/questions/52627474/how-to-load-a-value-from-database-in-radio-button

1条答案

按热度按时间

guz6ccqo1#

生成变量 $checked = 'checked' 然后设置一个条件来检查它是1还是0

$checked = 'checked';
if($savedContrattoDiAppalto != 1){
    $checked = ''; // Default is checked, if it isn't 1 then it's empty and will not check your radio.
}

并将该变量应用于输入属性。

<input type="radio" name="contrattoDiAppalto" id="contrattoDiAppalto" 
value="<?php echo $savedContrattoDiAppalto; ?>" onchange="color(this)" $checked/>

完整代码应为：

<?php
$servername = "localhost";
$username = "progettocantiere";
$password = "";
$dbname = "my_progettocantiere";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$idAffidataria = $_GET['idAffidataria'];
$sql1 = "SELECT * FROM Affidataria WHERE idAffidataria = '{$idAffidataria}'";
    $result = $conn->query($sql1);
    $details = $result->fetch_array();
    $savedNomeCantiere = $details["nomeCantiere"];
    $savedAddettoSicurezza = $details["addettoSicurezza"];
    $savedMailAffidataria = $details["mailAffidataria"];
    $savedContrattoDiAppalto = $details["contrattoDiAppalto"];
    $checked = 'checked';             
    if($savedContrattoDiAppalto != true){
        $checked = ''; // if not true then not checked
    }    
$result1 = $conn->query($sql1);
echo($nomeCantiere);
?>
<html>
<body>
<table>
 <tr>
    <td colspan="2" bgcolor="#CDECFD" style="font-weight: bold">Cantiere</td>
    <td colspan="4" bgcolor="#CDECFD"><input type="text" class="form-control" style="width: 100%;" name="cantiereAffidataria" id="cantiereAffidataria" value="<?php echo $savedNomeCantiere; ?>"/>&nbsp;</td>
  </tr>
  <tr>
  <td colspan="2" bgcolor="#CDECFD" style="font-weight: bold">ContrattoDiAppalto</td>
  <td bgcolor="#B35556"><form action="">
       OK <input type="radio" name="contrattoDiAppalto" id="contrattoDiAppalto" value="<?php echo $savedContrattoDiAppalto; ?>" onchange="color(this)"  $checked/> <BR>
        NO  <input type="radio" name="contrattoDiAppalto" id="contrattoDiAppalto" value="<?php echo $savedContrattoDiAppalto; ?>" onchange="color(this)" $checked/>
</form></td>
  </tr>
</table>

展开查看全部

赞(0）回复(0）举报 2021-06-20

我来回答

如何在单选按钮中从数据库加载值？

1条答案

相关问题

热门标签

最新问答