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 class="active"><a href="#">Sklep<span class="sr-only">(current)</span></a></li>
            <li><a href="wyszukaj.php">Wyszukaj</a></li>

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


              <?php
          $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);
            }

                $stid = oci_parse($conn, 'SELECT * FROM buty');

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

          // Perform the logic of the query
              $r = oci_execute($stid);
              if (!$r) {
                  $e = oci_error($stid);
                  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
              }


          //--------
          $count = 6; //to tymczasowe zeby widziec jak by wypisywalo

                print '<div class="container-fluid" style="background:transparent;" >';
                print '<table class="table table-striped">';
                    print '<thead>';
          while (oci_fetch($stid)){  //ta petle trzeba bedzie zmaminiec na while wydaje mi sie

              $bucik = "img/buty1.jpg";
               $opis = oci_result($row, 'OPIS');//wstawienie opisu
            $nazwa = oci_result($row, 'NAZWA_BUTA');
              $brutto = oci_result($row, 'CENA_BRUTTO');
              $id=oci_result($row, 'BUT_ID'); //tutaj id potrzeba zeby potem przekazac do formulara kupna i dalej do bazy
               print '<tr>';
                print '<form action="kupno.php" method="post">';

                            print '<div class="col-sm-6 col-md-4">';
                                print '<div class="thumbnail">';
                                print '<img src="'.$bucik.'">';
                                print '<div class="caption">';
                                print '<h3>'.$nazwa.'</h3>'; //nazwa
                                print '<p>'.$opis.' </p>';
                                print '<p>Rozmiar: '.$rozmiar.' Cena: '.$brutto.'</p>';
                                print '<p>
                                    <button type="submit" name="id" value="'.$id.'"class="btn btn-primary" >Kup</button>
                                    </p>'; //tam gdzie $id zmienic potem na wartosci id z bazy danych
                                print '</div>';
                                print '</div>';
                            print '</div>';
                        print '</form>';
                        print '</tr>';

          }

                    print '</thead>';
                print '</table>' ;
                print '</div>';

          oci_free_statement($stid);
          oci_close($conn);
              ?>


      </div>

      <hr/>
      	<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">&copy wszystkie prawa zastrzeżone. <a class="text-green 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>