Loop through a multidimensional array

Question

I am developing an application using php and the dropbox api and am trying to loop through a multidimensional array and output to a table. This is my code so far:

<?php
session_start();

# Include the Dropbox SDK libraries
require_once "Dropbox/autoload.php";
use \Dropbox as dbx;

// Create connection
$con = mysqli_connect(
    "localhost", "sintegra_aggre", "*******", "sintegra_aggregator"
);

// Check connection
if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

if (isset($_SESSION['uid'])) {
    $password = $_SESSION['pass'];
    $username = $_SESSION['user'];
    $email = mysqli_query($con, "
        SELECT * 
        FROM main_users
        WHERE
            password='$password'
            AND username='$username'
    ");

    if ($email >= 1) {
        // let them stay on page
    } else {
        header("Location: logout.php");
    }
} else {
    header("Location: login.php");
}

$accessToken = $_SESSION['accessToken'];

$dbxClient = new dbx\Client($accessToken, "PHP-Example/1.0");

$folderMetadata = $dbxClient->getMetadataWithChildren("/upload");

foreach ($folderMetadata as $value) {
    echo $value;
    foreach ($value as $val) {
        echo $val . "<br />";
    }
    echo "<br /><br />";
}
?>

and this is the output from the print_r of the array:

I have tried a combination of different methods from posts such as:

and none of them have worked.

I was hoping someone would be able to give me a bit of code that will loop through the array and output it into a table. It is also only the contents array that needs to be put into the table

Thanks in advance, Marcus

How were you expecting your table to layout? One table for the folder information, another following it with the content information? — Jason
– Jason, Commented Aug 28, 2013 at 23:32
Hi, I was thinking that the left coloumn could have the titles for each file such as bytes, path etc and the right the value. — marcus
– marcus, Commented Aug 28, 2013 at 23:33
also, I have just realized I forgot to mention that I do not need the folder information (I have now edited the original post) — marcus
– marcus, Commented Aug 28, 2013 at 23:45

Jason · Accepted Answer · 2013-08-29 16:42:31Z

1

A little bit of inline and block php will do the basics. The rest of the formatting is up to you ;D

All foreach have been done with the values as references in an effort to speed things up.

Revised Answer

Based on new information, since you want it laid out with the headings at the top you'd want to try something like this:

<?php $headings = array_keys($array['contents'][0]); ?>

<table>
    <tr>
        <?php foreach( $headings as &$heading ): ?>
            <th><?php echo $heading; ?></th>
        <?php endforeach; ?>
    </tr>
    <?php foreach( $array['contents'] as &$file ): ?>
        <tr>
            <?php foreach( $file as &$data ): ?>
                <td><?php echo $data; ?></td>
            <?php endforeach; ?>
        </tr>
    <?php endforeach; ?>
</table>

First line grabs the array_keys as headings, prints out the heading rows and then goes through the data rows directly from the array by reference.

Previous Revision

This was my last answer, it displays the table with the headings on the left, with the data displayed in columns.

<?php
    $output = array();

    foreach( $test['contents'] as &$file )
    {
        foreach( $file as $heading => &$value )
        {
            $output[$heading][] = $value;
        }
    }
?>

<table>
    <?php foreach( $output as $heading => &$data): ?>
        <tr>
            <th><?php echo $heading; ?></th>
           <?php foreach( $data as &$value ): ?>
               <td><?php echo $value; ?></td>
           <?php endforeach; ?>
        </tr>
    <?php endforeach; ?>
</table>

Because of the way tables are laid out, you can just use a little bit of shuffling to get an array to iterate correctly. There's probably a good thousand different ways to write this though.

edited Aug 29, 2013 at 16:42

answered Aug 28, 2013 at 23:56

Jason

1,9621 gold badge14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

marcus Over a year ago

hi, thanks for this and it is all working perfectly so far, this is my fault, but I was trying to get the file names on the left and the headers on-top, and I think that means the code has to be changed around to go from left to right to going from top to bottom. If possible, please could you edit your answer as I would have no idea how to start to go about doing this.

Jason Over a year ago

Check the updated answer, this displays the table with the headings at the top.

Collectives™ on Stack Overflow

Loop through a multidimensional array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related