i'm aware pagination, if checkbox clicked , move onto page, checked checkbox no longer recognized, made php pull depending on category chosen user, , each row spits out in w3css w3-third div:
while($rowtbl = mysqli_fetch_array($resulttbl)) { ?> <div id="parent"> <div class="<?php echo $rowtbl['brand']?>"> <section class="allitems"> <div class="w3-third w3-margin-bottom" id="itemstofilter" data-type="<?php echo $rowtbl['brand']?>"> <ul class="w3-ul w3-border w3-center w3-hover-shadow" > <li class="w3-padding-16 w3-green">desc: <b><?php echo htmlspecialchars($rowtbl['description']) ?></b> <input type="hidden" name="descriptionid<?php echo $i; ?>" value="<?php echo $rowtbl['description']; ?>" /></li> <li class="w3-padding-4">brand: <b><?php echo htmlspecialchars($rowtbl['brand']) ?></b> <input type="hidden" name="brandid<?php echo $i; ?>" value="<?php echo $rowtbl['brand']; ?>" /></li> <li class="w3-padding-4">category: <b><?php echo htmlspecialchars($rowtbl['category']) ?></b> <input type="hidden" name="categoryid<?php echo $i; ?>" value="<?php echo $rowtbl['category']; ?>" /></li> <li class="w3-padding-4">item#: <b><?php echo htmlspecialchars($rowtbl['itemnu']) ?></b> <input type="hidden" name="itemid<?php echo $i; ?>" value="<?php echo $rowtbl['itemnu']; ?>" /></li> <li class="w3-padding-2">pack size: <b><?php echo htmlspecialchars($rowtbl['packsz']) ?></b> <input type="hidden" name="packszid<?php echo $i; ?>" value="<?php echo $rowtbl['packsz']; ?>" /></li> <?php if ($rowtbl['bc'] == "y") { ?> <li class="w3-padding-10">broken cs: <b><input type="checkbox" value="checkedup" name="bcase<?php echo $i; ?>" /></b></li> <?php } else { ?> <li class="w3-padding-10">broken cs: <b><input type="checkbox" value="notcheckedup" name="bcase<?php echo $i; ?>" disabled /></b></li> <? } ?> <li><input type="checkbox" name="checkbox<?php echo $i; ?>" /></li> <input type="hidden" name="roses" id="roses" value="<?php echo $i; ?>" /> <input type="hidden" name="filler<?php echo $i; ?>" id="filler" /> </ul> </div> </section> </div> </div> <?php $i++; //increment counter variable } ?> everything fine in regards adding item(s) db, until div passed 142. after that, when click add, page refreshes if processed, nothing gets added db.
what doing wrong?
thanks in advance!
edit: showing php adds items db:
<?php if(isset($_post['submitnew'])){ ($i=1;$i<=$_post['roses'];$i++) { if(isset($_post['checkbox'.$i])) { $custnum = $_session['customernumber']; $category = $_post['categoryid'.$i]; $brand = $_post['brandid'.$i]; $description = $_post['descriptionid'.$i]; $pksz = $_post['packszid'.$i]; $itemnum = $_post['itemid'.$i]; if($_post['bcase'.$i] == "notcheckedup") { $bcc = "n"; $eaa = 0; } elseif ($_post['bcase'.$i] == "checkedup" && isset($_post['bcase'.$i])) { $bcc = "y"; $eaa = 1; } else { $bcc = "y"; $eaa = 0; }; $ordnew = "insert `abc123` (`custno`,`category`, `brand`, `description`, `pksz`, `ea`, `itemnu`, `bc`) values('$custnum', '$category', '$brand', '$description', '$pksz', '$eaa', '$itemnum', '$bcc')"; mysqli_query($link, $ordnew); } header("location: index.php"); } } ?>
Comments
Post a Comment