PHP HTML表单多维数组MySQL

Question

I have php page with code: Everything is working fine.

<?php
session_start();
include 'db.php';//database connection

if ( isset($_POST['permission']))
{
$x=$_POST['permission'];
$a=print_r($x);//print array structure

$permit_group=array('Dean','Principal');//redefine of permission array as already    
//defined in form permission[Dean][] etc.

$permit_no=count($permit_group);//count array size of all defined areas
$b=print_r($permit_no);//its out put is 2; i am looking for: $permit_no=count($x)???

for($i=0; $i<$permit_no; $i++)//for loop for all possible permission (Dean, Principal   
etc.)
{

$jj=count($permit_group['$i']);//count size of subarea given to to individual area 
//person and output is 0; i am looking for: $jj=count($x['area'])???
$c=print_r($jj);

for($j=0; $j<jj; $j++)
{
$x1=$permit_group[$i];//i am looking for this:$x1=$x[$i]; How can i do this ?
$x2=$x[$permit_group[$i]][$j];//i am looking for this:$x2=$x[$i][$j];How can i do this?
mysqli_query($connection,"INSERT INTO upermission (area, subarea) VALUES   
('$x1','$x2')");
}
}
}
?>
<div>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<div>
<ul>Dean
<li><input type="checkbox" name="permission[Dean][]" value="list"/><label>List 
Principal   
</label></li>
<li><input type="checkbox" name="permission[Dean][]" value="Edit"/><label>Edit     
Principal   
</label></li>
</ul>

<ul>Principal: 
<li><input type="checkbox" name="permission[Principal][]" value="create"/>  
<label>Create Faculty</label></li>
<li><input type="checkbox" name="permission[Principal][]" value="edit"/><label>Edit  
Faculty</label></li>
<li><input type="checkbox" name="permission[Principal][]" value="add"/>  
<label>Add Faculty</label></li>
<li><input type="checkbox" name="permission[Principal][]" value="delete"/>  
<label>Delete Faculty</label></li>
</ul>
</div>
<input type="submit" name="submit" />
</form>
</div>

My questions are:

1) I am looking to get Area (Dean,Princial etc) and Subarea (Add, Edit etc.) value from HTML form only not to create array again as i created in php part?

2) Also to calculate size of only checked Area and Subarea, because size of Area and
subarea is different, to run both for loops to insert data into database table?

Please guide me how can i do?

Thanks

Answer 1

HI, If your problem is only with the loops, then try this.

$post_val = $_POST['permission'];   
foreach($post_val as $key=>$value)
{
    $x1 = $key;     
    for($i=0;$i<count($value);$i++)
    {
        $x2 = $value[$i];           
        mysqli_query($connection,"INSERT INTO upermission (area, subarea) VALUES
       ('".$x1."','".$x2."')");         
    }
}

If you want to build all this in the HTML only, then you have to deal with either javascript or jQuery.