Show label data in radio instead of text

Question

I have this appointment and I show it this way:

<?php 
if(isset($_POST['data']))
{
$servername = "xxx.xxx.x.xx";
$username = "xxxxx";
$password = "xxxxxxxx";
$dbname = "xxxxxxx";

$conn = new mysqli($servername, $username, $password, $dbname);
$conn->set_charset('utf8');

$inicio = mysqli_real_escape_string($conn, $_POST['data']);

$sql = "SELECT `regOratorio`.`DataEntrada`,
`regOratorio`.`Utente`,
`regOratorio`.`Estado`,
`regOratorio`.`Observacao`,
`regOratorio`.`Colaborador`
FROM `centrodb`.`regOratorio` WHERE DataEntrada = '$inicio'";

 $result=mysqli_query($conn, $sql);

if (!$result) {
  echo 'There are no results for your search';
  } else {
 echo '<form name="customer_details" action="" method="POST" onsubmit="return alguma_funcao()">';    
 }
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{

echo "<fieldset>";
echo "<table cellspacing='10'>";
 echo "<tr>";
echo "<td>";   

echo "<label>Utente</label>"; 
echo "<input id='' type='text' value='".$row['Utente']."'";  

echo "<label>Estado</label>"; 
echo "<input id='' type='text' value='".$row['Estado']."'";  

echo "<label>Observacao</label>"; 
echo "<input type='text' value='".$row['Observacao']."'";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</fieldset>";

echo "<fieldset>";
echo "<table cellspacing='10'>";
echo "<tr>";
echo "<td>";
echo "<input type='text' value='".$row['Colaborador']."'";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</fieldset>";

 }
echo "</form>";
mysqli_close($conn);
} 
else
{
?>

<form action="" method="post">
  <label>Enter Student Number:</label>
  <input name="data" type="date" placeholder="Type Here">
  <br>
  <br>
  <input type="submit" value="Enter">
</form>

<?php
}
?>

The label of State is as type='text', but wanted him to show the query data as type='radio', where I have two states (Present and Absent), I want you to learn both and select what was recorded in the table and I want to be able to edit that field (state) and that of Observing. It is possible?

Answer 1

Well come on,

just change this code of yours:

echo "<label>Estado</label>"; 
echo "<input id='' type='text' value='".$row['Estado']."'";  

therefore:

echo "<label>Estado</label>"; 
echo "<input type='radio' value='presente' " . ( ($row['Estado']=='presente') ? 'checked' : '' ) ."> Presente";
echo "<input type='radio' value='ausente' " . ( ($row['Estado']=='ausente') ? 'checked' : '' ) ."> Ausente";

Php allows you to write an if like this:

($row['Estado'] == ausente)?
 'checked' : ''>Ausente"

which is saying if your state ($Row['State']) is equal to absent, then mark this radio as checked if you don’t put anything.

I think it’s worth showing you what a select combo would look like.

A visual example of what it would look like with select and radio

Estados com select: <br>
<select name="estados">
    <option value="sp">São Paulo</option>
    <option value="rj">Rio de Janeiro</option>
    <option value="mg">Minas Gerais </option>
</select>

<br>
<br>

Estados radio: <br>
<input type="radio" name="sp" value="sp" checked>São Paulo<br>
<input type="radio" name="rj" value="rj">Rio de Janeiro<br>
<input type="radio" name="mg" value="mg"> Minas Gerais