How to assign different names for each text box when placed in a loop in php..?

Question

I had generated few textboxes in a loop n named them differntly.. but the retrieving of data from those boxes is not working.. Please help me..

code for creating those textboxes

$i=0;  
while($data=mysql_fetch_array( $sql ))
   { 
       echo "<tr><td>".$data['idno']." </td><td>".$data['name'] . " </td><td>
       <input type='text' name='obtmarks".$i."'></td></tr>";  $i++; 
   }

I have to retrieve that data n place it another table

code for retrieving the data

$i=0;


while($data=mysql_fetch_array( $sql1 )) 
 { 

    $as=mysql_query("INSERT INTO marks values('".$data['idno']."','".$data['name']."','".mysql_real_escape_string($_POST['obtmarks".$i."'])."')");
 $i++;  }

Please help me.. thank u in advance..

Asciiom · Accepted Answer · 2012-09-19 11:55:10Z

1

Assuming you print the textboxes in a form, and post the form back to the retrieval code:

You need to get the variable value from the post array:

$i=0;

while($data=mysql_fetch_array( $sql1 )) 
{ 
    var value = $_POST['obtmarks'.$i];

    // insert into database

    $i++;  
}

(Be careful to use the exact same label, in your example you use obmarks and obtmarks.)

WARNING Don't store the value in your database without checking it!! Use prepared statements!!

answered Sep 19, 2012 at 11:55

Asciiom

9,9757 gold badges42 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nandu Over a year ago

can u please guide me abt those prepared statements for this code.

Asciiom Over a year ago

You should read this guide. Variables bound using prepared statements are escaped automatically by the server, preventing SQL Injection attacks.

Nelson Benítez León · Accepted Answer · 2012-09-19 11:55:57Z

1

What about this:

$as=mysql_query("INSERT INTO marks values('".$data['idno']."','".$data['name']."','".$_POST['obmarks'.$i]."')");

this is assuming you are passing your data through a form submit.

answered Sep 19, 2012 at 11:55

Nelson Benítez León

51.1k8 gold badges70 silver badges84 bronze badges

Collectives™ on Stack Overflow

How to assign different names for each text box when placed in a loop in php..?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related