How can I put the table header in PHP?

Question

I want the table header like this: NUME, DECEDATI etc. I tried with echo also and it doesn't work. Please help me!

PHP code:

    <?php
    print "<table";
    print "<tr>";
    print "<th>NUME  </th>";
    print "<th>  DECEDATI   </th>";
    print "<th>  RANITI   </th>";
    print "<th>  DISPARUTI   </th>";
    print "<th>  CLADIRI DISTRUSE  </th>";
    print "<th>  DURATA   </th>";
    print "<th>  MAGNITUDINE   </th>";
    print "<th>  ADANCIME   </th>";
    print "<th>  PAGUBE MATERIALE   </th>";
    print "<th>  NUMAR REPLICI  </th>";
    print "</tr>";
    print "</table>";
    $conn = oci_connect('student', 'STUDENT', 'localhost/XE');
    if (!$conn) {
        $e = oci_error();
        trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
    }

    // Prepare the statement
    $stid = oci_parse($conn, "SELECT * FROM nepal ORDER BY ".$_GET['categorie']." ".$_GET['ordine']);
    if (!$stid) {
        $e = oci_error($conn);
        trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
    }

    // Perform the logic of the query
    $r = oci_execute($stid);
    if (!$r) {
        $e = oci_error($stid);
        trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
    }

    // Fetch the results of the query
    print "<table border='1'>\n";
    while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
        print "<tr>\n";
        foreach ($row as $item) {
            print "    <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;") . "</td>\n";
        }
        print "</tr>\n";
    }
    print "</table>\n";

    oci_free_statement($stid);
    oci_close($conn);

    ?>

The display of my code containts the body of the table without the table header.

*"Now the content of the header is in bold style but without the borders."* - There are many HTML / CSS tutorials out there. Honestly, you could and should be going out there and put some effort into this. — Funk Forty Niner, Jun 12 '17 at 14:33

score 0 · Accepted Answer · answered Jun 12 '17 at 14:55

Assuming that the table headers should be part of the same table that displays the actual data then you would probably want to try something like this.

<?php

    echo "
    <table>
        <tr>
            <th>NUME</th>
            <th>DECEDATI</th>
            <th>RANITI</th>
            <th>DISPARUTI</th>
            <th>CLADIRI DISTRUSE</th>
            <th>DURATA</th>
            <th>MAGNITUDINE</th>
            <th>ADANCIME</th>
            <th>PAGUBE MATERIALE</th>
            <th>NUMAR REPLICI</th>
        </tr>";


    $conn = oci_connect('student', 'STUDENT', 'localhost/XE');
    if( !$conn ) {
        $e = oci_error();
        trigger_error( htmlentities( $e['message'], ENT_QUOTES ), E_USER_ERROR );
    }

    $stid = oci_parse( $conn, "SELECT * FROM nepal ORDER BY ".$_GET['categorie']." ".$_GET['ordine'] );
    if( !$stid ) {
        $e = oci_error( $conn );
        trigger_error( htmlentities( $e['message'], ENT_QUOTES ), E_USER_ERROR );
    }

    // Perform the logic of the query
    $r = oci_execute( $stid );
    if( !$r ) {
        $e = oci_error( $stid );
        trigger_error( htmlentities( $e['message'], ENT_QUOTES ), E_USER_ERROR );
    }

    // Fetch the results of the query
    while( $row = oci_fetch_array( $stid, OCI_ASSOC+OCI_RETURN_NULLS ) ) {
        $value=$item !== null ? htmlentities( $item, ENT_QUOTES ) : "&nbsp;";
        echo "
        <tr>
            <td>$value</td>
        </tr>";
    }


    oci_free_statement( $stid );
    oci_close( $conn );

    echo "</table>";
?>

score -1 · Answer 2 · edited Jun 12 '17 at 14:31

-1

print "<table";

needs to be

print "<table>";

Note the missing >

edited Jun 12 '17 at 14:31

Qirel

25,449
7
45
62

answered Jun 12 '17 at 14:20

David

369
2
4
14

1

why go after typo questions? Just vote to close. And your *"for starters"* - you seem unsure about that. – Funk Forty Niner Jun 12 '17 at 14:21
Why bother sending me a message Fred? Is it not an answer to his question? I saw the question, I answered. The guy changes the code, it works, he closes... if not he replies. – David Jun 12 '17 at 14:23
@Fred-ii- Removed "For starters" so you can sleep easy tonight. – David Jun 12 '17 at 14:25
Now the content of the header is in bold style but without the borders. – Haba Gabriela-Alexandra Jun 12 '17 at 14:29

How can I put the table header in PHP?

2 Answers2