<?php
error_reporting(E_ALL | E_STRICT);
ini_set("display_errors", 1);
require_once("models/config.php");
if (!securePage($_SERVER['SCRIPT_NAME'])){die();}
require_once("models/header.php");
if(!isUserLoggedIn()) { header("Location: login.php"); die(); }
$connection = mysqli_connect('xxx','xxx','xxx','xxx');
if (isset($_POST['vorname']))
{
$conditions = array();
foreach ($_POST as $name => $value)
{
// Submit-Button ausschließen
if ($name == "submit")
continue;
if (! empty($value))
$conditions[] = "`$name` like '%" . mysqli_real_escape_string($connection, $value) . "%'";
}
$query = "Select
`firma`,
`vorname`,
`nachname`,
`homepage`,
`telefonnummer`,
`adresse`,
`plz`,
`wohnort`,
`email`
FROM
`uc_users`";
if (count($conditions))
$query .= " where " . implode(" or ", $conditions);
$result = mysqli_query($connection, $query)
or die ("MySQL-Fehler: " . mysqli_error($connection));
}
?>
<html>
<head>
</head>
<body>
<div id='wrapper'>
<div id='top'>
<div id='logo'>
<img src='models/site-templates/images/logo_new.png' alt='logo'/>
</div>
</div>
<div id='navi'>
<?php include("navi.php")?>
</div>
</div>
<div id='content'>
<div id='main'>
<h2>suche</h2>
<article>
Hier können sie Benutzer suchen.
</article>
<br />
<br />
<form action="<?php echo $_SERVER['SCRIPT_NAME']; ?>" method="post">
<label style="width:120px;">Firma:</label>
<input name="firma" type="text" size="20" maxlength="88"> <br /><br />
<label style="width:120px;">Vorname:</label>
<input name="vorname" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Nachname:</label>
<input name="nachname" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Homepage:</label>
<input name="homepage" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Telefonnummer:</label>
<input name="telefonnummer" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Adresse:</label>
<input name="adresse" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">PLZ:</label>
<input name="plz" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Wohnort:</label>
<input name="wohnort" type="text" size="20" maxlength="88"><br /><br />
<label style="width:120px;">Email:</label>
<input name="email" type="text" size="20" maxlength="88"><br /><br />
<input name="submit" type="submit" value="Suchen">
<br /><br />
</form>
<div>
<?php
$query = 'SELECT bla FROM blubb';
if ($result = mysqli_query($connection, $query))
{
while ($row = mysqli_fetch_assoc($result))
{
$firma = $row["firma"];
$vorname = $row["vorname"];
$nachname = $row["nachname"];
$homepage = $row["homepage"];
$telefonnummer = $row["telefonnummer"];
$adresse = $row["adresse"];
$plz = $row["plz"];
$wohnort = $row["wohnort"];
$email = $row["email"];
$result .= "Firma: $firma";
}
}
else {
$result = "<p>0 Ergebnisse für Ihre Suchanfrage.</p><br />";
}
?>
</div>
</div>
</body>
</html>
<?php echo $result; ?>
$result = mysqli_query($connection, $query)
or die ("MySQL-Fehler: " . mysqli_error($connection));
}
// das hier kannst du ganz oben in deinem Script direkt nach mysqli_query() machen
if (mysqli_num_rows($result) > 0) {
$sOutput = "";
while ($row = mysqli_fetch_assoc($result)) {
$sOutput .= $row["firma"]."<br>";
}
} else {
$sOutput = "<p>0 Ergebnisse für Ihre Suchanfrage.</p><br />";
}
// ....
// und das dann am Ende, wo die Daten ins HTML ausgegeben werden sollen.
echo $sOutput ;
Notice: Undefined variable: result in .../suche.php on line 47
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in .../suche.php on line 47
if (mysqli_num_rows($result) > 0) {
$result = mysqli_query($connection, $query)
or die ("MySQL-Fehler: " . mysqli_error($connection));
}
$query .= " where " . implode(" or ", $conditions);
Notice: Undefined variable: result in .../suche.php on line 47
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in .../suche.php on line 47
kopfschüttel kopfschüttel 
..
0 Ergebnisse für Ihre Suchanfrage.
Kommentar