How to import data from bank to form field

Question

How to import data from bank to form field

Navigation

#1 by (3 votes)
#2 by (1 votes)

0

I have a course management system where the user has access to a table with all classes of all courses and chooses to enroll in one.

When the user is going to register, he / she will open a form with the fields that he / she must fill out and the field with the name of the formation and group, however, these fields I want that already are filled according to the formation and class of the line of the table that he clicked on.

The query table:

<h1 style="
text-align: center;
height: 7;
margin-top: 150;
margin-bottom: 70
margin-top:130;
"> Consulta de turmas </h1>
<form method="post" action="selectT.php">
  <div class="col-lg-3">
    <div class="form-group">
      <label for="NOME">Nome: </label>
      <input class="form-control" id="NOME" placeholder="Nome da turma" name="NOME">
    </div>
  </div>
  <div class="col-lg-3">
    <div class="form-group">
      <label for="DATA">Data</label>
      <input class="form-control" id="DATA" placeholder="Data da formação" name="DATA">
    </div>
  </div>
  <div class="col-lg-3">
    <div class="form-group">
      <label for="LOCAL">Local: </label>
      <select class="form-control" id="LOCAL" name="LOCAL">
        <option>PR</option>
        <option>PL</option>
        <option>SP</option>
        <option>RJ</option>  
        <option>FR</option>
      </select>
    </div>
  </div>
  <button type="submit" class="btn btn-primary" style="margin-top: 22;">Buscar</button>
</form>

<?php
//Conexão e consulta ao Mysql
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('db_formacao') or die(mysql_error());
$qry = mysql_query("select * from turmas");

//Pegando os nomes dos campos
$num_fields = mysql_num_fields($qry);//Obtém o número de campos do resultado

for($i = 0;$i<$num_fields; $i++){//Pega o nome dos campos
  $fields[] = mysql_field_name($qry,$i);
}

//Montando o cabeçalho da tabela
$table = '<table class="table table-hover table-inverse" style="margin-top:50;background-color: #37444a; color:lightgrey;"> <tr>';

for($i = 0;$i < $num_fields; $i++){
  $table .= '<th>'.$fields[$i].'</th>';
}

//Montando o corpo da tabela
$table .= '<tbody style="
  background-color: #86979e;
  color: #37444a;    
">';
while($r = mysql_fetch_array($qry)){
  $table .= '<tr>';
  for($i = 0;$i < $num_fields; $i++){
    $table .= '<td>'.$r[$fields[$i]].'</td>';
  }

  // Adicionando botão de exclusão
  $table .= '<td><form action="inscricao.php" method="post">'; //formulário com método post que vai para deleteF.php
  $table .= '<input type="hidden" name="ID" value="'.$r['ID'].'">';
  $table .= '<button class="btn btn-primary">Inscreva-se</button>'; //aqui está o seu botão
  $table .= '</form></td>';
}

//Finalizando a tabela
$table .= '</tbody></table>';

//Imprimindo a tabela
echo $table;

?>

The application form:

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db_formacao";

$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT NOME FROM turmas";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    $row = $result->fetch_assoc(); 
}
?>

<div class="container">
    <div class="row">
        <div class="col-lg-12 text-center">
            <h1 style="
                margin-top:100px;">Inscrição</h1>
            <p> </p>
            <p class="lead"></p>
            <ul class="list-unstyled">
                <form id="cadastro" method="post" action="banco/updateP.php" style="
                    text-align: left;
                    margin-top:50px;">
                    <div class="col-lg-12">
                        <div class="form-group" style="
                    text-align: left;">
                            <label  for="FORMACAO">Formação: </label>
                            <input  type="text" required class="form-control" id="FORMACAO" name="FORMACAO" value="<?=$row['nome']?>">
                         </div>
                    </div>
                    <div class="col-lg-12">
                        <div class="form-group" method="post" style="
                    text-align: left;">
                            <label  for="TURMA">Turma: </label>
                            <input  type="text" required class="form-control" id="TURMA" name="TURMA">
                         </div>
                    </div>
                    <div class="col-lg-12">
                        <div class="form-group" method="post" style="
                    text-align: left;">
                            <label  for="COLABORADOR">Colaborador: </label>
                            <select  class="form-control" id="COLABORADOR" name="COLABORADOR">
                                <?php

                                ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-lg-12">
                        <div class="form-group" method="post" style="
                    text-align: left;">
                            <label  for="PREVISTO">Status: </label>
                            <input  type="text" required class="form-control" id="PREVISTO" name="PREVISTO" value="Previsto">
                         </div>
                        <div class="form-check form-check-inline disabled">
                            <label class="form-check-label">
                                <input class="form-check-input" type="radio" name="STATUS" id="STATUS" value="Realizado" disabled> Realizado
                            </label>
                        </div>
                        <div class="">
                            <button type="submit" class="btn btn-primary btn-lg btn-block">Salvar</button>
                        </div>
                    </div>
                </form>
            </ul>
        </div>
    </div>
</div>

The query:

Theform:

php mysql

asked by anonymous 25.08.2017 / 15:31

2 answers

3

For you to set an initial value to form fields, you follow these patterns:

For input type text, email, password, etc.

Defines the value by the value attribute. Example:

<input type="text" name="nome" value="João da Silva">

For input type checkbox and radio:

Defines the checked attribute for what needs to be checked. Example:

<input type="radio" name="sexo" value="Masculino" checked="checked">
<input type="radio" name="sexo" value="Feminino">

For textarea:

Just put the content inside the tag. Example:

<textarea name="mensagem">Lorem ipsun sit dolor omet</textarea>

To select:

Defines the selected attribute for the option that should already be selected, eg:

<select name="cidade">
    <option value="Rio de Janeiro">Rio de Janeiro</option>
    <option value="São Paulo" selected="selected">São Paulo</option>
    <option value="Curitiba">Curitiba</option>
</select>

Here is an example form:

body {
  font-family: sans-serif;
}
label {
  display: block;
}
.radio-group {
  display: block;
}
.radio-group label {
  display: inline;
}

<form>
  <p>
    <label for="nome">Nome:</label>
    <input type="text" id="nome" name="nome" value="João da Silva">
  </p>
  <p>
    <label>Sexo:</label>
    <span class="radio-group">
      <input type="radio" id="masculino" name="sexo" value="Masculino" checked="checked">
      <label for="masculino">Masculino</label>
      <input type="radio" id="feminino" name="sexo" value="Feminino">
      <label for="feminino">Feminino</label>
    </span>
  </p>
  <p>
    <label for="mensagem">Mensagem:</label>
    <textarea id="mensagem" name="mensagem">Lorem ipsun sit dolor omet</textarea>
  </p>
  <p>
    <label for="cidade">Cidade:</label>
    <select id="cidade" name="cidade">
        <option value="Rio de Janeiro">Rio de Janeiro</option>
        <option value="São Paulo" selected="selected">São Paulo</option>
        <option value="Curitiba">Curitiba</option>
    </select>
  </p>
  <p>
    <input type="submit" value="Enviar">
  </p>
</form>

Example bringing the MySQL values through PHP:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT nome, sexo, mensagem, cidade FROM pessoas WHERE id_pessoa = 10;";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    $row = $result->fetch_assoc();

    ?>
        <form>
            <p>
                <label for="nome">Nome:</label>
                <input type="text" id="nome" name="nome" value="<?=$row['nome']?>">
            </p>
            <p>
                <label>Sexo:</label>
                <span class="radio-group">
                    <input type="radio" id="masculino" name="sexo" value="Masculino"<?php if($row['sexo'] == 'Masculino') { echo ' checked="checked"'; } ?>>
                    <label for="masculino">Masculino</label>
                    <input type="radio" id="feminino" name="sexo" value="Feminino"<?php if($row['sexo'] == 'Feminino') { echo ' checked="checked"'; } ?>>
                    <label for="feminino">Feminino</label>
                </span>
            </p>
            <p>
                <label for="mensagem">Mensagem:</label>
                <textarea id="mensagem" name="mensagem"><?=$row['nome']?></textarea>
            </p>
            <p>
                <label for="cidade">Cidade:</label>
                <select id="cidade" name="cidade">
                    <option value="Rio de Janeiro"<?php if($row['cidade'] == 'Rio de Janeiro') { echo ' checked="checked"'; } ?>>Rio de Janeiro</option>
                    <option value="São Paulo"<?php if($row['cidade'] == 'São Paulo') { echo ' checked="checked"'; } ?>>São Paulo</option>
                    <option value="Curitiba"<?php if($row['cidade'] == 'Curitiba') { echo ' checked="checked"'; } ?>>Curitiba</option>
                </select>
            </p>
            <p>
                <input type="submit" value="Enviar">
            </p>
        </form>
    <?php
} else {
    echo "0 results";
}
$conn->close();
?>

25.08.2017 / 15:40

How to convert bitcoin to real? How to cancel the enter of EditText?

score 1 · Accepted Answer

In the query table, in this section

.......................
.......................
//Montando o corpo da tabela
$table .= '<tbody style="
  background-color: #86979e;
  color: #37444a;    
">';

$table .= '<form action="inscricao.php" method="post">'; //formulário com método post que vai para deleteF.php

while($r = mysql_fetch_array($qry)){

  $table .= '<tr>';

  for($i = 0;$i < $num_fields; $i++){
    $table .= '<td>'.$r[$fields[$i]].'</td>';
  }

  // Adicionando botão de exclusão
      $table .= '<td><input type="hidden" name="ID" value="'.$r['ID'].'">';
      //$table .= "<td><input type=\"hidden\" name=\"ID\" value=\"".$r["ID"]."\">";
      $table .= '<button type="submit" class="btn btn-primary">Inscreva-se</button> </td>'; //aqui está o seu botão

  $table .= '</tr>';
}
$table .= '</form>';

//Finalizando a tabela
$table .= '</tbody></table>';

//Imprimindo a tabela
echo $table;

Changes were:

structuring the form, lines (tr and td) of the table

Specify the type of button <button type="submit"

About the type attribute of buttons

submit: The button sends the form data to the server.

button: The button has no default behavior. It may have client-side scripts associated with element events, which are triggered when the event occurs.

<button> - Mozilla Developer Network

And in the application form:

 ................
 $id=$_POST["ID"];
 $sql = "SELECT ID,NOME FROM turmas where ID='$id'";
 $result = $conn->query($sql);
 ................
 ................
 <label  for="TURMA">Turma: </label>
 <input  type="text" required class="form-control" id="TURMA" name="TURMA" value="<?=$row['ID'] ?>">