Textfields

[ollmorris]

I have the code:

$optioned = $options+1;
for($i = 1; $i < $optioned; $i+=){
<input type=\"text\" name=\"option$i\">;}

However I have a problem when I try to insert a record into my database. My problem is that the SQL query doesn't seem to recoignise the name of the textfields I have generated using $i.

How can I solve this?

[Toby]

That code looks sort of, well, buggy... doesn't it look more like this?

<?
$optioned = 10; 
for($i = 1; $i < $optioned; $i++)
{ 
	echo "<input type=\"text\" name=\"option$i\">";
} 
?>

[ollmorris]

Yeah sorry the code should be:

$optioned = $options+1;

for($i = 1; $i < $optioned; $i++)

{

$fields = <input type=\"text\" name=\"option$i\">";

echo $fields;

}

[Toby]

Sorry, Oli, I have trouble understanding what you want to do with those input fields... they are generated correctly, provided that you add " to your variable definition 🙂

They will then be called <input type="text" name="option1">, option2 and so forth...

Now what do you want to do with them?

[ollmorris]

Sorry, I am not very good at explaining. I then want to insert the values of the textfields into a database. My problem is that the user defines the number of textfields that appear so I assume I will have to use the For command. However when I have tried this, my sql query hasn't recoignised the names (option1, option2 etc) of my textfields. How do I solve this?

Thanks

[Toby]

Something like this?

<form name="textfields" action="<?= $PHP_SELF?>">
<?
	if (empty($submit)):
	?>
  		Number of entries: <input type="text" name="number">
		<input type="submit" name="submit" value="Send">
	<?
	elseif(empty($field)):

	for($i = 0;$i < $number;$i++):

		echo "<input type=\"text\" name=\"field[$i]\"><br>\n";

	endfor;
	?>
		<input type="submit" name="submit" value="Send">
	<?

else:

	foreach($field as $value)
	{
		$query = "	INSERT INTO
						yourtable
					(
						yourfieldname
					)
					VALUES
					(
						'$value'
					)";

		$result = mysql_query($query);
	}

endif;
?>  

</form>

[ollmorris]

Yeah thats how I want it to be although the insertion code doesn't work. I hve successfully connected to the server and database though!

Thanks

[Toby]

I have just tested that on my server... seems to work nicely...

[ollmorris]

Oh right I will try again.

[Ace_Online]

Originally posted by ollmorris
my sql query hasn't recoignised the names (option1, option2 etc) of my textfields. How do I solve this?

Thanks

Look at your table design. How many fields do you have? If you are inserting in multiple records, then you want multiple queries. Each query should be structured as "INSERT into table (field1) values ($option$i)";

If you only have one field name and you are trying to insert each of these options as a new row, then you have to loop through the query until you get them all in there. If you seperate them by commas, like (option1, option2) then this assumes you are inserting the data in multiple fields. I don't know if this is what you are trying to do or not, but I'm just trying to point out where you might be going wrong.

[ollmorris]

Thanks very much toby it has worked fine. Thanks ace I was doing the same as what you suggested.

Thanks all