WP Plugin

<?php
/*
Plugin Name: BankenFinder
Description: Listet alle Banken auf
*/

if (!defined('WPINC')){
    die;
}


add_shortcode("bankenfinder","bankenfinder");
function bankenfinder(){


// Verbindungsvariable samt Zugangsdaten festlegen
$db = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($db, "utf8");

// Verbindung überprüfen
if (mysqli_connect_errno()) {
  printf("Verbindung fehlgeschlagen: %s\n", mysqli_connect_error());
  exit();
}




$s = filter_input(INPUT_GET, 's', FILTER_SANITIZE_SPECIAL_CHARS);
#    $sql = "SELECT SQL_CALC_FOUND_ROWS *, ";
#    $sql .= "((5.0 * (MATCH(name,name2,name3,plz,ort,str) AGAINST ('Köln' IN BOOLEAN MODE))) ";
#    $sql .= ") AS relevance ";
#    $sql .= "FROM `bank` HAVING relevance > 0 ORDER BY name ASC LIMIT 130";


    $sql = "SELECT * FROM `bank` ORDER BY name ASC LIMIT 1374";

    $query = mysqli_query($db, $sql) or die(mysqli_error($db));
    $num = mysqli_num_rows($query);
?>

<form action="/bankenfinder/" method="get" name="">
    <input type="text" name="s" value="">
    <input type="submit" value="Suchen">
</form>

<?php



$html .= '
<table class="table table-dark table-hover" id="banken">
<tr>
<th>Bank</th>
<th>Straße</th>
<th>Plz</th>
<th>Ort</th>
</tr>
';

while($row = mysqli_fetch_object($query)) {
$html .= '
<tr>
<td><a href="/bankdetail/?id='.$row->id.'">'.htmlspecialchars($row->name).'</a></td>
<td>'.htmlspecialchars($row->str).'</td>
<td>'.htmlspecialchars($row->plz).'</td>
<td>'.htmlspecialchars($row->ort).'</td>
</tr>
';
}
$html .= '</table>';


    return $html;
}






function custom_theme_titles_yoast( $title ) {
    #$sep = 'xxxx|';
    $name = get_bloginfo( 'name' );
    $desc = get_bloginfo( 'description', 'display' );

    if( is_front_page() ) {
        $pagetitle = $title;
        return "{$pagetitle}";
    }
     elseif( is_404() ) {
        $pagetitle = "404";
        return "{$pagetitle} {$sep} {$name} - {$desc}";
    }
    else {
        $pagetitle = $title;
        return "{$pagetitle} {$sep} {$name} - {$desc}";
    }
}
add_filter( 'wpseo_title', 'custom_theme_titles_yoast', PHP_INT_MAX );
add_filter( 'wpseo_description', 'custom_theme_titles_yoast', PHP_INT_MAX );



add_shortcode("bankendetail","bankendetail");
function bankendetail(){

//Verbindungsvariable samt Zugangsdaten festlegen
$db = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($db, "utf8");

// Verbindung überprüfen
if (mysqli_connect_errno()) {
  printf("Verbindung fehlgeschlagen: %s\n", mysqli_connect_error());
  exit();
}

    $id = filter_input(INPUT_GET, 'id', FILTER_SANITIZE_NUMBER_INT);
    $sql = "SELECT * ";
    $sql .= "FROM `bank` WHERE `id` = '".mysqli_real_escape_string($db, $id)."' LIMIT 1";
    $query = mysqli_query($db, $sql) or die(mysqli_error($db));
    $row = mysqli_fetch_object($query);

    $html = "<h1>".htmlspecialchars($row->name)."</h1>";
    $html .= htmlspecialchars($row->str);
    $html .= "<br>".$row->plz." ".$row->ort;

    $html .= "<div style='margin-top:2rem;'>".$row->html."</div>";
    $html .= "<br>".$row->title;
    $html .= "<br>".$row->desc;

    $html .="<div style='display:block;margin-top:2rem'><a href='/bankenfinder/' class='btn btn-primary'>zurück</a></div>";


return $html;
}
?>