PHP - Combining Two Arrays Into A Multi-dimensional Array

Basically what I want to do is create an array of inheritance.  so here is the levels
Owner->Admin->moderator->User->guest

owner has all the abilities of admin, moderator, user and guest..

So I want to be able to sort through them and end with an array like this
Code: [Select]
$array['Owner'] = array('Admin', 'Moderator', 'User', 'Guest');
Currently my code works sort of. Basically Admin is only set to inherit Moderator. Moderator only inherits User. So this code works but only to 2 levels. I don't want to add a billion foeachs within each other for each level(currently 4) but I might add more roils so then I would have to add more foreachs. There must be a magic way to do this. Any feedback is appreciated!

Code: [Select]
<?PHP

$sql = 'SELECT * FROM '.self::$Config['PERMISSIONS']['Database'].'.permissions_inheritance';

$result = DB::Query($sql);
while($row = DB::fetch($result)){
if($row['type'] == '0'){
$group_i[$row['child']][] = $row['parent'];
}elseif($row['type'] == '1'){
$user_i[$row['child']][] = $row['parent'];
}
}

//echo count($group_i);
print_r($group_i);
$groups = array();


foreach($group_i as $Key=>$Value){
foreach($Value as $K=>$V){
$new_array[$Key][] = $V;
if(isset($group_i[$V]) && is_array($group_i[$V])){
foreach($group_i[$V] as $Q=>$A){
if(is_array($A)){
foreach($A as $C=>$X){
$new_array[$Key][] = $X;
}
}else{
$new_array[$Key][] = $A;
}
}
}
}

}
Let me know if you have any questions! I hope you enjoy the challenge lolol

Hello fellow coders! My brain is about to explode! Does anyone have some time to help me with a small problem?

I have two multi-dimensional arrays similar to the below:

Code: [Select]
mysql_table_schedule
 [0]
  [firstname] = Roger
  [id] = xxx
 [1]
  [firstname] = Pamela
  [id] = xxy
mysql_table_roster
 [0]
  [firstname] = Roger
  [id] = xxx
 [1]
  [firstname] = Pamela
  [id] = xxy
 [2]
  [firstname] = Orsen
  [id] = xyy

I can build both arrays above after grabbing the data from the MySQL database by using a quick for function
Code: [Select]
for($i = 0; $array[$i] = mysql_fetch_assoc($mysql_roster); $i++) ;but after I have both arrays how do I keep only the records in mysql_table_roster that are in the schedule. Out of each daily schedule only a few people work. I'd like to keep all of the associated information from the roster like first name, last name, phone number, etcetera.

If yesterday only Roger and Pamela worked how do I compare by [firstname] and trim the mysql_table_roster to inlclude only the arrays related to Roger and Pamela?

I've looked into array_intersect, but have no clue how to specify a comparison by a specific array key within multi-dimensional arrays.

Hello, I've been struggling to get array_multisort to work...   If I have this array output... I'd like to sort on the product sub-array.   The array is called orders and that number 15 is the specific order id.

Array
(
    [15] => Array
        (
            [clientId] => 1
            [clientName] => Bob
            [o_date] => 2014-01-02
            [o_number] => 1 july-append
            [o_notes] => order on 1 july-append
            [i_date] => 2014-01-17
            [i_number] => 18072014-append
            [i_notes] => invoiced on 18 july 14 -append
            [products] => Array
                (
                    [0] => Array
                        (
                            [id] => 37
                            [prod_id] => 1
                            [product] => door
                            [qty] => 2
                            [cost] => 12.121
                        )

                    [1] => Array
                        (
                            [id] => 38
                            [prod_id] => 2
                            [product] => window
                            [qty] => 3
                            [cost] => 22.5
                        )

                    [2] => Array
                        (
                            [id] => 36
                            [prod_id] => 3
                            [product] => chair
                            [qty] => 1
                            [cost] => 300
                        )

                )

        )

)

So, I've tried a number of variations of this...

array_multisort($orders[$theOrder]['products'], SORT_DESC, SORT_NUMERIC, $orders[$theOrder]['products'], SORT_ASC, SORT_STRING);

array_multisort($orders[$theOrder]['products']['id'], SORT_DESC, SORT_NUMERIC);

etc. etc.
  - but I seem to get no-where. Can some-one kindly point out my error, please?   Thank you.

This has been so much FUN  for me that I couldn't wait to share!

I have a page on a Wordpress site using some special functions in the Theme I am running that displays custom fields in a List after a Form has been filled out for a Particular Post Category.

On this page the User can see the results of the Form they just filled out and review them before finally submitting them.

I have one function which gathers all of the Custom fields associated with that particular post they have made from the "holding table"--an interim saving instead of keeping them all in a session value exclusively.

The form they have just filled out produces one string or value per field EXCEPT in the case of multi-value checkboxes.

If on this review page any values are gathered whose $field_type is equal to 'checkbox' then it is guaranteed that those values are stored in an array.  Right now the problem is that the existing function that gathers and displays all these custom fields simply shows "Array" everytime it handles the values of one of these checkboxes.

In those cases where a row's $field_type = 'checkbox' then in every case there will be an associative array stored in brackets [] that I want when detected to be put into visible list of however many values are found.

In the sql statement when it gathers the field $field_type values it will find either "text", "dropdown", "textarea", or "checkbox" in the same id row along with the $field_label, $field_name, $field_values for each record.


I want to build more conditions and actions here to handle a situation where it runs into an associative array inside the first array of all of the custom fields.


I include the whole function I want to modify further down:
It starts out --
        echo cp_formbuilder_review($results);

and I guess I want something along the lines of--

if($results) {foreach ($results as $result)
if (is_array($result) { loop through and put individual array elements in an unordered list with the $field_label associated with each checkbox array}

else { continue the loop for all other types of custom fields which are not $field_type=checkbox because all of these custom fields will have values in just one string or one value}

For testing purposes, so you know what the values look like underlying this page if I use this statement on the page

    echo '<br/><br/>("$postvals")-- $postvals PRINT<br/>';
    print_r;

I will get back this for $_POST

    echo '$_POST PRINT<br/>just the post and nothing more';
    print_r($_POST);
( [post_title] => Stunning rental [cp_checkbox_days] => Array ( => Thursday [1] => Friday ) [cp_checkbox_amenities] => Array ( => Gardener [1] => Watchman ) [cp_checkbox_hello] => Array ( => Smoking Allowed: Outdoor areas only ) [cp_price] => 98888 [cp_street] => 888 Flange [cp_city] => Reynaldo [cp_state] => Virginia [cp_country] => Antartica [cp_zipcode] => 1080 [tags_input] => stunner [post_content] => Wow is all we can say about this one.
Right now the visual display shows this for Arrays
<ul>

                    
        <li><label><strong>Category:</strong></label>
        <div id="review">Affordable Rentals</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Title:</strong></label>

            <div id="review">Stunning stunner</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>help checkbox:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>

        </li>

    
        <li>
            <label><strong>Staff Provided:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>
        </li>

    
        <li>

            <label><strong>Suitability:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Price:</strong></label>
            <div id="review">98888</div>

            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Street:</strong></label>
            <div id="review">888 Flange</div>
            <div class="clr"></div>
        </li>
</ul>



So, wherever a value shows up like this [cp_checkbox_days] => Array ( => Thursday [1] => Friday )  I need for this array to be iterated and broken up into <li>Thursday</li> <li>Friday</li>


HERE IS THE CODE MORSEL that is UNDERPERFORMING!

I am hoping a genius like DavidAM can soup this thing up!





function cp_show_review($postvals) {
    global $wpdb;


    // if there's no form id it must mean the default form is being used so let's go grab those fields
    if(!($postvals['fid'])) {
        // use this if there's no custom form being used and give us the default form
        $sql = $wpdb->prepare("SELECT field_label, field_name, field_type, field_values, field_req "
             . "FROM ". $wpdb->prefix . "cp_ad_fields "
             . "WHERE field_core = '1' "
             . "ORDER BY field_id asc");

    } else {
        // now we should have the formid so show the form layout based on the category selected
        $sql = $wpdb->prepare("SELECT f.field_label,f.field_name,f.field_type,f.field_values,f.field_perm,m.meta_id,m.field_pos,m.field_req,m.form_id "
             . "FROM ". $wpdb->prefix . "cp_ad_fields f "
             . "INNER JOIN ". $wpdb->prefix . "cp_ad_meta m "
             . "ON f.field_id = m.field_id "
             . "WHERE m.form_id = '". $postvals['fid'] ."'"
             . "ORDER BY m.field_pos asc");
    }


    $results = $wpdb->get_results($sql);

    if($results) {

        // loop through the custom form fields and display them
        echo cp_formbuilder_review($results);

   //from here is where I have to switch to detecting the Arrays associated with checkboxes and explode them and loop them separately into something pretty with its own field_label   
//and when it has looped through all the Arrays and made them visible it continues looping through the rest of the single value strings and fields

    } else {

        echo sprintf(__('ERROR: The form template for form ID %s does not exist or the session variable is empty.', 'cp'), $postvals['fid'] . "\n\n");
    }
    ?>

Looks pretty darn easy doesn't it??

Hi guys,
I've done a bit of research into sorting a multi-dimensional array that contains the menu information (to be parsed and displayed). Everything that I've read has confused me more than I was when I started.

I want it to be sorted by parent (ASC) then by it's sort number (ASC).

Code: [Select]
Array (
   [0] => Array (
      [0] => 2 [id] => 2
      [1] => About Us
      [label] => About Us
      [2] => ?r=about
      [link] => ?r=about
      [3] =>
      [relation] =>
     [4] => 0
     [parent] => 0
     [5] => 10
     [sort] => 10
     [6] => 0
     [active] => 0 )
   [1] => Array (
      [0] => 3
      [id] => 3
      [1] => Fleet
      [label] => Fleet
      [2] => ?r=about/fleet
      [link] => ?r=about/fleet
      [3] =>
      [relation] =>
      [4] => 2
      [parent] => 2
      [5] => 0
      [sort] => 0
      [6] => 0
      [active] => 0 )
   [2] => Array (
      [0] => 4
      [id] => 4
      [1] => Test
      [label] => Test
      [2] => ?r=test
      [link] => ?r=test
      [3] =>
      [relation] =>
      [4] => 0
      [parent] => 0
      [5] => 5
      [sort] => 5
      [6] => 1
      [active] => 1
      ))
Thank you in advance for any help