Untitled

<?php
    if (isset($_POST['dno'])) {
        $db_sid = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) )";
    $db_user = "scott";
    $db_pass = "tiger";

    $c = oci_connect($db_user, $db_pass, $db_sid);
    if (!$c) {
        die("Connection Failed");
    }


        $q = "SELECT * FROM emp WHERE dno = '". $_POST['dno'] ."'";
        $p = oci_parse($c, $q);
        $r = oci_execute($p);
    }
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <title>SEARCH</title>
</head>
<body>
<form action="search.php" method="POST">
        <label>Department No.</label>
        <input type="text" id="dno" name="dno">
        <input type="submit" value="Search">
    </form>
    <?php
        if (isset($_POST['dno'])) {
            ?>
    <table align="center">
        <thead>
            <tr>
                <th>Emp No</th>
                <th>Emp Name</th>
                <th>Job</th>
            </tr>
        </thead>
        <tbody>
            <?php
                while ($s = oci_fetch_array($p, OCI_BOTH + OCI_RETURN_NULLS)) {
                    ?>

            <tr>
                <td><?= $s['EMPNO']; ?></td>
                <td><?= $s['ENAME']; ?></td>
                <td><?= $s['JOB']; ?></td>
            </tr>

            <?php
                } ?>
        </tbody>
    </table>
    <?php
        }
    ?>


</body>
</html>