48 lines
No EOL
1.7 KiB
PHP
48 lines
No EOL
1.7 KiB
PHP
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=0;
|
|
error_reporting(E_ALL); ini_set('display_errors',1);
|
|
|
|
$abfrage = $GLOBALS['mysql']->query("SELECT * FROM tanken ORDER BY diesel"); $key=0;
|
|
while($row = $abfrage->fetch_assoc()) {
|
|
$tankdata[$key]['e5']=substr($row['e5'], 0, -1);
|
|
$tankdata[$key]['e5x']=substr($row['e5'], -1, 1);
|
|
$tankdata[$key]['e10']=substr($row['e10'], 0, -1);
|
|
$tankdata[$key]['e10x']=substr($row['e10'], -1, 1);
|
|
$tankdata[$key]['diesel']=substr($row['diesel'], 0, -1);
|
|
$tankdata[$key]['dieselx']=substr($row['diesel'], -1, 1);
|
|
$tankdata[$key]['name']=$row['name'];
|
|
$tankdata[$key]['open']=$row['open'];
|
|
$tankdata[$key]['kname']=$row['kname'];
|
|
$tankdata[$key]['street']=$row['street'];
|
|
$tankdata[$key]['ort']=$row['ort'];
|
|
$tankdata[$key]['hnr']=$row['hnr'];
|
|
$tankdata[$key]['plz']=$row['plz'];
|
|
$key++;
|
|
}
|
|
|
|
$abfrage2 = $GLOBALS['mysql']->query("SELECT * FROM tanken WHERE anzid>0 ORDER BY diesel"); $key=0;
|
|
while($row = $abfrage2->fetch_assoc()) {
|
|
$tankdata2[$key]['e5']=substr($row['e5'], 0, -1);
|
|
$tankdata2[$key]['e5x']=substr($row['e5'], -1, 1);
|
|
$tankdata2[$key]['e10']=substr($row['e10'], 0, -1);
|
|
$tankdata2[$key]['e10x']=substr($row['e10'], -1, 1);
|
|
$tankdata2[$key]['diesel']=substr($row['diesel'], 0, -1);
|
|
$tankdata2[$key]['dieselx']=substr($row['diesel'], -1, 1);
|
|
$tankdata2[$key]['name']=$row['name'];
|
|
$tankdata2[$key]['open']=$row['open'];
|
|
$tankdata2[$key]['kname']=$row['kname'];
|
|
$tankdata2[$key]['street']=$row['street'];
|
|
$tankdata2[$key]['ort']=$row['ort'];
|
|
$tankdata2[$key]['hnr']=$row['hnr'];
|
|
$tankdata2[$key]['plz']=$row['plz'];
|
|
$key++;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('tankdata',$tankdata);
|
|
$template->assign('tankdata2',$tankdata2);
|
|
$template->assign('content', 'tpl/tankstellen.tpl');
|
|
?>
|