";
echo "EASYSPIDER
";
echo '
';
if(isset($search)){
if ( strlen($search) < "3" ) {
echo "Mindestens 3 Zeichen eingeben!\n";
exit(0);
}
#$search_words = explode(" ", $search);
$db_link = mysql_pconnect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASS) OR die("Keine Verbindung zur Datenbank. Fehlermeldung:".mysql_error());
mysql_select_db($MYSQL_DATABASE, $db_link) OR die("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());
if ($metakeys == "1") {
$meta_sql_query = "
SELECT DISTINCT metakeys_keywords, metakeys_description, metakeys_author, metakeys_rest
FROM easyspider
WHERE `metakeys_keywords` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `metakeys_description` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `metakeys_author` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `metakeys_rest` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
LIMIT 0 , 30";
$meta_sql_results = mysql_query($meta_sql_query, $db_link);
if(!$meta_sql_results) { // prüfen auf false
echo "Konnte die MySQL-Abfrage nicht verarbeiten
\n";
echo "MySQL-Antwort:".mysql_error();
die();
}
while($row = mysql_fetch_array($meta_sql_results)) {
$metakeys = explode(" ", $row["metakeys_keywords"]);
$description = explode(" ", $row["metakeys_description"]);
$author = explode(" ", $row["metakeys_author"]);
$rest = explode(" ", $row["metakeys_rest"]);
echo " METAKEYS
";
foreach ( $metakeys as $line ) {
echo " $line
";
}
echo "
DESCRIPTION
";
foreach ( $description as $line ) {
echo " $line
";
}
echo "
AUTHOR
";
foreach ( $author as $line ) {
echo " $line
";
}
echo "
REST
";
foreach ( $rest as $line ) {
echo " $line
";
}
echo "
";
}
} # if ($metakeys ) {}
if ($title == "1") {
$title_sql_query = "
SELECT DISTINCT title FROM easyspider
WHERE `title` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
LIMIT 0 , 30";
$title_sql_results = mysql_query($title_sql_query, $db_link);
if(!$title_sql_results) { // prüfen auf false
echo "Konnte die MySQL-Abfrage nicht verarbeiten
\n";
echo "MySQL-Antwort:".mysql_error();
die();
}
$row = mysql_fetch_array($title_sql_results);
echo "TITLE: " . $row["title"] . "
";
}
if ($headlines == "1") {
$head_sql_query = "
SELECT DISTINCT h1,h2,h3,h4,h5,h6
FROM easyspider
WHERE `h1` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `h2` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `h3` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `h4` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `h5` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `h6` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
LIMIT 0 , 30";
$head_sql_results = mysql_query($head_sql_query, $db_link);
if(!$head_sql_results) { // prüfen auf false
echo "Konnte die MySQL-Abfrage nicht verarbeiten
\n";
echo "MySQL-Antwort:".mysql_error();
die();
}
while($row = mysql_fetch_array($head_sql_results)) {
$h1 = explode(" ", $row["h1"]);
$h2 = explode(" ", $row["h2"]);
$h3 = explode(" ", $row["h3"]);
$h4 = explode(" ", $row["h4"]);
$h5 = explode(" ", $row["h5"]);
$h6 = explode(" ", $row["h6"]);
echo " HEADLINES-H1
";
foreach ( $h1 as $line ) {
echo " $line
";
}
echo "
HEADLINE-H2
";
foreach ( $h2 as $line ) {
echo " $line
";
}
echo "
HEADLINE-H3
";
foreach ( $h3 as $line ) {
echo " $line
";
}
echo "
HEADLINE-H4
";
foreach ( $h4 as $line ) {
echo " $line
";
}
echo "
HEADLINE-H5
";
foreach ( $h5 as $line ) {
echo " $line
";
}
echo "
HEADLINE-H6
";
foreach ( $h6 as $line ) {
echo " $line
";
}
echo "
";
}
}
if ($region == "1") {
$region_sql_query = "
SELECT DISTINCT region_name1, region_content1,region_name2, region_content2,region_name3, region_content3,region_name4, region_content4,region_name5, region_content5
FROM easyspider
WHERE `region_content1` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `region_content2` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `region_content3` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `region_content4` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `region_content5` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
LIMIT 0 , 30";
$region_sql_results = mysql_query($region_sql_query, $db_link);
if(!$region_sql_results) { // prüfen auf false
echo "Konnte die MySQL-Abfrage nicht verarbeiten
\n";
echo "MySQL-Antwort:".mysql_error();
die();
}
while($row = mysql_fetch_array($region_sql_results)) {
$r1 = explode(" ", $row["region_content1"]);
$r2 = explode(" ", $row["region_content2"]);
$r3 = explode(" ", $row["region_content3"]);
$r4 = explode(" ", $row["region_content4"]);
$r5 = explode(" ", $row["region_content5"]);
echo " REGION-" . $row["region_name1"] . "
";
foreach ( $r1 as $line ) {
rtrim($line);
echo " $line
";
}
echo " REGION-" . $row["region_name2"] . "
";
foreach ( $r2 as $line ) {
rtrim($line);
echo " $line
";
}
echo " REGION-" . $row["region_name3"] . "
";
foreach ( $r3 as $line ) {
rtrim($line);
echo " $line
";
}
echo " REGION-" . $row["region_name4"] . "
";
foreach ( $r4 as $line ) {
rtrim($line);
echo " $line
";
}
echo " REGION-" . $row["region_name5"] . "
";
foreach ( $r5 as $line ) {
rtrim($line);
echo " $line
";
}
echo "
";
}
}
if ($body == "1") {
$body_sql_query = "
SELECT DISTINCT gewichtung_5,gewichtung_15,gewichtung_30,gewichtung_50 FROM easyspider
WHERE `gewichtung_50` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `gewichtung_30` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `gewichtung_15` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
OR `gewichtung_5` LIKE CONVERT( _utf8 '%$search%' USING latin1 ) COLLATE latin1_swedish_ci
LIMIT 0 , 30";
$body_sql_results = mysql_query($body_sql_query, $db_link);
if(!$body_sql_results) { // prüfen auf false
echo "Konnte die MySQL-Abfrage nicht verarbeiten
\n";
echo "MySQL-Antwort:".mysql_error();
die();
}
while($row = mysql_fetch_array($body_sql_results)) {
$g50 = explode(" ", $row["gewichtung_50"]);
$g30 = explode(" ", $row["gewichtung_30"]);
$g15 = explode(" ", $row["gewichtung_15"]);
$g5 = explode(" ", $row["gewichtung_5"]);
echo " BODY-GEWICHTUNG-50%
";
foreach ( $g50 as $line ) {
echo " $line
";
}
echo "
BODY-GEWICHTUNG-30%
";
foreach ( $g30 as $line ) {
echo " $line
";
}
echo "
BODY-GEWICHTUNG-15%
";
foreach ( $g15 as $line ) {
echo " $line
";
}
echo "
BODY-GEWICHTUNG-5%
";
foreach ( $g5 as $line ) {
echo " $line
";
}
echo "
";
}
}
if ($complete == "1") {
echo "Bitte alle Radiobuttons markieren und auf suchen drücken!
";
}
mysql_close($db_link);
}
echo "