User Tools

Site Tools


kurs:get_emp_by_name2.php
<?php
print "<h2>request</h2>\n";
print_r($_REQUEST);

if ($_REQUEST['cmd'] != 'getemp') {
$html=<<<BLAB
<form name="get_emp_by_name" 
      action=$_SERVER[PHP_SELF]
	  method="get">
<input name="cmd" type="hidden" value="getemp">
First Name:<input name="first_name" type="text" size="30"><br>
Last Name:<input name="last_name" type="text" size="30"><br>
<input type="submit" value="Get Employee">
</form>
BLAB;

print $html;

} else {
include_once "functions.php";

$db = dbconnect();
$sql3 = 
   'select * from employees where 
     last_name  = :last_name and
	 first_name = :first_name';
	 	
$q = oci_parse($db, $sql3);
oci_bind_by_name($q, ":last_name", $_REQUEST['last_name'],-1, 
                 SQLT_CHR );

oci_bind_by_name($q, ":first_name", $_REQUEST['first_name'],-1,
                 SQLT_CHR );
			  
$r = oci_execute($q, OCI_DEFAULT);

$table[] = oci_fetch_array($q, OCI_ASSOC+OCI_RETURN_NULLS);

print_table($table);
}

?>
kurs/get_emp_by_name2.php.txt · Last modified: 2014/09/10 21:22 (external edit)