-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathindex.php
126 lines (123 loc) · 4.63 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
if (isset($_POST["dodaj"])) {
try {
include_once 'spajanje_na_bazu.php';
include_once 'unos_u_bazu.php';
}
catch (Exception $e) { ?>
<meta charset="UTF-8">
<h4>Provjerite točnost unesenih podataka.</h4>
<h4><a href="index.php">Natrag</a></h4>
<?php
die;
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Popis naselja u Republici Hrvatskoj</title>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="css/stil.css">
</head>
<body>
<h1>Popis naselja u Republici Hrvatskoj</h1>
<div class="section group">
<div class="col span_1_of_2">
<form method="post" action="preuzimanje_json.php">
<fieldset>
<legend>Preuzimanje popisa u JSON formatu</legend>
<input type="submit" value="Preuzmi JSON" name="preuzmi" />
</fieldset>
</form>
<br />
<form method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>" enctype="multipart/form-data" accept=".json" >
<fieldset>
<legend>Unos izravno u bazu podataka (JSON -> SQL)</legend>
<label for ="host">Host*</label>
<br />
<input type="text" name="host" id="host" required="required" value="<?php echo isset($_POST['host']) ? ($_POST['host']) : "" ?>" required="required" placeholder="localhost"/>
<br /><br />
<label for ="imebaze">Naziv baze podataka*</label>
<br />
<input type="text" name="imebaze" id="imebaze" value="<?php echo isset($_POST['imebaze']) ? ($_POST['imebaze']) : "" ?>" required="required" />
<br /><br />
<label for ="nazivtablice">Naziv tablice*</label>
<br />
<input type="text" name="nazivtablice" id="nazivtablice" value="<?php echo isset($_POST['nazivtablice']) ? ($_POST['nazivtablice']) : "" ?>" required="required" />
<br /><br />
<label for ="korisnickoime">Korisničko ime pristupa bazi podataka*</label>
<br />
<input type="text" name="korisnickoime" id="korisnickoime" value="<?php echo isset($_POST['korisnickoime']) ? ($_POST['korisnickoime']) : "" ?>" required="required"/>
<br /><br />
<label for ="lozinka">Lozinka pristupa bazi podataka</label>
<br />
<input type="password" name="lozinka" id="lozinka" value="<?php echo isset($_POST['lozinka']) ? ($_POST['lozinka']) : "" ?>"/>
<br /><br />
<label for ="datoteka">JSON datoteka**</label>
<br />
<input type="file" name="datoteka" id="datoteka" required="required"/>
<br /><br />
<input type="submit" value="Unesi u bazu podataka" name="dodaj" class="siroko" id="dodaj" onclick="promjena()"/>
<p>* Obavezan unos <br /> ** Odabrati <i>popis_naselja_u_republici_hrvatskoj.json</i> u mapi <i>json</i></p>
</fieldset>
</form>
</div>
<div class="col span_1_of_2">
<?php if (isset($poruka)): ?>
<fieldset>
<legend>Prikaz</legend>
<h4>Popis naselja u RH uspješno je unesen u bazu podataka <i><?php echo $_POST["imebaze"] ?></i>.<br />Prikazano je prvih 10 redova tablice <i><?php echo $_POST["nazivtablice"]; ?></i>.</h4>
<table style="width:100%" border="1" cellpadding="5px">
<thead>
<tr>
<th>Poštanski broj</th>
<th>Mjesto</th>
<th>Općina</th>
<th>Županija</th>
</tr>
</thead>
<tbody>
<?php
$veza->beginTransaction();
$izraz=$veza->prepare("select * from nazivtablice limit 10");
$izraz->bindParam("nazivtablice",$_POST["nazivtablice"]);
$izraz->execute();
$rezultati = $izraz->fetchAll(PDO::FETCH_OBJ);
foreach ($rezultati as $red):
?>
<tr>
<td><?php echo $red->postanskiBroj ?></td>
<td><?php echo $red->mjesto ?></td>
<td><?php echo $red->opcina ?></td>
<td><?php echo $red->zupanija ?></td>
</tr>
<?php
endforeach;
$izraz=$veza->prepare("select count(*) from nazivtablice");
$izraz->bindParam("nazivtablice",$_POST["nazivtablice"]);
$izraz->execute();
$ukupno = $izraz->fetchColumn();
$veza->commit();
?>
<tr>
<td colspan="4"><?php echo "Ukupno zapisa: " . $ukupno ?></td>
</tr>
</tbody>
</table>
<br /><br />
</fieldset>
<?php endif; ?>
</div>
</div>
<hr />
<h4 class="centar"><a target="_blank" href="https://hr.linkedin.com/in/nikoladjekic">© Nikola Đekić | <?php echo date("Y") . "."; ?></a></h4>
</body>
<script type="text/javascript">
function promjena(){
var elem = document.getElementById("dodaj");
if (elem.value=="Unesi u bazu podataka") elem.value = "Molim pričekajte ...";
else elem.value = "Unesi u bazu podataka";
}
</script>
</html>