Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <!--
- To change this license header, choose License Headers in Project Properties.
- To change this template file, choose Tools | Templates
- and open the template in the editor.
- -->
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <?php
- echo '<a href="http://kresosusec.com.hr">'.'Početna'.'</a>'.'<br>';
- require 'konekcija.php';
- $abeceda=array('A','B','C','Č','Ć','D','Dž','E','F','G','H','I','J','K',
- 'L','Lj','M','N','Nj','O','P','R','S','Š','T','U','V','Z','Ž');
- foreach($abeceda as $key=>$val)
- {
- echo '<a href="index.php?slovo='.$val.'">'.$val.'</a>|';
- }
- if(isset($_GET['slovo']))
- {
- $slovo=$_GET['slovo'];
- $query="select m.nazMjesto,z.nazZupanija,
- sum(case when m.pbr=s.pbrRod then 1 else 0 end) as rodjenih,
- sum(case when m.pbr=s.pbrStan then 1 else 0 end) as stanuju,
- max(floor(datediff(now(),s.datRodStud)/365.25)) as najstariji,
- min(floor(datediff(now(),s.datRodStud)/365.25)) as najmladji
- from mjesto m
- left outer join zupanija z
- on m.sifZupanija=z.sifZupanija
- left outer join stud s
- on m.pbr=s.pbrRod or m.pbr=s.pbrStan
- where m.nazMjesto like '$slovo%'
- group by m.nazMjesto,z.nazZupanija
- order by m.nazMjesto";
- $result= mysqli_query($link, $query);
- $numRows= mysqli_num_rows($result);
- if($numRows==0)
- {
- echo '<br>'.'Za birano slovo '.'<b><i>'.$slovo.'</b></i>'.
- ' nema nikakvih rezultata'.'<br>';
- }
- else
- {
- echo '<br>';
- echo '<table border="2">';
- echo '<tr><th>'.' '.'<th>'.
- 'Mjesto'.'<th>'.
- 'Županija'.'<th>'.
- 'Rođenih'.'<th>'.
- 'Stanuju'.'<th>'.
- 'Najstariji'.'<th>'.
- 'Najmlađi'.'<tr>';
- $x=0;
- while($row= mysqli_fetch_assoc($result))
- {
- switch($row['najstariji'])
- {
- case NULL:
- $najstariji=0;
- break;
- default:
- $najstariji=$row['najstariji'];
- break;
- }
- switch($row['najmladji'])
- {
- case NULL:
- $najmladji=0;
- break;
- default :
- $najmladji=$row['najmladji'];
- break;
- }
- $x=$x+1;
- echo '<tr><td>'.$x.'<td>'.
- $row['nazMjesto'].'<td>'.
- $row['nazZupanija'].'<td>'.
- $row['rodjenih'].'<td>'.
- $row['stanuju'].'<td>'.
- $najstariji.'<td>'.
- $najmladji.'<tr>';
- }
- echo '</table>';
- }
- }
- else
- {
- echo '<br>'.'Odaberi neko slovo'.'<br>';
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement