php mysqli search db hat contains using % Wildcard : I have looked up many responses on hear in regards to searching using LIKE % and also CONCAT but they are not working for me.
Basically i am trying to find in the database words like % "Croyden" and "Surrey"
The below script works fine, however I want to use % for words that contain "Croyden" and "Surrey". I have tried various ways but nothing work.

<!-- begin snippet: js hide: false console: true babel: false -->

<!-- language: lang-html -->

    $locTown = "Croydon";
    $locCounty = "Surrey";


    if ($stmt = mysqli_prepare($link, 'SELECT locTown, locCounty FROM location where 
                          locTown LIKE ? AND locCounty LIKE ? ')) {

    					  
        mysqli_stmt_bind_param($stmt, "ss", $locTown, $locCounty);  

        mysqli_stmt_execute($stmt);
       
        mysqli_stmt_bind_result($stmt, $locTown, $locCounty);
       
       /* fetch value */
        mysqli_stmt_fetch($stmt);

        while (mysqli_stmt_fetch($stmt)) {

        }

        echo "Location: $locTown - $locCounty\n";
        /* close statement */
        mysqli_stmt_close($stmt);
    }

    mysqli_close($link);
    ?>

<!-- end snippet -->



