PHP Programming - temporary store values?

Author

temporary store values?

Garry Jones

2006-04-26, 7:58 am

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

Kimmo Laine

2006-04-26, 7:58 am

"Garry Jones" <garry.jones@morack.se> wrote in message
news:e2nim6$7d5$1@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
spam@outolempi.net | Gedoon-S @ IRCnet | rot13(xvzzb@bhgbyrzcv.arg)

Sponsored Links