This shows you the differences between two versions of the page.
— |
kurs:employees_tables.php [2014/12/15 11:13] (current) mh created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | <html> | ||
+ | <head> | ||
+ | <link rel="stylesheet" type="text/css" | ||
+ | href="bootstrap/dist/css/bootstrap.min.css"> | ||
+ | </head> | ||
+ | <h2>Employees</h2> | ||
+ | <?php | ||
+ | require_once('Util.php'); | ||
+ | if (empty($_GET)) { | ||
+ | ?> | ||
+ | |||
+ | <form class="form-horizontal" role="form" action='employees_table.php' | ||
+ | method='get'> | ||
+ | <div class="form-group"> | ||
+ | <label for="last_name" class="col-sm-offset-2 control-label">Last Name</label> | ||
+ | <input type="text" name="last_name"/><br> | ||
+ | <label for="first_name" class="col-sm-offset-2 control-label">First Name</label> | ||
+ | <input type="text" name="first_name"/><br> | ||
+ | </div> | ||
+ | <div class="col-sm-offset-2 col-sm-10"> | ||
+ | <input type="submit" value="Suchen" class="btn"/> | ||
+ | </div> | ||
+ | </form> | ||
+ | |||
+ | <?php | ||
+ | } else { | ||
+ | $last_name = $_GET['last_name']; | ||
+ | $first_name = $_GET['first_name']; | ||
+ | $db = oci_connect('hr', 'hr', 'kurs2.wifi'); | ||
+ | |||
+ | $sql = "select first_name, | ||
+ | last_name, | ||
+ | salary, | ||
+ | email, | ||
+ | hire_date | ||
+ | from employees where "; | ||
+ | |||
+ | if (!empty($last_name)) { | ||
+ | $sql .= " last_name = :b_last_name and"; | ||
+ | } | ||
+ | if (!empty($first_name)) { | ||
+ | $sql .= " first_name = :b_first_name and"; | ||
+ | } | ||
+ | $sql .= ' 1=1'; | ||
+ | | ||
+ | $q = oci_parse($db, $sql); | ||
+ | |||
+ | if (!empty($last_name)) { | ||
+ | oci_bind_by_name($q, ":b_last_name", $last_name ); | ||
+ | } | ||
+ | if (!empty($first_name)) { | ||
+ | oci_bind_by_name($q, ":b_first_name", $first_name ); | ||
+ | } | ||
+ | | ||
+ | |||
+ | $r = oci_execute($q, OCI_DEFAULT); | ||
+ | |||
+ | $table = array(); | ||
+ | while ($row = oci_fetch_array($q, OCI_NUM)) { | ||
+ | $table[] = $row; | ||
+ | } | ||
+ | | ||
+ | $headers = array('First Name', 'Last Name', 'Salary', | ||
+ | 'Email', 'Hire Date'); | ||
+ | print_table($table, $headers); | ||
+ | } | ||
+ | |||
+ | ?> | ||
+ | </html> | ||
+ | |||
+ | </code> | ||
+ |