如何在php中将数据库中的数据显示为文本 [英] How to show data from database into text in php

问题描述

当我按下选择按钮时，我希望将数据库中的数据显示到文本框中，但是我坚持下去，我接下来要做什么，在此先感谢

i want to show data from database into text box when i press select Button, but i am stuck on it , what i do next , Thanks in Advance

BootStrapCode

<td><label class="control-label" for="finame" id="myID1" >FIRST NAME</label></td>
<td><input type="text" class=" form-control2 input-sm text-uppercase"name="firstname" onkeypress="return allCharacter(event);" ></td>
<td><label  class="control-label" for="mname">MIDDLE NAME</label></td>
<td><input type="text" class=" form-control2 input-sm text-uppercase" name="middlename"></td>
<td><label  class="control-label" for="lname" id="myID2">LAST NAME</label></td>
<td><input type="text" class="  form-control2 input-sm text-uppercase" name="lastname" onkeypress="return allCharacter(event);"></td>

php Code

if (isset($_POST['select_button'])) {
  $qrydatabind1 = 'SELECT ecode, first_name, middle_name, last_name, father_name, mother_name,
              number_of_dependents, dob, gender, identification_mark, marital_status, spouse_name, mobile_number,
              email_id, adhar_id, pan_number, passport_number, tin_number, dl_number FROM USER_MASTER';
  $results1 = mysql_query($qrydatabind1) or die(mysql_error());

  while ($row = mysql_fetch_array($results1)) {
    echo '<td><input  type="text" value="{$row["first_name"]}" ></td>';
  }
}

推荐答案

那里是代码中的错误。将while循环更改为此循环：

There is a bug in the code. Change the while loop to this one:

while ($row = mysql_fetch_array($results1)) {
    echo '<td><input  type="text" value="' . $row["first_name"] . '" ></td>';
}

这篇关于如何在php中将数据库中的数据显示为文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！