Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta charset="UTF-8">
- </head>
- <body>
- <?php
- echo "<h3>Dohvat mail adresa za zadano mjesto</h3>";
- echo '<form action="#" method="post">
- Unesite poštanski broj:
- </br>
- <input type="text" name="naziv"/>
- <input type="submit" value="Dohvati"/>
- </form>
- ';
- if (isset($_POST['naziv']))
- {
- $host="localhost";
- $user="admin";
- $pass="jura";
- $link = mysqli_connect ($host, $user, $pass)
- or die ("Neuspjesno spajanje na server");
- $link2=mysqli_select_db ($link, "radionica");
- mysqli_query($link, "SET CHARACTER SET utf8");
- $upit=mysqli_query($link, "SELECT imeRadnik,prezimeRadnik,CONCAT(imeRadnik, '.', prezimeRadnik, '@autoservis.com') AS mailadresa FROM radnik
- WHERE pbrStan='10000' ");
- echo "<h3>Popis mail adresa za mjesto ".$_POST['naziv'].":</h3></br>";
- echo <<< EOT
- <table border="1" style="border-collapse:collapse;">
- <tr>
- <th> Ime klijenta </th>
- <th> Prezime klijenta </th>
- <th> Mail </th>
- </tr>
- EOT;
- while($row=mysqli_fetch_array($upit)){
- echo <<< EOT
- <tr>
- <td> {$row['imeRadnik']} </td>
- <td> {$row['prezimeRadnik']} </td>
- <td> {$row['mailadresa']} </td>
- </tr>
- EOT;
- }
- echo "</table>";
- }
- echo '<h1>PETI </h1>';
- ?>
- </body>
- </html>
- ------------------------------------------------------------------------------
- <!-- 2. Napisati PHP skriptu koja će se spojiti na poslužitelj na kojem se nalazi vaša baza podataka o automehaničarskoj radionici,
- te na bazu. Podatke za spajanje (ime poslužitelja, ime baze, korisničko ime i lozinka) potrebno je samostalno definirati u skladu s postavkama
- na vlastitom računalu.
- Skripta mora omogućiti unos novog kvara u tablicu kvar (svih potrebnih atributa). -->
- <!DOCTYPE HTML>
- <html>
- <head><meta charset="UTF-8"></head>
- <body>
- <?php
- echo "<center><h3>Unesi novi kvar: </h3></center>";
- echo '<center><form action="#" method="post" style="border: 1px solid black; text-align:center; width:50%;">
- Šifra kvara:
- <input type="text" name="sifra"/></br></br>
- Naziv kvara:
- <input type="text" name="naziv"/></br></br>
- Šifra odjela:
- <input type="text" name="odjel"/></br></br>
- Broj radnika:
- <input type="text" name="brRadnik"/></br></br>
- Broj sati:
- <input type="text" name="brSati"/> </br>
- <input type="submit" value="Unesi"/>
- </form></center>
- ';
- $host = "localhost";
- $user = "root";
- $pass = "e549e4cb";
- $db = "radionica";
- $link = mysqli_connect ($host, $user, $pass, $db) or die ("Neuspješno povezivanje s bazom podataka!");
- $sifrica = $_POST['sifra'];
- $nazivko = $_POST['naziv'];
- $odjelcic= $_POST['odjel'];
- $brR = $_POST['brRadnik'];
- $brS = $_POST['brSati'];
- $upit=mysqli_query($link, "INSERT INTO `kvar`(`sifKvar`,`nazivKvar`,`sifOdjel`,`brojRadnika`,`satiKvar`)
- VALUES ('$sifrica', '$nazivko', '$odjelcic', '$brR', '$brS');");
- $link->close();
- ?>
- </body>
- </html>
- ------------------------------------------------------------------------------------------------------
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta charset="UTF-8">
- </head>
- <body>
- <?php
- echo "<h3>Dohvat mail adresa za zadano mjesto</h3>";
- echo '<form action="#" method="post">
- Unesite poštanski broj:
- </br>
- <input type="text" name="naziv"/>
- <input type="submit" value="Dohvati"/>
- </form>
- ';
- if (isset($_POST['naziv']))
- {
- $host="localhost";
- $user="admin";
- $pass="jura";
- $link = mysqli_connect ($host, $user, $pass)
- or die ("Neuspjesno spajanje na server");
- $link2=mysqli_select_db ($link, "radionica");
- mysqli_query($link, "SET CHARACTER SET utf8");
- $upit=mysqli_query($link, "SELECT * FROM treci "
- );
- echo "<h3> Popis mail adresa za mjesto ".$_POST['naziv'].":</h3> </br>";
- echo <<< EOT
- <table border="1" style="border-collapse:collapse;">
- <tr>
- <th> Sifra </th>
- <th> Naziv </th>
- <th> Brojcek </th>
- </tr>
- EOT;
- while($row=mysqli_fetch_array($upit)){
- echo <<< EOT
- <tr>
- <td> {$row['sifZupanija']} </td>
- <td> {$row['nazivZupanija']} </td>
- <td> {$row['brojccek']} </td>
- </tr>
- EOT;
- }
- echo "</table>";
- }
- ?>
- </body>
- </html>
- -----------------------------------------------------------------------------------------------------------
- 2. 2
- <!DOCTYPE html>
- <head>
- <meta charset="UTF-8">
- </head>
- <body>
- <h1>Unos novog kvara</h1>
- <?php
- echo'<form action="#" method="post">
- <input name="sifKvar" placeholder="Sifra kvara" required><br>
- <input name="nazivKvar" placeholder="Naziv kvara" required><br>
- <input name="sifOdjel" placeholder="Sifra odjela" required><br>
- <input name="brojRadnika" placeholder="Broj radnika" required><br>
- <input name="satiKvar" placeholder="Sati kvara" required><br>
- <button type="sumbit" name="submit">Dodaj</button>
- </form>';
- $hostname = "localhost";
- $username = "root";
- $password = "123456789";
- $database = "radionica";
- $link = mysqli_connect($hostname, $username, $password, $database) or die(mysqli_error($link));
- mysqli_query($link, "SET CHARACTER SET cp1250");
- if($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['submit'])){
- $sifKvar = (int)$_POST['sifKvar'];
- $nazivKvar = $_POST['nazivKvar'];
- $sifOdjel = (int)$_POST['sifOdjel'];
- $brojRadnika = (int)$_POST['brojRadnika'];
- $satiKvar = (int)$_POST['satiKvar'];
- $res = mysqli_query($link, "INSERT INTO kvar(sifKvar, nazivKvar, sifOdjel, brojRadnika, satiKvar)
- VALUES(".$sifKvar.", '".$nazivKvar."', ".$sifOdjel.", ".$brojRadnika.", ".$satiKvar.")") or die(mysqli_error($link));
- echo "<h2>Dodano!</h2>";
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement