By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,643 Members | 1,797 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,643 IT Pros & Developers. It's quick & easy.

problem of variable between two pages

P: n/a
Hi,

On a page, I have a form with a variable number of fields.

to print these fields, I have such a code :
while ($i !=0){
echo '<td> <input type="text" name="component'.$i.'" size="20"
value="" maxlength="70"> </td><br>
<td> <input type="text" name="quantity'.$i.'" size="20"
value="" maxlength="70"><br>
</td> </tr><tr>' ;
$i = $i - 1 ;
}

I then get variables such as component1, component2, etc. and quantity1,
quantity2, etc.

next page I want to enter these values into a MySQL table.

I am therefore passing from one page to another the value of the variables,
and some others.
I get the following code :
<?
$i = $nombercomponent ;
$db = mysql_connect('localhost', '', '');
mysql_select_db('recipe',$db);
while ($i !=0){
$sql = "INSERT INTO component VALUES('','','$ingr','$quant')";
mysql_query($sql) or die('Error !'.$sql.'<br>'.mysql_error());
$i = $i - 1 ;
}
mysql_close();
?>

How to have $ingr and $quant corresponding to all component and quantity
variable there number is variable ?
Thanks in advance

Philippe
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <c6***********@biggoron.nerim.net>, Philippe Rousselot wrote:
Hi,

On a page, I have a form with a variable number of fields.

to print these fields, I have such a code :
while ($i !=0){
echo '<td> <input type="text" name="component'.$i.'" size="20"
value="" maxlength="70"> </td><br>
<td> <input type="text" name="quantity'.$i.'" size="20"
value="" maxlength="70"><br>
</td> </tr><tr>' ;
$i = $i - 1 ;
}

I then get variables such as component1, component2, etc. and quantity1,
quantity2, etc.

next page I want to enter these values into a MySQL table.

I am therefore passing from one page to another the value of the variables,
and some others.
I get the following code :
<?
$i = $nombercomponent ;
$db = mysql_connect('localhost', '', '');
mysql_select_db('recipe',$db);
while ($i !=0){
$sql = "INSERT INTO component VALUES('','','$ingr','$quant')";
mysql_query($sql) or die('Error !'.$sql.'<br>'.mysql_error());
$i = $i - 1 ;
}
mysql_close();
?>

How to have $ingr and $quant corresponding to all component and quantity
variable there number is variable ?


What is the version of php you are using? If you would have bothered to
type in your question in the google search groups box, you would have
found the answer a zillion times. (hint: register globals)

It's probably not a bad idea to perform a mysql_escape_string on the
values you are trying to insert into your database.

--
http://home.mysth.be/~timvw
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.