[RESOLVED] Product select

Double_M

Hi again,

I have a table list of products and a text field at the end of every row which is the "amount". For example i would put "2" into the amount box and click the "add product" button. How would i go about adding the amount then it taking the product id from that row to be inserted into a database? This would include multiple amounts for multiple products at the same time.
Of course afterwards it would list current products that have been selected.

Hope that makes sense.

Thanks for any help.

jdorsch

Double_M wrote:
Hope that makes sense.

No, that makes no sense whatsoever =(

iNFERiON

Indeed. Please clarify your problem some more.

Double_M

🙁

ok i shall try again.

example table:

when the user enters an amount into the amount text field as shown above, and clicks the "add product" button. it will display in the next page the product id and description and the amount they entered. so in essence it takes the details from the product table and the amount the user entered and then puts it in another table (product_order) and displays it in the next page.

I was wondering how to get the correct information from the same row as the amount the user entered.

I have probably made it sound way to complicated, but i hope its understandable this time.

harmor

So if the user inputs

Description: Play, Burn, Copy, and Rip Software.
Amount: $31.99

Then on the next page you want it to show what the user entered plus go into the database?

jdorsch

Are you talking about HTML tables or database tables?

iNFERiON

If you just want information to be carried along to a follow up page you don't need to do database stuff yet. Just recall the post variables. For example.

Page 1:

<form method="post" action="page2.php">
<input name="productid" type="text">
<input name="description" type="text">
<input name="amount" type="text">
<input type="submit" value="Next Page">

You can recall the entered information on page 2 like this:

<input name="productid" type="text" value="<?php echo $_POST['productid']; ?>">
<input name="description" type="text" value="<?php echo $_POST['description']; ?>">
<input name="amount" type="text" value="<?php echo $_POST['amount']; ?>">

Double_M

:quiet:

The table is formed from a database of products which is a repeat region. And the only thing the user enters is the amount which is how many the user wants i.e. "2".

Once button clicked, it takes the amount the user entered and productid from the same row. then inputs it into a seperate database.

Any clearer? :bemused:

iNFERiON

What is the purpose of your script ? By the sound of it I'd say you're trying to make something like a shopping cart and the user can enter the amount it wants of the product ?
If this is the case, you don't need to enter the amount into a database, you should consider just storing it in a session variable instead that has the product id as name.

Double_M

Yes it is some sort of shopping cart thing, i shall give the session variable a go. Thanks alot for your help.

Double_M

I dont think sessions will be the way to go. 😕

The product list will be rather large. I have buttons to add the products at the top and botom of the table, and no matter how many rows there are in the table i want it to take the amount the user has entered and the corisponding productid from the same row.

So the user can select as many products as they want and enter different amounts for each. Then on clicking the add items button take amount and productid and display it in cart type thing.

Any help? Its driving me mad. :quiet:

m_tt

So you are having a problem assigning all the product ids to the amounts?

Double_M

Yes 😃

Because the table is a repeat region made from a search function. And so every row has a text field at the end so the user can enter how many they want right away for multiple products. But when i click add items button i cant get to take the amount they entered and the product id from the same row.

So for each amount they have entered i would take the products id thats associated with it. Remember there is only one button to press to add items 😛 for the whole table.

m_tt

Well here is an idea..

Setup your text input fields like so

<input type="text" name="amount[ $product_id ]" value="">

Replacing $product_id with your product_ids

When posted, it will return an array from amount[]

Then you could loop it...

foreach($_POST['amount'] as $product_id => $amount)	{
      // Update table set amount = $amount where product_id = $product_id
}

Double_M

Thats sorted it!!!!!!!!!!

Thank god for that, finally i can put this thread to rest.

Thanks alot for all your help, got there in the end 😃😃😃😃😃