mysql values to display on PHP form

ddtpmyra · #1 June 18th, 2009, 12:53 AM

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 · #2 June 18th, 2009, 04:36 AM

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 · #3 June 18th, 2009, 06:34 AM

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

ddtpmyra · #4 June 23rd, 2009, 12:51 AM

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 · #5 June 24th, 2009, 01:11 AM

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 · #6 June 25th, 2009, 07:57 AM

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

ddtpmyra · #7 June 25th, 2009, 05:23 PM

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 · #8 June 25th, 2009, 06:53 PM

The correct attribute is 'checked'.

Expand|Select|Wrap|Line Numbers

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

ak1dnar · #9 June 26th, 2009, 04:57 AM

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

/bytes/development

/bytes/it

/bytes/about