mysql values to display on PHP form

[ddtpmyra]

Hi,

Im looking for sample code that will retrieve the values from mysql query. Most of my code has the "while($row = mysql_fetch_ass oc($result))" and that will display the values by rows. How about the display are in indent format?


Belowi s the input text box that I wanted to show the values from mysql query. Anybody can show me how not using the while function?

	
<td>Total English</td>
      <Input type = 'text' Name ='TotalSTSEnglish' value='0' >
<td>Total Spanish</td> 
      <Input type = 'text' Name ='TotalSTSEnglish' value='0' >

[ak1dnar]

The while() loop will keep fetching new rows until mysql_fetch_ass oc() returns FALSE, which means there are no more rows to fetch.
So if you only need to get one row from your mysql query (assuming your query returns only one row) here is the solution.

<?php
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("books");
$result = mysql_query("select * from books "); // You can put your where clause here 
$row = mysql_fetch_assoc($result);
$book_name =  $row['name'];
?>

Now print the variables inside the value attribute on the input box. hope this will help. Thanks

[Dormilich]

you may also look at PDO's fetch*() methods.

[ddtpmyra]

Thanks ak1dnar it works!
I appreciate the knowledge shared :)

The while() loop will keep fetching new rows until mysql_fetch_ass oc() returns FALSE, which means there are no more rows to fetch.
So if you only need to get one row from your mysql query (assuming your query returns only one row) here is the solution.

<?php
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("books");
$result = mysql_query("select * from books "); // You can put your where clause here 
$row = mysql_fetch_assoc($result);
$book_name =  $row['name'];
?>

Now print the variables inside the value attribute on the input box. hope this will help. Thanks

[ddtpmyra]

A follow-up question on this topic... now I have a check box but Im having problem to pull the information. Inside the talbe the field value = 1, how come it wont display?

<table width='80%' border='0' summary=''>";
	$result = mysql_query("select Total from recap where Cal_ID={$id} and category='Target Focus'  ");
	$row = mysql_fetch_assoc($result);
	$Total =  $row['Total'];
	echo "<td><input type = 'checkbox' name ='Community' value='$row[Total]'/>Disabled Community </tr></td>";
	echo "<tr>";							
echo "</table>

[ak1dnar]

check box values doesn't appear as the HTML output , did you check the generated html source from the browser view source option ?

[ddtpmyra]

I check my sql and the value is 1. And yet still no check apeared.


PHP

$result = mysql_query("select Total from tblevent_recap where Cal_ID={$id} and category='Target Focus' and Name ='Disabled Community' ");
$row= mysql_fetch_assoc($result);
if(mysql_num_rows($result)!=0) {
echo "<td><input type = 'checkbox' name ='DisabledCommunity' value='checked'>Disabled Community </tr></td>";
echo "<tr>";  }
else 
{ 
echo "<td><input type = 'checkbox' name ='DisabledCommunity' value=''>Disabled Community </tr></td>";
echo "<tr>";
}

I veiwed the HTML

><input type = 'checkbox' name ='DisabledCommunity' value='checked'>Disabled Community </tr></td><tr><td>

[Markus]

The correct attribute is 'checked'.

<input type='checkbox' checked='checked' />

[ak1dnar]

I think you may better to follow these tutorials on HTML form markup.

http://www.w3schools.com/html/html_forms.asp