How to join fields to their array of values?

gilgalbiblewhee

The first while has all the field/column names and the 2nd while has the values. But how can I join the fields so that they represent to their array of values?

    $showTables = "SHOW COLUMNS FROM ".$dbTable11;
    if($output = $conn->query($showTables)){
        $fields = array();
        //while($result = mysqli_fetch_assoc($output)):
        while($row = $output->fetch(PDO::FETCH_ASSOC)){
            $fields[] = $row['Field'];
        }
    }
    echo '<pre>';
    print_r($fields);
    echo '</pre>';


$sql1 = "SELECT * FROM ".$dbTable11." WHERE book='".$getBook."' AND chapter='".$getC1."'";
$result1 = $conn->query($sql1);
while($row = $result1->fetch(PDO::FETCH_ASSOC)) {
    if($row['text_data']!=NULL){

        $id[] = $row['id'];
        $book[] = $row['book'];       
        $bookTitle[] = $row['book_title'];
        $recordType[] = $row['recordType'];       
        $chapter[] = $row['chapter'];
        $verse[] = $row['verse'];
        $bookSpoke[] = $row['book_spoke'];
        $chapterSpoke[] = $row['chapter_spoke'];
        $verseSpoke[] = $row['verse_spoke'];
        $textData[] = $row['text_data'];       
        $strongs[] = $row['strongs'];
        $transliteration[] = $row['transliteration'];
        $etymology[] = $row['etymology'];
        $etymStrongs[] = $row['etym_strongs'];
        $etymDesc[] = lcfirst($row['etym_desc']);
        //$hebWord[] = hebrevc($row['heb_word']);
        $hebWord[] = $row['heb_word'];
        $greek_word[] = $row['greek_word'];
        $added[] = $row['added'];
        $also[] = $row['also'];

/*            $fields[0] = $row['id'];
            $fields[1] = $row['book'];       

            $fields[2] = $row['book_title'];
            $fields[3] = $row['recordType'];       

            $fields[4] = $row['chapter'];
            $fields[5] = $row['verse'];
            $fields[6] = $row['book_spoke'];
            $fields[7] = $row['chapter_spoke'];
            $fields[8] = $row['verse_spoke'];
            $fields[9] = $row['text_data'];       

            $fields[10] = $row['strongs'];
            $fields[11] = $row['transliteration'];
            $fields[12] = $row['etymology'];
            $fields[13] = $row['etym_strongs'];
            $fields[14] = lcfirst($row['etym_desc']);
            //$hebWord[] = hebrevc($row['heb_word']);
            $fields[15] = $row['heb_word'];
            $fields[16] = $row['greek_word'];
            $fields[17] = $row['added'];
            $fields[18] = $row['also'];    */       

        }
    }

        $fields[0] => $id;
        $fields[1] => $book;       
        $fields[2] => $bookTitle;
        $fields[3] => $recordType;       
        $fields[4] => $chapter;
        $fields[5] => $verse;
        $fields[6] => $bookSpoke;
        $fields[7] => $chapterSpoke;
        $fields[8] => $verseSpoke;
        $fields[9] => $textData;       
        $fields[10] => $strongs;
        $fields[11] => $transliteration;
        $fields[12] => $etymology;
        $fields[13] => $etymStrongs;
        $fields[14] => etymDesc;
        $fields[15] => $hebWord;
        $fields[16] => $greek_word;
        $fields[17] => $added;
        $fields[18] => $also;

Weedpacket

Isn't that what you already have in [font=monospace]$row[/font] for each record? Make an array of all rows (quickest done by using fetchAll instead of fetch).

Or do you want the transpose of that, where [font=monospace]$something['etymology'][/font] contains an array of the etymology values (instead of [font=monospace]$etymology[/font]?

// Assuming $fields and $allrows have been constructed as in the code and the previous paragraph respectively
$allcolumns = [];
foreach($fields as $field)
{
    $allcolumns[$field] = array_column($allrows, $field);
}

$allcolumns = array_combine($fields, array_map(null, ...$allrows));
// but I don't off-hand see anything that guarantees that the
// correct columns will end up in the correct position.