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_assoc($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?

Expand|Select|Wrap|Line Numbers

  
<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_assoc() 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.

Expand|Select|Wrap|Line Numbers

 
<?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 :)

Quote:

Originally Posted by ak1dnar

The while() loop will keep fetching new rows until mysql_fetch_assoc() 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.

Expand|Select|Wrap|Line Numbers

 
<?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?

Expand|Select|Wrap|Line Numbers

 
<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

Expand|Select|Wrap|Line Numbers

 
$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

Expand|Select|Wrap|Line Numbers

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

Markus

The correct attribute is 'checked'.

Expand|Select|Wrap|Line Numbers

<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

mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

re: mysql values to display on PHP form

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about