load checkboxes,testboxes on the fly

@Michel_v_DuijseFeb 27.2004 — #I'll skip the database part here, if you need that as well, let meknow.

What you can do, is loop through a sql resultset and create a textbox/checkbox andso for every row you have.

You'll have to write the html code for the textbox inside the loop.

Here an example, to create a textbox:

[code=php] 
 //get the fieldcount
 $num_fields = mysql_num_fields($result);
 while ($row = mysql_fetch_array($result)) {
 //loop through all fields
 for ($i = 0; $i < $num_fields; $i++) {
 //get field name
 $fldName =  mysql_field_name($result, $i)];
 //get field value
 $fldValue = $row[$fldName];
 //create html string
 $html = $fldName . ": " . "<input type="text" name="" . $fldName . "" value="" . $fldValue . ""><br><br>";
 echo $html;
 }
 } ; 
 
 [/code]

@mikeyzcauthorMar 01.2004 — #[i]Originally posted by Michel_v_Duijse [/i]

[B]I'll skip the database part here, if you need that as well, let meknow.

What you can do, is loop through a sql resultset and create a textbox/checkbox andso for every row you have.

You'll have to write the html code for the textbox inside the loop.

Here an example, to create a textbox:

[code=php] 
 //get the fieldcount
 $num_fields = mysql_num_fields($result);
 while ($row = mysql_fetch_array($result)) {
 //loop through all fields
 for ($i = 0; $i < $num_fields; $i++) {
 //get field name
 $fldName =  mysql_field_name($result, $i)];
 //get field value
 $fldValue = $row[$fldName];
 //create html string
 $html = $fldName . ": " . "<input type="text" name="" . $fldName . "" value="" . $fldValue . ""><br><br>";
 echo $html;
 }
 } ; 
 
 [/code]

[/B][/QUOTE]

awsome..thanks for the help. I'm basically taking this medical laboratory software and making a web based version. the software will be pulling up patient info then ordering blood tests for them, which is why I'll need to create multiple checkboxes on the fly(one for each test) depending on the type.

load checkboxes,testboxes on the fly

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

load checkboxes,testboxes on the fly

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴