Advertisement
Guest User

Untitled

a guest
Jan 24th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. /////////////////spajanje na bazu
  2. <?php
  3.  
  4.  
  5. $server = "localhost";
  6. $username = "root";
  7. $password = "";
  8. $dbname= "autoradionica";
  9.  
  10. $conn = mysqli_connect($server, $username, $password, $dbname) or die("Nemogu se spojit");
  11. mysqli_set_charset($conn,"utf8");
  12. $sql = "SELECT ime, prezime FROM radnik";
  13.  
  14. $query = mysqli_query($conn, $sql);
  15.  
  16. while($row=mysqli_fetch_array($query)){
  17. echo "<tr><td>".$row["ime"].".".$row["prezime"]."@autoradionica.com</td></tr>";
  18. }
  19.  
  20. mysqli_close($conn);
  21. ?>
  22.  
  23. //////////////PREPARED STATEMENT
  24.  
  25. $conn = mysqli_connect($server, $username, $password, $datbase) or die("Kill the Kardashians");
  26.  
  27. $stmt = $conn->prepare("INSERT INTO kvar (sifKvar, nazivKvar, sifOdjel, brojRadnika, satiKvar) VALUES(?, ?, ?, ?, ?)");
  28. $stmt->bind_param("isiii", $sifKvar, $nazivKvar, $sifOdjel, $brojRadnika, $satiKvar);
  29.  
  30. $sifKvar = $_POST["sifKvar"];
  31. $nazivKvar = $_POST["nazivKvar"];
  32. $sifOdjel = $_POST["sifOdjel"];
  33. $brojRadnika = $_POST["brojRadnika"];
  34. $satiKvar = $_POST["satiKvar"];
  35.  
  36. $stmt->execute();
  37.  
  38. ////////////////FORMA
  39.  
  40. <form method="POST" action="#">
  41. <input name="postanskiBroj" placeholder="postanskiBroj"><br>
  42. <button name="submit" type="submit">Posalji</button>
  43. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement