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

temporary store values?

P: n/a
I want to simplify the following code.

I have 4 variables which are to be read in up to ten times. When read in
these are to be written to an SQL database. The value of $ct tells me when
to stop reading in these 4 variables. Each time I read in the group of 4
variables I need to increase $fx by 1 and read in additional values for each
group of variables again until $fx is equal to $ct.

I intend to use a while loop and read in these postings of four variables
until my requirement is met. Do I have to open the SQL database and write in
the four values for each passing of the loop? Or is there a way of storing
the values and writing in everything at the same time.

This is the code so far...

<?php

$ct=$_POST['totalnum'];

$fx = 1;
$insql1=$_POST["fardvag$fx"];
$insql2=$_POST["fornamn$fx"];
$insql3=$_POST["efternamn$fx"];
$insql4=$_POST["postnum$fx"];
$fx++

(I would like to "while" loop here until $fx=$ct, but don't see how I can
get the values into variables to be written to the database. As for each
passing of the loop new values will be assigned to each variable)

mysql_connect("localhost", "myusername", "mypassword") or
die(mysql_error());
mysql_select_db("my_database") or die(mysql_error());
mysql_query("INSERT INTO `animals` VALUES ('$insql1', '$insql2', '$insql3',
'$insql4')");
Header("Location: http://www.mydomain.com/");

(I can "while" loop here until $fx=$ct, but that means opening the database
for writing several times)

?>

Any help greatly appreciated.

Garry Jones
Sweden

Apr 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Garry Jones" <ga*********@morack.se> wrote in message
news:e2**********@yggdrasil.glocalnet.net...
I want to simplify the following code.

I have 4 variables which are to be read in up to ten times. When read in
these are to be written to an SQL database. The value of $ct tells me when
to stop reading in these 4 variables. Each time I read in the group of 4
variables I need to increase $fx by 1 and read in additional values for
each group of variables again until $fx is equal to $ct.

I intend to use a while loop and read in these postings of four variables
until my requirement is met. Do I have to open the SQL database and write
in the four values for each passing of the loop? Or is there a way of
storing the values and writing in everything at the same time.

This is the code so far...

<?php

$ct=$_POST['totalnum'];

$fx = 1;
$insql1=$_POST["fardvag$fx"];
$insql2=$_POST["fornamn$fx"];
$insql3=$_POST["efternamn$fx"];
$insql4=$_POST["postnum$fx"];
$fx++

(I would like to "while" loop here until $fx=$ct, but don't see how I can
get the values into variables to be written to the database. As for each
passing of the loop new values will be assigned to each variable)

mysql_connect("localhost", "myusername", "mypassword") or
die(mysql_error());
mysql_select_db("my_database") or die(mysql_error());
mysql_query("INSERT INTO `animals` VALUES ('$insql1', '$insql2',
'$insql3',
'$insql4')");
Header("Location: http://www.mydomain.com/");

(I can "while" loop here until $fx=$ct, but that means opening the
database for writing several times)


You only need to open the connection once, it stays open until page is
finished or it is closed. So just open the connection before entering the
while loop, and inside the loop run the mysql_query() statements.

in pseudocode:

connect server
select database

loop until condition
get parameters
create query
execute query
end loop

--
"ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" -lpk
sp**@outolempi.net | Gedoon-S @ IRCnet | rot13(xv***@bhgbyrzcv.arg)
Apr 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.