Skip to content
Advertisement

How do you fetch data from the database? [closed]

<div id="report-tbl-holder">
        <table id="report-tbl" class="table table-stripped table-bordered">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Date/Time</th>
                    <th>Person's Code/Name</th>
                    <th>Establishment's/Barangay Code/Name</th>
                    <th>Temperature</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $i = 1;
                $where = ($eid > 0 && is_numeric($eid)) ? " and e.id = {$eid} " : "";
                $tracks = $conn->query("SELECT t.*,Concat(p.firstname,' ',p.middlename,' ',p.lastname)as pname,p.code as pcode, e.name as ename,e.code as ecode from tracks t inner join people p on p.id=t.person_id inner join establishment e on. e.id = t.establishment_id where date_format(t.date_added,'%Y-%m-%d') BETWEEN '{$date_start}' and '{$date_end}' $where order by date(t.date_added) asc");
                while($row=$tracks->fetch_assoc()):

                ?>
                <tr>
                    <td class="text-center"><?php echo $i++; ?></td>
                    <td><?php echo date("M d, Y h:i A",strtotime($row['date_added'])) ?></td>
                    <td><?php echo $row['pcode'] . ' - ' . (ucwords($row['pname'])) ?></td>
                    <td><?php echo $row['ecode'] . ' - ' . (ucwords($row['ename'])) ?></td>

                </tr>
                <?php endwhile; ?>
            </tbody>
        </table>

I created a row in my database named “temperature” and wanted to include it in a table on the webpage I have created but I don’t know how to call the contents of the newly added row (temperature) to display. It did add a new row because I added “Temperature” in the table header but I don’t know how to properly call the values for temperature from the database.

enter image description here

enter image description here

Advertisement

Answer

I think that there’s a confusion… Here “Temperature” is not a row, but a column.

You can try to add the following code line inside your loop :

<td><?php echo $row['body_temp'] ?></td>
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement