All pastes #942808 Raw Edit

Unnamed

public php v1 · immutable
·published 2008-03-14 19:21 UTC
rendered paste body
<?php// var_dump($_POST); //error_reporting(E_ALL & ~E_NOTICE);include("config.php");// I'm assuming that dropdown 1_1 is the first one, 1_2 is the second one and so on.// subcat_1_1_1 is the first checkbox in the first dropdown in the first of the three sections.// subcat_1_1_2 is the second checkbox in that dropdown and so on.  $categories = array();$name = $_POST['name'];$green = $_POST['green'];$eco = $_POST['eco'];$dfe = $_POST['dfe'];// Just a little trick to make multiple variables on a single line$section_exists = true;$category_exists = true;$subcategory_exists = true;//echo "catexists: $category_exists<br>secexists: $section_exists<br>subcatexists: $subcategory_exists<br>";  // While the array-key exists, this loop will run and collect all checkboxes// in the array called categories   for($w=1;$w<500;$w++){         if(!array_key_exists('subcat_'.$w.'_1_1', $_POST))        {                 //$w = -1;				break;        }               for($x=1;$x<500;$x++)        {                  if(!array_key_exists('subcat_1_'.$x.'_1', $_POST))                {                         //$x = -1;						break;                }                       for($y=1;$y<500;$y++)                {                         if(!array_key_exists('subcat_1_'.$x.'_'.$y, $_POST))                        {                                  // $y = -1;							   break;                        }                                                         $categories[$w][$x][] = $y;                                        }        }} // Now you have an array with all checkboxes, something like// $subcat[1][1][1] = The number of the first checked checkbox in the first category// $subcat[1][1][2] = The number of the second checked checkbox  in the first category and so on.// $subcat[1][2][1] = The number of the first checked checkbox in the second category// $subcat[1][2][2] = The number of the second checked checkbox in the second category and so on.// $subcat[2][1][1] = The number of the first checked checkbox in the first category, second section// $subcat[2][1][2] = The number of the second checked checkbox  in the first category, second section and so on.    $key_exists = true;$subkey_exists = true;$strings = array();// Loops through and turns all categories' arrays into strings for($h=1;$h<500;$h++){        if(!array_key_exists($h, $categories))        {                  //$key_exists = false;				break;        }				if (!array_key_exists(1, $categories[$h]))		    {                //$key_exists = false;				break;        }               for($i=1;$i<500;$i++)        {                 if(!array_key_exists($i, $categories[$h]))                {                          //$subkey_exists = false;						break;                }								print(sizeof($strings));				 				                // This will turn the array into a string with all subcategories, separated by ;.                // For example, 0;3;53 if subcategory 0, 3 and 53 are checked                $strings[$h][$i] = implode(';', $categories[$h][$i]);			         }		}   // Now strings[] contains all the strings (like 1;3;5 and 3;5;7). Loop through the array:for($x=1;$x<sizeof($strings);$x++){         for($y=1;$y<sizeof($strings[$x]);$y++)        {                 // *build a query using the string*                // Echoing just for debugging or whatever.               print("INSERT into item_test (id, name, green, eco, dfe, category, subcategory) VALUES ('','$name','$green','$eco','$dfe','$x','$y')");        }}   // Done. // Store that field in the DB and then when you want them into an array again, do:// $array = exlode(';', $string); ?>