Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <style>
- table {
- margin-top: 3%;
- border-collapse: collapse;
- width: 100%;
- color: #b56161;
- font-family: monospace;
- font-size: 25px;
- text-align: left;
- border: 3px solid #b56161;
- }
- th {
- background-color: #b56161;
- color: white;
- }
- tr:nth-child(even) {background-color: #f2f2f2}
- </style>
- <table>
- <tr>
- <th>ID</th>
- <th>Ime</th>
- <th>Prezime</th>
- <th>Datum</th>
- <th>Grad</th>
- </tr>
- </div>
- </div>
- </div>
- </body>
- </html>
- <?php
- $korisnik = $_POST['Korisnik'];
- $lozinka = $_POST['Lozinka'];
- $host="localhost"; // Host name
- $username="root"; // Mysql username
- $password=''; // Mysql password
- $db_name="myproject"; // Database name
- $tbl_name="users"; // Table name
- // connect to database
- $con = mysqli_connect("$host","$username","$password", "$db_name");
- $podaci = "SELECT ID, Ime, Prezime, Datum, Grad FROM users";
- $rezultat = $con->query($podaci);
- //mysqli_select_db("$con", "admin");
- // Query the database for user
- $result = mysqli_query($con,"SELECT * FROM admin WHERE Korisnik = '$korisnik' and Lozinka = '$lozinka'")
- or die("Failed" .mysqli_error($con));
- $row = mysqli_fetch_array($result);
- //if ($row['Korisnik'] == $korisnik && $row['Lozinka'] == $lozinka) {
- if ($row['Korisnik'] == $korisnik && $row['Lozinka'] == $lozinka && $result->num_rows > 0){
- while($row = $rezultat->fetch_assoc()) {
- echo "<tr><td>" . $row["ID"] . "</td><td>" . $row["Ime"] . "</td><td>" . $row["Prezime"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Grad"] . "</td>"
- . "</td></tr>";
- }
- echo "</table>";
- }
- else{
- echo "Neuspjela prijava!";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement