PHP, AJAX, MYSQL - Przeszukiwanie bazy

< !DOCTYPE html >
< html >
< head >
< script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js" > < / script >
< script type = "text/javascript" src = "js/form.js" > < / script >
< link rel = "stylesheet" type = "text/css" href = "css/css.css" media = "screen" / >

< script >

function showState( str ) {
    if( str == "" ) {
        document.getElementById( "txtHint" ).innerHTML = "";
        return;
    } else {
        var xmlhttp = new XMLHttpRequest();
        xmlhttp.onreadystatechange = function() {
            if( this.readyState == 4 && this.status == 200 ) {
                document.getElementById( "txtHint" ).innerHTML = this.responseText;
            }
        };
        xmlhttp.open( "GET", "php/get.php?q=" + str, true );
        xmlhttp.send();
    }
}


$( document ).ready( function() {
   
    load_data();
   
    function load_data( query )
    {
        $.ajax( {
            url: "php/fetch.php",
            method: "POST",
            data: { query: query },
            success: function( data )
            {
                $( '#result' ).html( data );
            }
        } );
    }
    $( '#search_text' ).keyup( function() {
        var search = $( this ).val();
        if( search != '' )
        {
            load_data( search );
        }
        else
        {
            load_data();
        }
    } );
} );







< / script >

< / head >
< body >

< ? php
// Include the database config file
include_once 'php/dbConfig.php';

$ query = "SELECT * FROM baza_woj ORDER BY WOJ_NAME ASC";
$ result = $ db->query( $ query );
? >

< form >
< select id = "country" onchange = "showState(this.value)" >
< option value = "" > < / option >
< ? php
if( $ result->num_rows > 0 )
{
    while( $ row = $ result->fetch_assoc() )
    {
        echo '<option value="'.$ row[ 'WOJ_ID' ].'">'.$ row[ 'WOJ_NAME' ].'</option>';
    }
}
else
{
    echo '<option value="">BRAK</option>';
}
? >
< / select >

< / form >
< br >
< div id = "txtHint" > < b > ... < / b > < / div >




< div class = "container" >
< br / >
< h2 align = "center" > Ajax Live Data Search using Jquery PHP MySql < / h2 > < br / >
< div class = "form-group" >
< div class = "input-group" >
< span class = "input-group-addon" > Search < / span >
< input type = "text" name = "search_text" id = "search_text" placeholder = "Search by Customer Details" class = "form-control" / >
< / div >
< / div >
< br / >
< div id = "result" > < / div >
< / div >





< / body >
< / html >

< ? php
//fetch.php

//include_once 'dbConfig.php';

$ db = mysqli_connect( "localhost", "root", "", "baza" );

$ output = '';



if( isset( $ _POST[ "query" ] ) )
{
   
    $ search = mysqli_real_escape_string( $ db, $ _POST[ "query" ] );
    echo "A: ".$ search."<br>";
    $ query = "SELECT * FROM terc WHERE NAZWA '%".$ search."%'";
   
    echo "istnieje ".$ query;
}
else
{
    $ query = "SELECT * FROM terc ORDER BY WOJ";
   
    echo "nie istnieje";
}


$ result = mysqli_query( $ db, $ query );

echo "Returned rows are: ".mysqli_num_rows( $ result );

if( mysqli_num_rows( $ result ) > 0 )
{
    $ output.= '
  <div class="table-responsive">
   <table class="table table bordered">
    <tr>
     <th>Customer Name</th>
     <th>Address</th>
     <th>City</th>
     <th>Postal Code</th>
     <th>Country</th>
    </tr>
 ';
    while( $ row = mysqli_fetch_array( $ result ) )
    {
        $ output.= '
   <tr>
    <td>'.$ row[ "WOJ" ].'</td>
    <td>'.$ row[ "POW" ].'</td>
    <td>'.$ row[ "GM" ].'</td>
    <td>'.$ row[ "NAZWA" ].'</td>
    <td>'.$ row[ "NAZWA_DOD" ].'</td>
   </tr>
  ';
    }
    echo $ output;
}
else
{
    echo 'Data Not Found';
}




? >