Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <!--
- To change this license header, choose License Headers in Project Properties.
- To change this template file, choose Tools | Templates
- and open the template in the editor.
- -->
- <html>
- <head>
- <meta charset="UTF-8">
- <title>CRUD APLIKACIJA</title>
- </head>
- <body style="background-color: #f0e68c">
- <h2>Unos, azuriranje i brisanje podataka o studentima</h2>
- <form action="index.php" method="POST" enctype="multipart/form-data">
- <fieldset>
- <legend>Podaci o studentima:</legend>
- <?php
- // uvoz konekcije
- require_once './konekcija.php';
- $index=$ime=$prezime=$status=$sifra="";
- // provera tastera
- if (isset($_POST['dodaj'])) {
- if (!$_POST['brind'] || !$_POST['ime'] ||
- !$_POST['prezime'] || !$_POST['status'] ||
- !$_POST['sifra'] || empty($_FILES['slika'])) {
- echo 'Svi podaci moraju biti uneti!';
- } else {
- // UPLOAD SLIKE NA SERVER
- if (!empty($_FILES['slika'])) {
- // echo '<pre>';
- // var_dump($_FILES['slika']);
- // echo "</pre>";
- // da li je uneti fajl slika ili nijei to formata jpeg
- if($_FILES['slika']['type'] == 'image/jpeg'){
- // provera da li postoji direktorijum koji se zove slike
- if(is_dir('slike')){
- $source = $_FILES['slika']['tmp_name']; // temp fajl treba prebaciti na odredjenu lokaciju
- $putanja = "slike/".$_FILES['slika']['name'];
- move_uploaded_file($source, $putanja);
- }else{
- // ukoliko ne postoji direktorijum kreiraj ga
- mkdir('slike');
- }
- }
- // KRAJ UPLOAD SLIKE NA SERVER
- // UPISIVANJE PODATAKA U BAZU
- //priprema upita za bazu
- $stmt = $conn->prepare("INSERT INTO `STUDENT`"
- . "(`broj_indexa`, `ime`, `prezime`, `status`,"
- . "`sifra`, `slika`) "
- . "values (?,?,?,?,?,?)");
- // povezivanje podataka sa tipovima promenljivih
- $stmt->bind_param("ssssss", $index, $ime, $prezime, $status, $sifra, $slika);
- $index = $_POST['brind'];
- $ime = $_POST['ime'];
- $prezime = $_POST['prezime'];
- $status = $_POST['status'];
- $sifra = $_POST['sifra'];
- $slika = $_FILES['slika']['name'];
- // provera i izvrsavanje upita
- if(!$stmt->execute()){
- echo 'Greska: '.$conn->errno."- ".$conn->error;
- } else {
- echo 'Podaci uspesno uneti u bazu';
- }
- // oslobadjanje resursa
- $stmt->close();
- $conn->close();
- // KRAJ UPISIVANJA PODATAKA U BAZU
- } else {
- echo 'Greska!';
- }
- }
- }
- /*************************PRETRAGA PO INDEXU***********************/
- if(isset($_POST['traziind'])){
- if(!empty($_POST['brind'])){
- $stmt = $conn->prepare("SELECT * FROM `student` WHERE `broj_indexa`=?");
- $stmt->bind_param("s",$indexForma);
- $indexForma = $_POST['brind'];
- if(!$stmt->execute()){
- echo "Greska ".$conn->errno." - ".$conn->error;
- }
- else{
- // uzimanje pojedinacnog podatka kao asocijativni niz
- $podatak = $stmt->get_result();
- $red = $podatak->fetch_assoc();
- $index = $red['broj_indexa'];
- $ime = $red['ime'];
- $prezime = $red['prezime'];
- $status = $red['status'];
- $sifra = $red['sifra'];
- }
- echo $status;
- }else{
- echo "Parametar po kome se vrsi pretraga nije upisan!";
- }
- }
- ?>
- <table class="auto-style1">
- <col span="1" align="left">
- <tr>
- <td>Broj indexa:</td>
- <td>
- <input type="text" name="brind" value="<?php echo $index; ?>" size="10" />
- </td>
- </tr>
- <tr>
- <td>Prezime:</td>
- <td>
- <input type="text" name="prezime" value="<?php echo $prezime; ?>" size="12" />
- </td>
- </tr>
- <tr>
- <td>Ime:</td>
- <td>
- <input type="text" name="ime" value="<?php echo $ime; ?>" size="12" />
- </td>
- </tr>
- <tr>
- <td>Status:</td>
- <td>
- <?php if($status==="b") { ?>
- <label>B
- <input type="radio" name="status" value="b" checked />
- </label>
- <label>S
- <input type="radio" name="status" value="s" />
- </label>
- <?php } else if($status==='s') { ?>
- <label>B
- <input type="radio" name="status" value="b" />
- </label>
- <label>S
- <input type="radio" name="status" value="s" checked/>
- </label>
- <?php } else { ?>
- <label>B
- <input type="radio" name="status" value="b" />
- </label>
- <label>S
- <input type="radio" name="status" value="s" />
- </label>
- <?php } ?>
- </td>
- </tr>
- <tr>
- <td>Sifra smera:</td>
- <td>
- <input type="text" name="sifra" value="<?php echo $sifra; ?>" size="10" />
- </td>
- </tr>
- <tr>
- <td>Slika:</td>
- <td>
- <input type="file" name="slika" value="" size="10" />
- </td>
- </tr>
- <tr>
- <td><hr></hr></td>
- <td><hr></hr></td>
- <td><hr></hr></td>
- </tr>
- <tr>
- <td>
- <input type="submit" class="button button3" value="DODAJ" name="dodaj" />
- </td>
- <td>
- <input type="submit" class="button button3" value="AZURIRAJ" name="azuriraj" />
- </td>
- <td>
- <input type="submit" class="button button3" value="OBRISI" name="obrisi" />
- </td>
- </tr>
- <tr>
- <td>
- <input type="submit" class="button button5" value="Trazi prezime" name="traziprez" />
- </td>
- <td>
- <input type="submit" class="button button5" value="Trazi index" name="traziind" />
- </td>
- <td>
- <input type="reset" class="button button5" value="Reset" name="reset" />
- </td>
- </tr>
- </table>
- <fieldset>
- <legend>
- Opcije pretrage:
- </legend>
- <select name="polje[]">
- <option value="broj_indexa">broj indexa</option>
- <option value="ime">ime</option>
- <option value="prezime">prezime</option>
- <option value="sifra">sifra</option>
- </select>
- <input type="text" name="polje_p" value="" size="10" />
- <input type="submit" class="button button1" value="Pretrazi" name="pretraga" />
- </fieldset>
- </fieldset>
- </fieldset>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement