I have an array of products with categories they appear in. This gets stored in a category assoc table. When I edit a product listing, it get the last id, makes an entry with the table using assoc id, product id, cat id. But I am loosing the product order. Is it possible to store the product order value the same time I store the category id? Currently it just records "0" for the order. I need the value of the order in the loop. $cats = $prod->getProductCategories(); if(count($cats)>0) { foreach($cats as $cat) { ?> <tr> <td><?php echo $cat['cat_name'];?></td> <td><input type='checkbox' name='prodCategories[]' value='<?php echo $cat['cat_id']; ?>' <?php if($editProduct) echo $prod->isCheckSelected($cat['cat_id'], $vals['prod_id']);?>/> <input type="text" name='prodCategories[][order]' value="79" /> </td> </tr> <?php } } //on my product class... for($i= 0; $i < count($cats); $i++) { $catCategory = "INSERT INTO category_assoc (prod_id, cat_id, p_order) VALUES('$lastID',' ". $cats[$i] . "','". $order[$i] . "')"; $wpdb->query($catCategory); }

Storing array values from form

By mallen
October 16, 2017 in PHP Coding Help

https://forums.phpfreaks.com/topic/305375-storing-array-values-from-form/

Followers 0

Go to solution Solved by mallen, October 25, 2017

Recommended Posts

Solution

mallen

Posted October 25, 2017

Author
Solution

- Share

Posted October 25, 2017 (edited)

I think I finally got it working. Thanks again for helping me through this. I have learned more about arrays than I ever have.

<input type="hidden" name="ords[]" <?php if($editProduct) echo "value='{$cat['p_order']}'"; ?>/>
	
---------------------------------------------
	
$ords =	$_REQUEST['ords'];
		
$catCategory = "INSERT INTO category_assoc (prod_id, cat_id, p_order) VALUES('$lastID', '". $cats[$i] . "','". $ords[$i] . "')";
	
---------------------------------------------
	
I think the quote marks were an issue. Also these two parts. 
$ords[$i]
name="ords[]"

Edited October 25, 2017 by mallen