I have table (test) in database (dbase) that has 5 columns: idt(primary), datetime, col1, col2 and col3.
I would like to print out the data into textboxes <input type=”text” />.
This is what I have so far:
[code=php]<body>
<?php
$conn = mysql_connect(connection string works);
if (!$conn)
{
die(‘Could not connect: ‘ . mysql_error());
}
else
{
mysql_select_db(‘dbase’);
$sql = “SELECT * FROM test;”;
$result = mysql_query($sql, $conn);
echo ‘<center><table><tr><th>idt</th><th>datetime</th><th>col1</th><th>col2</th><th>col3</th></tr>’;
$n=0;
while (($data = mysql_fetch_array($result, MYSQL_ASSOC)) !== null) {
$n=$n+1;
echo ‘<tr><td>’, ‘<input name=”Text’ & $n & ‘” type=”text” value= “‘ & $data[‘idt’] & ‘” width=”25″ />’, ‘</td>’;
$n=$n+1;
echo ‘<td>’, ‘<input name=”Text’ & $n & ‘” type=”text” value= “‘ & $data[‘datetime’] & ‘” width=”25″ />’, ‘</td>’;
$n=$n+1;
echo ‘<td>’, ‘<input name=”Text’ & $n & ‘” type=”text” value= “‘ & $data[‘col1’] & ‘” width=”25″ />’, ‘</td>’;
$n=$n+1;
echo ‘<td>’, ‘<input name=”Text’ & $n & ‘” type=”text” value= “‘ & $data[‘col2’] & ‘” width=”25″ />’, ‘</td>’;
$n=$n+1;
echo ‘<td>’, ‘<input name=”Text’ & $n & ‘” type=”text” value= “‘ & $data[‘col3’] & ‘” width=”25″ />’, ‘</td></tr>’;
}
mysqli_free_result($resulti);
echo ‘</table></center></div>’;
}
mysql_close($conn);
?>
</body>