PHP - How Do I Put A Array Inside A Forloop?

An affiliate marketer refers some products which are stored in a simple array.
My website creates a JSON variable of all products sold.

$all_items_sold = '{"7777":{"item":"hammer","price":"4.99"},"8888":{"item":"nail","price":"1.99"},"9999":{"item":"apple","price":"2.00"}}';
$referred_by_Affiliate = array('1234','8888','7777');

So, out of all the 3 items that sold, only 2 of them were referred by the affiliate marketer.
DESIRED EFFECT: insert this product 8888: $1.99 and insert this product 7777: $4.99 into mysql.

Currently I do this:
1.) foreach loop,
2.) use strpos to see if it's in the raw JSON variable.
3.) If there, I use preg_match to find the price.
4.) Do a mySQL insert while still in the foreach loop.

Is there a "best practices" way to accomplish this?
I'm guessing there is a "one liner" so I don't have to do a foreach loop and using strpos.
And I'm guessing there is a way to do multiple mySQL inserts all at once with just one line of code, instead of from inside a foreach loop.
This probably can all be accomplished with just one line of code total, error trapping included 😁

Thank you.
 

<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
    <input type="text" name="hashtags" />
    <input type="submit" name="submit" />

</form>
<?php

include("connect.php");

?>
<?php

if(isset($_POST['submit'])){

    $hashtags = explode(", ", $_POST['hashtags']);

    for($i= 0; $i < count($hashtags); $i++){

        $tqs = "SELECT `id` FROM `hashtags_two` WHERE `hashtags` = '" . $hashtags[$i] . "'";
        $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

    }

    $fetch_array = array();
    while($row = mysqli_fetch_array($tqr)){
        $fetch_array[] = $row['id'];
    }

}

Array ( [0] => 24 ) 

Hi! My question is probably simple but I've been scratching my head for hours now... I'm pretty new to php. I have an online form for orders; when submitted, an email is sent to the shop manager containing the info the client has filled in. So I pass all the info in the code below, but I can't manage to echo the array containing the order's items/qty/item_code. (I'm using Wordpress, Oxygen Builder, Metabox and Code Snippets, if that helps). Here's the code (used as a Code Snippet):

add_action( 'rwmb_frontend_after_process', function( $config, $post_id ) {
    if ( 'command-form' !== $config['id'] ) {
        return;
    }

    $name = rwmb_meta( 'name', '', $post_id );
    $email = rwmb_meta( 'email', '', $post_id );
    $phone = rwmb_meta( 'phone', '', $post_id );
    $orders = rwmb_meta( 'order', '', $post_id ); */ ---> this is the array I wish to show the elements from (array --> [0]:{item:"item", qty:"qty", code:"code"]}, [1]:{}, etc...} */
    $comments = rwmb_meta( 'comments', '', $post_id );
    $reception = rwmb_meta( 'reception', '', $post_id );
    $destination = rwmb_meta( 'destination', '', $post_id );
    $payment = rwmb_meta( 'payment', '', $post_id );

    $body = "Vous avez reçu une nouvelle commande en ligne!

Nom: $name
Courriel: $email
Téléphone: $phone
Commande: */ ---> this is where I want it displayed, but since it is within $body = " ", I can't seem to be able to use foreach( ) or even print_r( )... */
Commentaires: $comments
Réception: $reception
Paiement: $payment";
     

    $headers = ['Content-type: text/html', "Reply-To: $email"];
    wp_mail( 'address@domain.com', 'Nouvelle commande en ligne', $body );
}, 10, 2 );

Help with this would be greatly appreciated! Please let me know if any details are missing. Thanks in advance!

Jordan

As the title says, how can i check if multiple arrays exist inside an array or not?

Any help is greatly appreciated!