<?php

$servername = "localhost";
$username = "root";
$dbpassword = "root";
$dbname = "personal_data";


$conn = new mysqli($servername, $username, $dbpassword, $dbname);

if (mysqli_connect_errno()) {
    printf("Connect failed: %sn", mysqli_connect_error());
    exit();
}

$email = mysqli_real_escape_string($conn, $_POST['email1']);

$getUserID = "SELECT UserID FROM personal_data WHERE Email='$email' LIMIT 1";
$resultUserID = mysqli_query($conn, $getUserID);
$valueUserID = mysqli_fetch_array($resultUserID, MYSQLI_ASSOC);
$UserID = $valueUserID["UserID"]; //get user ID

$getItemsInDB = "SELECT BarcodeID FROM intermediate_database WHERE UserID='$UserID'";
$resultItems = mysqli_query($conn, $getItemsInDB);
$valueItems = mysqli_fetch_array($resultItems, MYSQLI_ASSOC);
//use ID to get all barcode values

$itemArray = array();
foreach($valueItems as $item) { //iterate over array of barcodes
    //get each item's full line in product_database
$getBarcodeID =  "SELECT BarcodeID, BrandName, ProductName, Weight FROM product_database WHERE UserID='$item'";
$resultBarcodeID = mysqli_query($conn, $getBarcodeID);
$valueBarcodeID = mysqli_fetch_array($resultBarcodeID, MYSQLI_ASSOC);

array_push($itemArray, $valueBarcodeID);
//return array below in json_encode & access in js
}

json_encode($itemArray);

//how do I iterate over the $valueItems array and send to product_databse and then save retreived data in another array and then send that data to js file for printing


echo json_encode(array("UserID" => $valueUserID["UserID"], "items" => $itemArray));
?>