how to match user selected item with their respective quantity and size

[kang jia]

hi
i am doing shopping online, i will let user choose their prodcut in the first page and then when they click" order" button, they will be redirected to do_addcart.php. i will insert their orders into "orders" table and retrieve them back and ask user to select their respective quantity and size. i have used Javascript validation:

the code is below:

 <script language="JavaScript">
 
<!--
 
function validate_form ( )
{
    valid = true;
alert (document.Lform.quantity.selectedIndex);
    if ( document.Lform.quantity.selectedIndex == 0 )
        {
                alert ( "Please select your quantity!" );
                Lform.quantity.focus();
                valid = false;
        }
    else if ( document.Lform.size.selectedIndex == 0 )
        {
                alert ( "Please select your size!" );
                Lform.size.focus();
                valid = false;
        }
            return valid;
}
//-->
</script>

However, i don;t know how to correspond respective product with their respective choosen quantity and size.

the following is my current coding,

 <?php
 foreach ($_POST as $key => $value) {
    echo "key: ".$key.", value: ".$value."<br>";
        $sql = "INSERT INTO orders (imageid, userid, time) VALUES ('$key', '$userid', '$date')";
        mysql_query($sql); 
    }
 
echo "Please select your size and quantity for purchase:";
    echo "<table border = '1'>";
                echo "<tr>";
                echo "<td>Title";
                echo "<td>Brand";
                echo "<td>Price";
                echo "<td>Size";
                echo "<td>Quantity";
                echo "</tr>";
$sql2="SELECT imageid FROM orders";
$result=mysql_query($sql2);
while($row = mysql_fetch_array($result)) {
                echo "<br>";
                $sql3="SELECT brand, price, title FROM ladies WHERE id=".$row['imageid'];
                $ImageResult = mysql_query($sql3);
                $ImageDetail = mysql_fetch_array($ImageResult);
                echo "<tr>";
                echo "<td>".$ImageDetail['title']."";
                echo "<td>".$ImageDetail['brand']."";
                echo "<td>".$ImageDetail['price']."";
                echo"<td>";
 
                echo"
            <select id='size' name='size' tabindex='11'>
                            <option value='0'>---
                            <option value='1' >S
                            <option value='2'>M
                            <option value='3'>L
                            <option value='4'>XL
                    </select>
                    </td>";     
    //echo"    ";    
 
 
    echo"
        <td>
            <select id='NO' name='quantity' tabindex='11'>
                            <option value='0'>---
                            <option value='1' >1
                            <option value='2'>2
                            <option value='3'>3
                            <option value='4'>4
                            <option value='5'>5
                            <option value='6'>6
                            <option value='7'>7
                            <option value='8'>8
                            <option value='9'>9
                            <option value='10'>10
                    </select>
                    </td>"; 
                 echo "</tr>";            
                }
            echo "</table>";
    echo "<input type = 'submit' value = 'order'>";
?>

anyone can help me with this, thank you very much. it is bit urgent as the project deadline is near.

Please enclose your coding with [code] tags
[Please Find how!]

[ak1dnar]

the default is all 1, but my supervisor don;t think it is practical in real life to let everyone just buy one and they should be able to select the size they wear. that is why i have to do the validation of size and quantity for each item they buy.

i have to insert their size and quantity for the respective item in database, so i have to know which size and quantity is belong to which item.

sure, i will wait for your kind reply. thanks. :)

Just Listen to me again,

Why Customer(s) comes to e-commerce sites. to Buy isn't it.
Do they ever purchasing "0" items. NO.
Its should be greater than 1 always.
Then Size, As I know you are going to display S,M,L,XL with your products.
So can't we set one of them by default. If User don't want that Size say XL is set by default and he needs L so he will do it.

However get in touch with your SUPERvisor :)

<?php
$con = mysql_connect('localhost', 'root', 'dba') or die ("Could not connect to the Database");
mysql_select_db('test', $con) or die (mysql_error()); 
$query1 = 'Select p_id from products';
$result1 = mysql_query($query1);
$query2 = 'Select p_id from products';
$result2 = mysql_query($query2);
?>
<html>
<head>
<script language="JavaScript" type="text/javascript">
function menuChk(){
<?php
while ($row1 = mysql_fetch_array($result1))
{
?>
var Str<?=$row1['p_id']?> = document.formObj.Qty<?=$row1['p_id']?>.selectedIndex;
if (Str<?=$row1['p_id']?> == 0){
alert("Please select the Quantity!");
document.formObj.Qty<?=$row1['p_id']?>.focus();
return false;
}
<?
}
?>
}
</script>
</head>
<body>
<form id="formObj" name="formObj" method="post" action="server.php" onsubmit="return menuChk();">
<?php
while ($row2 = mysql_fetch_array($result2))
{
?>
<select name="Qty<?=$row2['p_id']?>">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<?php
}
?>
<input name="" type="submit" />
</form>
</body>
</html>
 
 

This will print somting like this dynamically.

<html>
<head>
<script language="JavaScript" type="text/javascript">
function menuChk(){
var Str143 = document.formObj.Qty143.selectedIndex;
if (Str143 == 0){
alert("Please select the Quantity!");
document.formObj.Qty143.focus();
return false;
}
var Str144 = document.formObj.Qty144.selectedIndex;
if (Str144 == 0){
alert("Please select the Quantity!");
document.formObj.Qty144.focus();
return false;
}
var Str145 = document.formObj.Qty145.selectedIndex;
if (Str145 == 0){
alert("Please select the Quantity!");
document.formObj.Qty145.focus();
return false;
}
var Str146 = document.formObj.Qty146.selectedIndex;
if (Str146 == 0){
alert("Please select the Quantity!");
document.formObj.Qty146.focus();
return false;
}
var Str147 = document.formObj.Qty147.selectedIndex;
if (Str147 == 0){
alert("Please select the Quantity!");
document.formObj.Qty147.focus();
return false;
}
var Str148 = document.formObj.Qty148.selectedIndex;
if (Str148 == 0){
alert("Please select the Quantity!");
document.formObj.Qty148.focus();
return false;
}
}
</script>
</head>
<body>
<form id="formObj" name="formObj" method="post" action="server.php" onsubmit="return menuChk();">
<select name="Qty143">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<select name="Qty144">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<select name="Qty145">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<select name="Qty146">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<select name="Qty147">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<select name="Qty148">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
</select>
<br />
<input name="" type="submit" />
</form>
</body>
</html>
 
 

[kang jia]

i do think what you said previously is very true , we can just set default value ma, later user want to change, they will change, i will validate my reasons with my supervisor, thanks for your kind help . but if i choose to use the defult one, how should i insert in database.

Remaining section removed from the post,Please read the next thread to find out the reason.

[ak1dnar]

Sorry I have to delete this post from the thread.

Reason:
Cannot see the post. its empty.
May be its too long.

Please Remove the unwanted static contents from your coding and re-post it.

Thanks!
-Ajaxrand

[kang jia]

Sorry I have to delete this post from the thread.

Reason:
Cannot see the post. its empty.
May be its too long.

Please Remove the unwanted static contents from your coding and re-post it.

Thanks!
-Ajaxrand

thanks for your kind help, i just sovled it with my other friends' help, really thanks, you are so nice and kind to help me!

[ak1dnar]

thanks for your kind help, i just sovled it with my other friends' help, really thanks, you are so nice and kind to help me!

Glad to hear that !Well done!
Come back any time to TSDN.
-Ajaxrand