Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /////////////////spajanje na bazu
- <?php
- $server = "localhost";
- $username = "root";
- $password = "";
- $dbname= "autoradionica";
- $conn = mysqli_connect($server, $username, $password, $dbname) or die("Nemogu se spojit");
- mysqli_set_charset($conn,"utf8");
- $sql = "SELECT ime, prezime FROM radnik";
- $query = mysqli_query($conn, $sql);
- while($row=mysqli_fetch_array($query)){
- echo "<tr><td>".$row["ime"].".".$row["prezime"]."@autoradionica.com</td></tr>";
- }
- mysqli_close($conn);
- ?>
- //////////////PREPARED STATEMENT
- $conn = mysqli_connect($server, $username, $password, $datbase) or die("Kill the Kardashians");
- $stmt = $conn->prepare("INSERT INTO kvar (sifKvar, nazivKvar, sifOdjel, brojRadnika, satiKvar) VALUES(?, ?, ?, ?, ?)");
- $stmt->bind_param("isiii", $sifKvar, $nazivKvar, $sifOdjel, $brojRadnika, $satiKvar);
- $sifKvar = $_POST["sifKvar"];
- $nazivKvar = $_POST["nazivKvar"];
- $sifOdjel = $_POST["sifOdjel"];
- $brojRadnika = $_POST["brojRadnika"];
- $satiKvar = $_POST["satiKvar"];
- $stmt->execute();
- ////////////////FORMA
- <form method="POST" action="#">
- <input name="postanskiBroj" placeholder="postanskiBroj"><br>
- <button name="submit" type="submit">Posalji</button>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement