Programming a Basket in a shop

axmug · Oct 15, 2003

I'm doing a basket of a shop and I don't know how to modify the number of products that are in the basket if the user change the number of someone.

The problem is that when the user modify the number of units of a product I don't know which product has been modified (first,second,third...) and I can't update the database table where are the products stored.

I have been typing the following lines but they don't work:

$qry4=mysql_query("select numprodorders from orders where idpub='$rw[idprod]'&quot

;
$rw4=mysql_fetch_array($qry4);
echo "<td align=\"center\" bgcolor=\"#ccddee\"><input type=\"text\" name=\"cant[]\" size=\"2\" value=\"$rw4[numprodorders]\"></td>";

The lines of above are for showing the products that are in the basket, the following are the lines for the button Update that is to update the number of product units:

echo "<form method=\"post\" action=\"main.php?name=Shop&file=update\";";
echo " <td align=center>";
echo " <input type=\"submit\" name=\"update\" value=\"Update\">";
echo " </td>";

I would like how to solve this problem.

Thank you.

Spout · Oct 15, 2003

I'm not 100% sure what u'r asking but have you tried changing

Code:

where idpub='$rw[idprod]'&quot;);

to

where idpub='.$rw[idprod].'"

Which lines don't work exactly and how are they not working??

axmug · Oct 15, 2003

The problem is the value of the array cant[]. I have two products in the basket and I decide to change the number of units of the second product. If I click the button update the file update runs due to the line

echo "<form method=\"post\" action=\"main.php?name=Shop&file=update\";";

In this file I have the following:

$t=count($_POST['cant']);
echo $t;

The result after executing it is a 0 in the screen, so it's not possible because I modified the number of units of the second product typing 2 in his unit box.

What I want to do is to save in a variable the values of the units of all products modified by the user and I can't do it. How can I do it?

Thanks.

sleipnir214 · Oct 15, 2003

There is a trick with PHP and form field naming that might come in handy.

Assume you have a form like

Code:

<html><body><form method=&quot;POST&quot; action=&quot;test_formnames.php&quot;>
<table>
	<tr><th>Description</th><th>Quantity</th></tr>
	<tr>
		<td>Some catalog item</td>
		<td><input type=text name=&quot;amount[12345]&quot; value=&quot;3&quot;></td>
	</tr>
	<tr>
		<td>Another catalog item</td>
		<td><input type=text name=&quot;amount[54321]&quot; value=&quot;4&quot;></td>
	</tr>
</table><input type=&quot;submit&quot;></form></body></html>

(Pay particular attention to the names of the text inputs)

If the form is submitted, $_POST['amount'] will itself be an array in PHP. The element at array key "12345" will contain the value of the first input, the element at "54321" will contain the value for the second.

If those element keys match inventory numbers from your online catalog, you can match user-selected amounts to a particular item in the catalog.

If you need to also address the values of those inputs from JavaScript, you will have to add the attribute 'id="somename"' to each in put and refer to the inputs by those IDs instead of names.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Programming a Basket in a shop

axmug

Programmer

Spout

Programmer

axmug

Programmer

sleipnir214

Programmer

Similar threads

Part and Inventory Search

Sponsor