Insert multiple arrays

Question

I'm trying to grab all values from my inputs and insert them together, so for each value #1 in first array, insert value #1 in second and third. This is kind of what it looks like:

$lines = explode(PHP_EOL, $_POST['links']);
$keywords = explode(PHP_EOL, $_POST['keywords']);
$violationtypes = explode(PHP_EOL, $_POST['keywords']);

Those inputs are regular, but they may be 1 or 500, I honestly don't know. I used to handle this while there was one input like this:

foreach($lines as $line)
    {
if (!empty($line))
    {
        if (false === strpos($line, '://')) 
        {
           $line = 'http://' . $line;
        }
mysql_query("INSERT INTO links (ClientEmail,Links) VALUES ('$Emailvalue', '$line')");
}
}

However, I can't pull this one with 3 arrays. Is there a better way?

PS The check for empty lines is so that I don't add empty values into the database, and the other one is checking if http:// is there, and adds it if its not. That check is only for $lines, other inputs don't need any check

Barmar · Accepted Answer · 2013-10-06 00:58:08Z

2

Use the index in one array to fetch the corresponding elements of the other arrays:

foreach ($lines as $i => $line) {
    if (!empty($line)) {
        $keyword = $keywords[$i];
        $violation = $violationtypes[$i];
        // Now insert $line, $keyword, and $violation into DB
    }
}

answered Oct 6, 2013 at 0:58

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

Insert multiple arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related