60 lines
1.9 KiB
PHP
60 lines
1.9 KiB
PHP
<?php
|
|
header('Content-Type: text/html; charset=utf-8');
|
|
$connect = mysqli_connect(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
mysqli_set_charset($connect, 'utf8');
|
|
|
|
$output = ' '; $testnr = 0; $ausgabe = 0; $menge=0;
|
|
if(isset($_POST["query"]))
|
|
{
|
|
$search = mysqli_real_escape_string($connect, $_POST["query"]);
|
|
$query = "
|
|
SELECT * FROM ilonexs
|
|
WHERE name LIKE '%".$search."%'
|
|
OR label LIKE '%".$search."%'
|
|
ORDER BY date"; $menge=200;
|
|
} else {
|
|
$query = "
|
|
SELECT * FROM ilonexs ORDER BY id DESC"; $menge=20;
|
|
}
|
|
$result = mysqli_query($connect, $query);
|
|
if(mysqli_num_rows($result) > 0) {
|
|
$output .= '<table class="table-hover" style="font-size:13pt">';
|
|
while($row = mysqli_fetch_array($result)) {
|
|
if($ausgabe<$menge) {
|
|
//if($testnr!=$row["id"]) {
|
|
$maid=$row["id"];
|
|
$testnr=$row["id"]; $ausgabe++;
|
|
$kname=substr($row["name"], 0,28);
|
|
$output .='
|
|
<tr style="color: #aaa;font-size:10pt" onclick="om('.$maid.')">
|
|
<td nowrap style="width:90px" align="left" onclick="om(".$maid.")"> '.$row["date"].'</td>
|
|
<td nowrap style="color: #ccc;width:140px" align="left" onclick="om($maid)"> '.$row["label"].'</td>
|
|
<td nowrap style="width:220px" align="left" onclick="om(".$maid.")"> '.$kname.'</td>
|
|
<td nowrap style="width:60px" align="left" onclick="om(".$maid.")"> '.$row["plz"].'</td>
|
|
<td nowrap style="width:160px" align="left" onclick="om(".$maid.")"> '.$row["ort"].'</td>
|
|
<td nowrap style="width:200px" align="left" onclick="om(".$maid.")"> '.$row["statustext1"].'</td>
|
|
</tr>
|
|
';
|
|
// }
|
|
}
|
|
}
|
|
echo $output;
|
|
} else {
|
|
echo 'keine Sendungen gefunden';
|
|
}
|
|
?>
|
|
<script>
|
|
function om(id) {
|
|
$.ajax({
|
|
type: 'POST',
|
|
url: "ajax.php?s=ue_iloscan&tpl",
|
|
dataType: 'html',
|
|
data: '&id=' + id,
|
|
success: function (data) {
|
|
console.log(data)
|
|
$("#ilomodal").html(data);
|
|
$('#modal').modal('show');
|
|
}
|
|
});
|
|
}
|
|
</script>
|