how to write text in textbox from database in php

Question

I have a form where I am getting values from previous page in $GET. I want to fetch around 3 different values from database and display them in textbox. How will I do it? Following is my code for getting data from database.

<?php
require_once('config.php');
$id = $_GET['id'];
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
        die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
        die("Unable to select database");
}
$query = "select question,price,sequence from questions where status = 1 and qid =".$id;
//echo $query;
$result=mysql_query($query);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
$num_rows = mysql_num_rows($result);
if($num_rows==0) {
 echo '<center><font color="red"><b>No record found!!</b></font></center>';
}
else {
$row = mysql_fetch_array($result);
echo $row['question'];
echo $row['sequence'];
echo $row['price'];
}

?>

Thanks
Pankaj

textbox as in all the values in a <textarea> or <input type="text" for each value? — Jason McCreary
– Jason McCreary, Commented Jun 2, 2011 at 18:16

Halcyon · Accepted Answer · 2011-06-02 18:15:30Z

4

<textarea><?php echo htmlentites($row['question']);?></textarea>

or

<input type="text" value="<?php echo htmlentites($row['question']);?>" />

Depending on your fancy.

answered Jun 2, 2011 at 18:15

Halcyon

57.7k10 gold badges93 silver badges131 bronze badges

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

3 Comments

pankaj Over a year ago

but I get values in an array from database. How will I add it to 3 different textboxes. Please check my code which I am using to fetch values from database.

Halcyon Over a year ago

I'm assuming $row['question'] is a string. Right now your code only fetches one record, just fetch two more records?

pankaj Over a year ago

it is getting 3 values as string $row['question'], $row['sequence'], echo $row['price']

Collectives™ on Stack Overflow

how to write text in textbox from database in php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related