Can someone point me in the right direction here?
Code: Select all
if(isset($_POST[company])){
$mysqli = new mysqli("localhost", "xxx", "xxx", "xxx");
$query = "SELECT * FROM wp_network_members WHERE company LIKE '%" . mysql_real_escape_string($_POST[company]) . "%'";
$result = mysqli_query($mysqli, $query) or die(mysqli_error());
while($row = mysqli_fetch_assoc($result)){
$search_results[] = $row;
}
foreach ($search_results as &$value) {
echo "<div class=\"networksearchitem\">" . "\n";
echo "<a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\"><img src=\"" . $value[headshot] . "\" class=\"networksearchimage\" /></a>" . "\n";
echo "<a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\"><img src=\"" . $value[logo] . "\" class=\"networksearchlogo\" /></a>" . "\n";
echo "<h3><a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\">" . $value[f_name] . " " . $value[l_name] . ", " . $value[company] . "</a></h3>" . "\n";
echo "<hr class=\"floatfixer\" />" . "\n";
echo "</div>" . "\n";
}
}
if(isset($_POST[l_name])){
$mysqli = new mysqli("localhost", "xxx", "xxx", "xxx");
$query = "SELECT * FROM wp_network_members WHERE l_name LIKE '%" . mysql_real_escape_string($_POST[l_name]) . "%'";
$result = mysqli_query($mysqli, $query) or die(mysqli_error());
while($row = mysqli_fetch_assoc($result)){
$search_results[] = $row;
}
foreach ($search_results as &$value) {
echo "<div class=\"networksearchitem\">" . "\n";
echo "<a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\"><img src=\"" . $value[headshot] . "\" class=\"networksearchimage\" /></a>" . "\n";
echo "<a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\"><img src=\"" . $value[logo] . "\" class=\"networksearchlogo\" /></a>" . "\n";
echo "<h3><a href=\"/" . strtolower($value[f_name]) . "-" . strtolower($value[l_name]) . "/\">" . $value[f_name] . " " . $value[l_name] . ", " . $value[company] . "</a></h3>" . "\n";
echo "<hr class=\"floatfixer\" />" . "\n";
echo "</div>" . "\n";
}
}
if (empty($_POST)){
echo '<form enctype="multipart/form-data" action="" method="post">';
echo '<input type="text" name="l_name" /><br />';
echo '<input type="text" name="company" /><br />';
echo '<input type="text" name="zip" /><br />';
echo '<input type="submit" value="Search" />';
echo '</form>';
}