Skip to content Skip to sidebar Skip to footer

Php Json To Array Values Into Html Table

I am pulling JSON data from an API URL. I need to pull specific KEYS and put them into a table with columns and rows. 6 (col) x 20+ (rows). The KEYS are all duplicate (val, content

Solution 1:

I resolved this:

<style>
.uabb-table {
    overflow-x: auto;
    margin-left: auto;
    margin-right: auto;
    zoom: 1;
    display: flex;
}

.uabb-table .uabb-table-element-box {
    -webkit-flex-grow: 1;
    -ms-flex-positive: 1;
    -webkit-box-flex: 1;
    flex-grow: 1;
}

.uabb-table .uabb-table-wrapper {
    text-align: center;
    position: relative;
    height: 100%;
}

.uabb-table-inner-wrap {
    width: 100%;
}

.fl-module-uabb-table .uabb-table-wrapper .uabb-table-inner-wrap {
    border-collapse: collapse;
    margin: 0;
}


.uabb-table .uabb-table-wrapper {
    text-align: center;
    position: relative;
}

.fl-module-uabb-table .uabb-table-wrapper .uabb-table-inner-wrap {
    border-collapse: collapse;
    margin: 0;
}

.uabb-table-inner-wrap .uabb-table-header .table-header-th {
    border: 1px solid #000000;
    padding: 15px;
}

.uabb-table .uabb-table-header .table-header-th {
    overflow-wrap: normal;
}

.uabb-table .uabb-table-header .table-header-th, .uabb-table .uabb-table-features .table-body-td {
    vertical-align: middle;
    padding: 15px;
    border: 1px solid #000000;
}

.uabb-table .uabb-table-header .table-header-tr .table-header-th .th-style .head-inner-text, .uabb-table .uabb-table-header .table-header-tr .table-header-th .th-style {
    background: none;
}

.uabb-table .table-header-th .th-style {
    padding-right: 15px;
}

label {
    display: inline-block;
    margin-bottom: .5rem;
}

.uabb-table .uabb-table-header .table-header-tr .table-header-th .th-style .head-inner-text, .uabb-table .uabb-table-header .table-header-tr .table-header-th .th-style {
    background: none;
}

.content-text {text-transform: uppercase;}

</style>

<?php

$url = 'URL';
$data = file_get_contents($url);
$parsed = json_decode($data, true);

$eachEntry = $parsed['response']['result']['Leads']['row'];

$valuesIWant = ["First Name", "Last Name", "Street", "City", "State", "Zip Code"];

echo    '<div class="uabb-table-module-content uabb-table">
            <div class="uabb-table-element-box">
                <div class="uabb-table-wrapper">
                    <table class="uabb-table-inner-wrap">
                        <thead class="uabb-table-header">
                            <tr class="table-header-tr">
                                <th class="table-heading-0 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-0 th-style">
                                        <label class="head-inner-text">First Name</label>
                                    </label>
                                </th> 
                                <th class="table-heading-1 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-1 th-style">
                                        <label class="head-inner-text">Last Name</label>
                                    </label>
                                </th> 
                                <th class="table-heading-2 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-2 th-style">
                                        <label class="head-inner-text">Street</label>
                                    </label>
                                </th> 
                                <th class="table-heading-3 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-3 th-style">
                                        <label class="head-inner-text">City</label>
                                    </label>
                                </th> 
                                <th class="table-heading-4 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-4 th-style">
                                        <label class="head-inner-text">State</label>
                                    </label>
                                </th> 
                                <th class="table-heading-5 table-header-th" rowspan="" colspan="">
                                    <label class="head-style-5 th-style">
                                        <label class="head-inner-text">Zip Code</label>
                                    </label>
                                </th> 
                            </tr>
                        </thead>';
foreach ($eachEntry as $entry) {

    $FL = $entry['no'];

    //printf("\n");

    $entries = $entry['FL'];

    echo '<tbody class="uabb-table-features"><tr class="tbody-row">';
    foreach ($entries as $value) {

        $val = $value['val'];

        $content = $value['content'];

        if (in_array($val, $valuesIWant)) {

            //$out = $val;
           $out2 = $content;

            //echo '<td>'. $out .'</td>';
            echo '<td class="table-body-td  table-body-0" colspan="" rowspan=""><span class="content-text">'. $out2 .'</span></td>';

        }

    }
    echo '</tr></tbody>';
}

echo '</table></div></div></div>';

?>

Post a Comment for "Php Json To Array Values Into Html Table"