Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <head>
- <title>Zadatak 5</title>
- <meta charset="utf-8">
- <style>
- table, td, th{
- border: 1px solid black;
- }
- </style>
- </head>
- <body>
- <p align="justify">Riješiti prethodni zadatak pozivom MySQL pohranjenog zadatka tj. funkcije i / ili procedure (koja će dohvaćati traženo ime i prezime), sa korisnikom koji ima dozvolu samo nad pohranjenim zadatkom:</p>
- <p>- Poslužitelj: localhost</p>
- <p>- Korisnik: admin2</p>
- <p>- Lozinka: jura2</p>
- <h2>FORMA ZA UNOS MJESTA KLIJENTA</h>
- <form action="zadatak5.php" method="POST">
- <p>Mjesto stanovanja (poštanski broj): <input type="number" name="pbrMjesto" min="0" placeholder="pbrMjesto" required></p>
- <button name="submit" type="submit">NAĐI ZADNJI NALOG</button>
- </form>
- <?php
- //GRANT SELECT ON autoradionica.mjesto TO 'admin2'@'localhost' IDENTIFIED BY 'jura2';
- //GRANT SELECT ON autoradionica.klijent TO 'admin2'@'localhost' IDENTIFIED BY 'jura2';
- //GRANT SELECT ON autoradionica.nalog TO 'admin2'@'localhost' IDENTIFIED BY 'jura2';
- if(isset($_POST['submit'])){
- $server = "localhost";
- $username = "admin2";
- $password = "jura2";
- $database = "autoradionica";
- $port = 3307;
- $conn = mysqli_connect($server, $username, $password, $database, $port);
- if(!$conn){
- die("Neuspjelo spajanje na bazu: " . $database . " - " . mysqli_connect_error());
- } else {
- echo "<h3>Uspješno spajanje na bazu " . $database . "!</h3>";
- }
- $sql = "CALL dohvatKlijenta(" . $_POST['pbrMjesto'] . ");";
- $result = mysqli_query($conn, $sql);
- if(mysqli_num_rows($result) > 0){
- echo "<table>
- <tr>
- <td>Ime klijenta</td>
- <td>Prezime klijenta</td>
- <td>Mjesto stanovanja klijenta</td>
- <td>Datum primitka naloga</td>
- </tr>";
- while($row = mysqli_fetch_assoc($result)){
- echo "<tr><td>" . $row['imeKlijent'] . "</td><td>" . $row['prezimeKlijent'] . "</td><td>" . $row['pbrKlijent'] . "</td><td>" . $row['datPrimitkaNalog'] . "</td></tr>";
- }
- echo "</table>";
- } else {
- echo "<h3>Zahtjevani upit - " . $sql . " - nema rezultata!</h3>";
- }*/
- mysqli_close($conn);
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement