Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="#">Szybkie buty</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
- $ora_user = "c##damiann";
- $ora_password = "sysdba";
- $ora_bd = " (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS =
- (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))
- (CONNECT_DATA =
- (SERVICE_NAME = orcl)))";
- $conn = oci_connect($ora_user,$ora_password,$ora_bd);
- if(isset( $_POST['getEmail'])){
- $email = $_POST['getEmail'];
- }
- 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>Imie</th>';
- print '<th>Nazwisko</th>';
- 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)){
- $imie_faktura = oci_result($stid, 'IMIE');
- $nazwisko_faktura = oci_result($stid, 'NAZWISKO');
- $nr_faktury = oci_result($stid, 'NR_FAKTURY');
- $netto = oci_result($stid, 'WARTOSC_NETTO');
- $brutto = oci_result($stid, 'WARTOSC_BRUTTO');
- $bank = oci_result($stid, 'BANK');
- $forma_platnosci = oci_result($stid, 'FORMA_PLATNOSCI');
- $data_sprzedazy = oci_result($stid, 'DATA_SPRZEDAZY');
- print '<tr>';
- print '<th>'.$imie_faktura.'</th>';
- print '<th>'.$nazwisko_faktura.'</th>';
- 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 '<br/><center><h2>Nie podano adresu email!</h2></center>';
- }
- oci_free_statement($stid);
- oci_close($conn);
- ?>
- </div>
- <br/>
- <br/>
- <hr/>
- <br/>
- <br/>
- <section id="footer">
- <div class="container">
- <div class="row text-center text-xs-center text-sm-left text-md-left">
- <div class="col-xs-12 col-sm-4 col-md-4">
- <h5>INFORMACJE</h5>
- <ul class="list-unstyled quick-links">
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Regulamin</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Reklamacje</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>O firmie</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Płatności</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Kontakt</a></li>
- </ul>
- </div>
- <div class="col-xs-12 col-sm-4 col-md-4">
- <h5>NEWSLETTER</h5>
- <ul class="list-unstyled quick-links">
- <br/>
- <form>
- <input type="email" class="form-control" placeholder="Email"><br/>
- <button type="submit" class="btn btn-info" >Zapisz się</button>
- </form>
- </ul>
- </div>
- <div class="col-xs-12 col-sm-4 col-md-4">
- <h5>KONTAKT</h5>
- <ul class="list-unstyled quick-links">
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Facebook</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>Instagram</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>kontakt@szybkiebuty.com</a></li>
- <li><a href="#"><i class="fa fa-angle-double-right"></i>+48 123 32 07</a></li>
- </ul>
- </div>
- </div>
- <div class="row">
- <div class="col-xs-12 col-sm-12 col-md-12 mt-2 mt-sm-2 text-center text-white">
- <p class="h6">© wszystkie prawa zastrzeżone. <a class="ml-2" href="#" target="_blank">Szybkie buty</a></p>
- </div>
- <hr/>
- </div>
- </div>
- </section>
- <!-- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement