Untitled

<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Baza danych butów</title>
    <link href="css/bootstrap.min.css" rel="stylesheet">
  </head>
  <body>

      <div class="container">

        <nav class="navbar navbar-default">
      <div class="container-fluid">
        <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">ButSQL</a>
        </div>

        <!-- Collect the nav links, forms, and other content for toggling -->
        <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
          <ul class="nav navbar-nav">

            <li ><a href="index.php">Sklep</a></li>
            <li class="active"><a href="#">Wyszukaj<span class="sr-only">(current)</span></a></li>

          </ul>
        </div><!-- /.navbar-collapse -->
      </div><!-- /.container-fluid -->
          </nav>
         <!--
           -->

                <div class="row">
                <div class="col-md-8 col-md-offset-2">
                   <form action="wyszukaj.php" method="post">
                    <h3>Wyszukaj faktury poprzez wprowadzenie adresu email:</h3>
                    <input type="email" name="getEmail" class="form-control" placeholder="Email"><br/>
                    <button type="submit" name="szukaj" class="btn btn-primary" >Wyszukaj</button>
                </form>
                   </div>

               </div>
               <hr/ >
            <?php
          if(isset( $_POST['getEmail'])){
               $email = $_POST['getEmail'];

                    $ora_user = "damian_wawrzkowicz";
                    $ora_password = "sysdba";
                    $ora_bd = " (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))
                    (CONNECT_DATA =(SERVICE_NAME = SKLEP)))";
                    $conn = oci_connect($ora_user,$ora_password,$ora_bd);

              if  (!$conn) ){
                 $e = oci_error();
                trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
            }

              $zapytanie = ""; //tutaj wstawic zapytanie ktoro wyszuka mi w bazie rekordy  podanym emailem
              $stid = oci_parse($conn, $zapytanie);

              if (!$stid) {
                  $e = oci_error($conn);
                  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
              }

              $r = oci_execute($stid);
              if (!$r) {
                  $e = oci_error($stid);
                  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
              }

              print '<table class="table table-striped">';
              print '<thead>';
              print '<tr>';
              print '<th>Nr Faktury</th>';
              print '<th>Wartość Netto</th>';
              print '<th>Wartość Brutto</th>';
              print '<th>Bank</th>';
              print '<th>Forma Platności</th>';
              print '<th>Data Sprzedaży</th>';
              print '</tr>';
              print '</thead>';
              print '<tbody>';
              while (oci_fetch($stid)){
                  $nr_faktury =oci_result($stid, 'NR_FAKTURY');
                  $netto = oci_result($stid, 'WARTOSC_NETTO');
                  $brutto = oci_result($stid, 'WARTOSC_BRUTTO');
                  $bnak = oci_result($stid, 'BANK');
                  $forma_platnosci = oci_result($stid, 'FORMA_PLATNOSCI');
                  $data_sprzedazy = oci_result($stid, 'DATA_SPRZEDAZY');

                  print '<tr>';
                    print '<th>'.$nr_faktury.'</th>';
                    print '<th>'.$netto.'</th>';
                    print '<th>'.$brutto.'</th>';
                    print '<th>'.$bank.'</th>';
                    print '<th>'.$forma_platnosci.'</th>';
                    print '<th>'.$data_sprzedazy.'</th>';
                  print '</tr>';
              }

              print '</tbody>';
              print '</table>';

          }else{
              print '<center><h2>Nie podano adresu email!</h2></center>';
          }

          ?>

      </div>


    <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="js/bootstrap.min.js"></script>
  </body>
</html>