Can someone tell me what is wrong with this code? I get no errors and no output. Thanks.
<?php
if (isset($_POST['submit'])) {
$lastname=htmlentities($_POST['lastname']);
}
$c = oci_connect('user', 'password', '//server/DB');
$s = oci_parse($c, "select EMP_KEY, EMP_FIRST_NAME, EMP_LAST_NAME from EMP where EMP_LAST_NAME=:lastname");
ocibindbyname($s, ":lastname", $lastname);
oci_execute($s);
while (ocifetch($s)) {
echo ociresult($s, "EMP_KEY");
echo ociresult($s, "EMP_FIRST_NAME");
echo ociresult($s, "EMP_LAST_NAME");
}
oci_free_statement($s);
include "default.html";
?>
<?php
if (isset($_POST['submit'])) {
$lastname=htmlentities($_POST['lastname']);
}
$c = oci_connect('user', 'password', '//server/DB');
$s = oci_parse($c, "select EMP_KEY, EMP_FIRST_NAME, EMP_LAST_NAME from EMP where EMP_LAST_NAME=:lastname");
ocibindbyname($s, ":lastname", $lastname);
oci_execute($s);
while (ocifetch($s)) {
echo ociresult($s, "EMP_KEY");
echo ociresult($s, "EMP_FIRST_NAME");
echo ociresult($s, "EMP_LAST_NAME");
}
oci_free_statement($s);
include "default.html";
?>