show data in multiple textbox in php

Question

I want to show all the names of my tb_app which is currently have (4)names stored and show it on my textboxes...can anyone help me make my code work? I'm just a beginner at programming.

current code:

<html>
<head>
<title>test</title>
</head>
<body>
<?php
include('include/connect.php');
$sql = "SELECT name FROM tb_app";
while($rows = mysql_fetch_array($sql)){
    $name = $rows['name'];
}
?>
Name List: <br />
<input type="text" value="<?php echo $name[0] ?>" /> <br />
<input type="text" value="<?php echo $name[1] ?>" /> <br />
<input type="text" value="<?php echo $name[2] ?>" /> <br />
<input type="text" value="<?php echo $name[3] ?>" /> <br />
</body>
</html>

jszobody · Accepted Answer · 2014-01-27 14:59:29Z

2

Right now you are overwriting the $name variable in each iteration of your loop. You want to treat $name as an array instead, and add an element to the array in each iteration.

Change this:

$name = $rows['name'];

To this:

$name[] = $rows['name'];

You could of course echo your textbox directly inside your while loop as well, and skip the $name variable. However it's good practice to separate your DB or business logic from your display logic, which you are (somewhat) doing. In fact I'd recommend moving your PHP code to the very top of the page, before your opening <html> tag even, and limit how much PHP you mix in with your html.

edited Jan 27, 2014 at 14:59

answered Jan 27, 2014 at 14:53

jszobody

29k6 gold badges66 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DannyThunder · Accepted Answer · 2014-01-27 14:58:01Z

0

A more dynamic way (i.e you have less or more then 4 names):

<html>
<head>
<title>test</title>
</head>
<body>
Name List: <br />
   <?php
       include('include/connect.php');
       $sql = "SELECT name FROM tb_app";

       while($rows = mysql_fetch_array($sql)){
           echo '<input type="text" value="'. $rows['name'] .'" /> <br />';
       }
   ?>
</body>
</html>

answered Jan 27, 2014 at 14:58

DannyThunder

1,0031 gold badge13 silver badges29 bronze badges

Comments

Omid Kamangar · Accepted Answer · 2014-01-27 15:02:55Z

0

You could go even further:

Change name to names:

while($rows = mysql_fetch_array($sql)){
    $names[] = $rows['name'];
}

And then

Name List:

<?php foreach ($names as $name): ?>
  <input type="text" value="<?php echo $name ?>" /> <br />
<?php endforeach; ?>

answered Jan 27, 2014 at 15:02

Omid Kamangar

5,7889 gold badges44 silver badges70 bronze badges

Collectives™ on Stack Overflow

show data in multiple textbox in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related