Multimple input fields to array

keiichi

Hi I just got here..

I having this problem..

I have a page with 24 input fields. And I want to construct an array with those values and store it in a session variable using the id of the field text as the name element. I'm populating the name of the fields with a sql query for the ids of the products.

<form method=post action=products.php>
<input name="1" type="text">
.
.
.
.
<input name="24" type="text">

When I submited the form I need this info:

The session Id, to know who is selecting.

and an array whit the selections, something like:

$products = array ('1' => '5', '3' => '6');

Once this info is in the array, I want to go to other page with the same functionality but with diferents products and do the same work, gather info and put it the same array, and pass the info to the next page...all this for 5 pages.

I need to put this info in a session variable so i can pass the selections to a page to make calculations on totals and taxes.

Hope someone can understand this..because once I wrote this I'm kinda confuse ;D...

peace.

TIA

devinemke

a simple example (with only 5 fields):

<?php
session_start();

if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	products:<br>
	1. <input type="text" name="products[1]"><br>
	2. <input type="text" name="products[2]"><br>
	3. <input type="text" name="products[3]"><br>
	4. <input type="text" name="products[4]"><br>
	5. <input type="text" name="products[5]"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	$_SESSION['products'] = $_POST['products'];
	print_r($_SESSION);
}
?>

keiichi

devinemke thankyou so much thats what I want.

May be I need to read the php documentation again, I been learning php about 10 days, and didn't know that this problem could be so easy to resov.

Now I want to make you another question, only if can answer of course..

Now I have the array with the products, and I will keep feeding it with new products how can query the db to match the id of the products to make math like qty * price.

As I toll in the first post I need to pass this array along with the SESSION ID for 5 pages to in the las page do the query , extract the product selected from the array match them with the query and multiply by price of the matched products.

Then insert all this info in a table for orders and send an email with the info of the products, qty and totals

I know I'm abusing of your knoledge but I have posted this question in 5 more forums and you are the first to come up with the solution.... now I know that I should have been posting first in PHP BUILDER..

TIA

devinemke

without knowing your exact data stucture, here is a basic example:

$result = mysql_query('SELECT * FROM products WHERE product_id IN(' . implode(array_keys($_SESSION['products'])) . ')') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$products[$row['product_id']] = $row;}

$total = 0;
foreach ($_SESSION['products'] as $key => $value)
{
	$subtotal = $value * $products[$key]['price'];
	echo 'product_id = ' . $key . ', qty = ' . $value . ', subtotal = ' . $subtotal . '<br>';
	$total += $subtotal;
}

echo 'total = ' . $total;

keiichi

I don't know what i'm doing wrong here.

When I get to the last page and make an


print_r($_SESSION['products']);

this is the result


Array
(
    [37] => 5
    [38] => 5
    [39] => 
    [40] => 
    [41] => 
    [42] => 
    [43] => 
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 
)

Only the lasts entrys of the array are listed. I'm using session_start(); in all pages so the session should be continued and the $_SESSION['products'] array should have all the items that have been added in earlier pages.

About your second example I understand it but could you explain it english what it does?

I have other tables but the main part is like this:

two important tables:

store_products
id
cat_id > id from category table
product_name
product_price
product_description
product_active > For activate or deactive a product whitout delete the entry.

store_shopper_track
id
session_id
sel_product_id
sel_product_cant
date_added

In every page I'm inserting the sel(selected) products and its qty to this table along with the session_id and the date.

But I'm seeing that in your second example the query expect the prices too, to make the calc.

Here is my question:

What do you think is the best method to use:

Pass all the data in the $_SESSION['products'] array, make a query and do the calc.?

When the user press the submit to go to the next page insert the selections in the table shopper_track along with the session_id and then in the last page query for all the items selected for the matching session_id?

I was using the second method but a little problem was anoying me when I do a back in the browser and change a qty. I was getting duplicates items in the shopper_track table, what method could I use to overwrite the seleccions in case of the user wants to make changes to the selections?.