I created a customized search form with 2 different text fields and it works so far very fine.
My problem is: If the user enters an empty string and clicks on the submit button the tablename_view.php lists all the records!
Therefore I tried a php and javascript solution to show an allert, for example "You have to fill all fields!", but unfortunatelly it doesn't work!
Does anyone have an idea? here is my code:
In the hooks-folder my tablename_filter.php file (PHP validation is commented out!)
Code: Select all
<?php
/*
$feld1 = $_POST['FilterAnd'][1];
$feld2 = $_POST['FilterField'][1];
$feld1 = $_POST['FilterOperator'][1];
$feld1 = $_POST['FilterValue'][1];
echo "feld1 = " .$feld1."<br />";
echo "feld2 = " .$feld2."<br />";
echo "feld3 = " .$feld3."<br />";
echo "feld4 = " .$feld4."<br />";
if (isset($feld) && $feld != "") {
echo "Sehr gut!";
}
else {
if (isset($senden)) {
echo "Bitte alle Felder ausfuellen!!";
}
}
if (isset($senden)) {
echo "Halloooo???!!";
}
else {
if (isset($senden) or isset($feld) or empty($feld)) {
echo "Bitte alle Felder ausfuellen!";
}
}
*/
?>
<div style="text-align:center !important" class="TableTitle"><span id="table-title-img"><img align="top" src="table.gif"></span> NPS Kunden by Nikon IT<br /><br /></div>
<div id="npsfilter">
<table align="center">
<tr>
<!-- Filter fuer NPS-Nr. -->
<td style="font-family:verdana;font-size:16px:font-weight:bold;"><b>NPS-Nummer:</b></td>
<td><input name=FilterAnd[1] value='' type=hidden></td>
<td><input name=FilterField[1] value='1' type=hidden></td>
<td><input name=FilterOperator[1] value='<=>' type=hidden></td>
<td><input name=FilterValue[1] value='' type=text></td>
</tr>
<tr>
<td style="font-family:verdana;font-size:14px:font-weight:bold;">oder</td><td> </td>
</tr>
<tr>
<!-- Filter fuer Kunden-Nachname -->
<td style="font-family:verdana;font-size:16px:font-weight:bold;"><b>NPS-Kunden-Nachname:</b></td>
<td><input name=FilterAnd[2] value='' type=hidden></td>
<td><input name=FilterField[2] value='2' type=hidden></td>
<td><input name=FilterOperator[2] value='<=>' type=hidden></td>
<td><input name=FilterValue[2] value='' type=text></td>
</tr>
<tr>
<td> </td><td> </td><td> </td><td> </td><td><input id ="finden" type=submit name="senden" value="Finden"></td>
</tr>
</table>
</div>
<div class="TableFooter">
<?php
echo "Letzte NPS-Datenbank-Aktualisierung: " . date("d.m.Y - H:i", filemtime("importkunden/ybc.php"));
?>
</div>
Code: Select all
function nps_kunden_init(&$options, $memberInfo, &$args){
// Die neue individuelle Such-Seite aktivieren
$options->FilterPage = dirname(__FILE__).'/nps_kunden_filter.php';
return TRUE;
}
Yilmaz