105 lines
3.3 KiB
PHP
Executable File
105 lines
3.3 KiB
PHP
Executable File
<?php
|
|
require_once("../config.inc.php");
|
|
$db = dbconnect();
|
|
$result1 = $db->query("SELECT dst_id, bezeichnung, name, str, plz, ort, mail, date_format(gueltig_von, '%d.%m.%Y') gueltig_von_form, date_format(gueltig_bis, '%d.%m.%Y') gueltig_bis_form, gueltig_von, gueltig_bis
|
|
FROM dvm_dienststellen
|
|
WHERE upper(name) LIKE '%" . strtoupper($_GET['search']) . "%'
|
|
OR plz LIKE '%" . $_GET['search'] . "%'
|
|
OR bezeichnung LIKE '%" . $_GET['search'] . "%'
|
|
ORDER BY name ASC");
|
|
echo "<table width='100%' border='1' cellspacing='0' cellpadding='0'>
|
|
<tr>
|
|
<td style='padding-left:5px'>
|
|
<b>#</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Behördenart</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Name</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Straße</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>PLZ</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Ort</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Mailadresse</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Gültig von</b>
|
|
</td>
|
|
<td style='padding-left:5px'>
|
|
<b>Gültig bis</b>
|
|
</td>
|
|
<td align='center'>
|
|
<b>Edit</b>
|
|
</td>
|
|
</tr>
|
|
";
|
|
|
|
while($row = $result1->fetch_array())
|
|
{
|
|
if($row['gueltig_von'] != '0000-00-00'){
|
|
$gueltig_von = $row['gueltig_von_form'];
|
|
}else{
|
|
$gueltig_von = '';
|
|
}
|
|
|
|
if($row['gueltig_bis'] != '0000-00-00'){
|
|
$gueltig_bis = $row['gueltig_bis_form'];
|
|
}else{
|
|
$gueltig_bis = '';
|
|
}
|
|
|
|
|
|
$lnnr++;
|
|
echo '<tr>';
|
|
echo '<td style="padding-left:5px">';
|
|
echo $lnnr;
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['bezeichnung']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['name']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['str']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['plz']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['ort']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $row['mail']);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $gueltig_von);
|
|
echo '</td>';
|
|
|
|
echo '<td style="padding-left:5px">';
|
|
echo preg_replace('/(' . $_GET['search'] . ')/Usi', '<span class="result">\\1</span>', $gueltig_bis);
|
|
echo '</td>';
|
|
|
|
echo '<td align="center">';
|
|
echo '<a href=?edit='.$row['dst_id'].'><img title = "Stelle bearbeiten" border="0" height=10 src="../templates/modern/images/edit.png"></a>';
|
|
echo '</td>';
|
|
echo '</tr>';
|
|
}
|
|
echo "</table>";
|
|
?>
|