How to update database fields with mixed arrays and strings

Question

I have an array containing strings of URLs, however some of the array elements are also an array. So some might be http://google.com, others might be:

Array([0] => http://yahoo.com [1] => http://msn.com)

I am trying to add a list of all these urls to a database. However, I need the list to expand for the multi-dimensional array. i.e. the list I am trying to establish should look like:

http://google.com
http://yahoo.com
http://msn.com

So I was initially doing this through a foreach, and then I thought I could expand the multi-dimensional arrays with a foreach within a foreach, but not sure that works. This is what I have currently, but doesnt work.

foreach($allfiles as $file) {
    if(is_array($file)) {
        $files = $file {
            foreach($files as $file)
        }
    }
    $qry2 = mysqli_query($con,"INSERT INTO files(name) VALUES($file)");
    echo '<br>'.$file;
    if($qry2) echo ' -success';
    else echo ' -error';
}

Is it me or you have no query in your second foreach?

Chin Leung
– Chin Leung

2016-02-18 21:00:47 +00:00
Commented Feb 18, 2016 at 21:00 — Chin Leung
– Chin Leung, Commented Feb 18, 2016 at 21:00

Community · Accepted Answer · 2017-05-23 12:23:20Z

1

You can make a recursive function to dig into your array.

Take a look at this explanation

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Feb 18, 2016 at 21:00

Michael

1,21316 silver badges34 bronze badges

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

Comments

Nick · Accepted Answer · 2016-02-18 21:00:54Z

0

function recursiveInsert($allfiles) {
    foreach($allfiles as $file) {
        if(is_array($file)) {
            recursiveInsert($file);
            continue;
        }
        $qry2 = mysqli_query($con,"INSERT INTO files(name) VALUES($file)");
        echo '<br>'.$file;
        if($qry2) echo ' -success';
        else echo ' -error';
    }
}

answered Feb 18, 2016 at 21:00

Nick

10.2k8 gold badges65 silver badges97 bronze badges

Collectives™ on Stack Overflow

How to update database fields with mixed arrays and strings

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related