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
- class model
- {
- function pohranaPodataka()
- {
- require 'konekcija.php';
- if(isset($_GET['broj']))
- {
- $broj=$_GET['broj'];
- $pocetno=($broj-1)*15;
- $y=($broj-1)*15;
- }
- else
- {
- $broj=1;
- $pocetno=0;
- $y=0;
- }
- $query="select u.mbrStud,u.imeStud,u.prezStud,
- round(avg(o.ocjena),2) as prosjek
- from ucenici u
- left outer join ocjene o
- on u.mbrStud=o.mbrStud
- group by u.mbrStud
- limit $pocetno,15";
- $result=mysqli_query($link,$query);
- while($row=mysqli_fetch_assoc($result))
- {
- $pod[]=array('mbrStud'=>$row['mbrStud'],
- 'imeStud'=>$row['imeStud'],
- 'prezStud'=>$row['prezStud'],
- 'prosjek'=>$row['prosjek']);
- }
- $query2="select mbrStud from ucenici";
- $result2=mysqli_query($link,$query2);
- $numRows=mysqli_num_rows($result2);
- $total=ceil($numRows/15);
- $x=0;
- $p=array('pod'=>$pod,
- 'y'=>$y,
- 'total'=>$total,
- 'broj'=>$broj);
- return $p;
- }
- }
- class view
- {
- function ispisPodataka($p)
- {
- echo '<center>';
- echo '<a href="https://kresosusec.com.hr">'.'Početna'.'</a>'.'<br>';
- echo '<table border="2">';
- echo '<tr><th>'.''.'<th>'.
- 'MBR'.'<th>'.
- 'Ime'.'<th>'.
- 'Prezime'.'<th>'.
- 'Prosjek'.'<tr>';
- foreach($p['pod'] as $key=>$val)
- {
- $p['y']=$p['y']+1;
- $mbr='<a href="predmeti.php?mbr='.$val['mbrStud'].'&prosjek='.$val['prosjek'].'">'.$val['prosjek'].'</a>';
- echo '<tr><td>'.$p['y'].'<td>'.
- $val['mbrStud'].'<td>'.
- $val['imeStud'].'<td>'.
- $val['prezStud'].'<td>'.
- $mbr.'<tr>';
- }
- echo '</table>';
- if($p['broj']<$p['total'])
- {
- echo '<a href="index.php?broj='.($p['broj']+1).'">'.'Naprijed'.'</a>'.'<br>';
- }
- else
- {
- echo '<a href="index.php">'.'Naprijed'.'</a>'.'<br>';
- }
- for($x=1;$x<=$p['total'];$x=$x+1)
- {
- echo '<a href="index.php?broj='.$x.'">'.$x.'</a>|';
- }
- if($p['broj']>1)
- {
- echo '<br>'.'<a href="index.php?broj='.($p['broj']-1).'">'.'Natrag'.'</a>';
- }
- else
- {
- echo '<br>'.'<a href="index.php">'.'Natrag'.'</a>';
- }
- }
- }
- class controler
- {
- public $_Model;
- public $_View;
- function __construct()
- {
- $this->_Model=new model;
- $this->_View=new view();
- }
- function start()
- {
- $p= $this->_Model->pohranaPodataka();
- $this->_View->ispisPodataka($p);
- }
- }
- $pokreni=new controler();
- $pokreni->start();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement