PHP Combine arrays in a loop

Question

Currently I want to output a data from a database. I have two separate arrays. May I know is there a way to combine those arrays. The code is as below,

$array_1 = [
  'memo' => 'title string',
  'break_down' => 'title string',
  'images' => 'title string',
  'email_content' => 'title string'
];

// content from db
$array_2 = [$memo, $break_down, $images, $email_content];


// I want it to display like this
<?php foreach ($array_1 as $key=> $name) : ?>

<p>
<?= $name; ?> = <?php  //content on $array_2 ?> 
<?php //eg: title string = $memo and so on.. ?>
</p>

<?php endforeach ?>

You are expected to try to write the code yourself. After doing more research if you have a problem post what you've tried with a clear explanation of what isn't working and provide a Minimal, Complete, and Verifiable example. Read How to Ask a good question. Be sure to take the tour and read this. — Jay Blanchard
– Jay Blanchard, Commented Jul 7, 2017 at 15:09

Casimir et Hippolyte · Accepted Answer · 2017-07-07 15:21:45Z

3

With array_combine and array_keys:

$keys = array_keys($array_1);
$array_2 = array_combine($keys, $array_2);

foreach ($array_1 as $key => $name): ?>
<p>
<?= $name; ?> = <?php echo $array_2[$key]; ...

Note that you can also have the keys you want directly from your SQL query using the as SQL keyword:

select field1 as memo, field2 as break_down ...

and using mysqli_fetch_assoc or PDO::FETCH_ASSOC

edited Jul 7, 2017 at 15:21

answered Jul 7, 2017 at 15:09

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

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

2 Comments

Amran Over a year ago

Thank you for the help. If I use the sql query string, I do not need to assign the array like on $array_2 right?

Casimir et Hippolyte Over a year ago

@Amran: indeed, if you only want to display your query results and if you use as in your query (or if columns have already the good names), you don't need to use array_combine to rebuild a new array.

Collectives™ on Stack Overflow

PHP Combine arrays in a loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related