Sorry for late reply. Yes it is possible. Go to aside.php file. And this block of code where you want the select box:

                <?php if($offers->num_rows > 0){ ?>
                <select name="thename" id="theid">
                    <?php while($offer = $offers->fetch_assoc()){ ?>
                    <option value="<?= $offer['id'] ?>"><?= $offer['name'] ?></option>
                    <?php } ?>
                </select>
                <?php } ?>

Change variables and key according to your query and database structure.

I add the code in aside.php, but the filter doesn’t work. The results do not change. Is there anything else that needs to be added?

Please try foreach instead of while loop

<?php foreach ($brands as $brand): ?>
    <option value="<?= $brand['id'] ?>"><?= $brand['name'] ?></option>
<?php endforeach; ?>

aside.php

<select name=”type” id=”type” class=”form-select”> <?php foreach ($types as $type): ?> <option value=”<?= $type[‘id’] ?>”><?= $type[‘name’] ?></option> <?php endforeach; ?> </select>

index.php

<script> $(”#type”).on(“change”,function(){ faceted(); }) </script>

inside faceted funciton

var types = $(”#type”).val();

faceted.php

if(isset($_GET[‘types’]) && $_GET[‘types’] != ””){ $types = $_GET[‘types’]; $sql .=” AND `type_id` = ”.$types; }

Sometimes it’s not works from CodeCanyon. Try this link: https://needle.smartrahat.com/

Thanks for the quick reply. I actually need a script in php that’ll predict the search from items already in the database. example Amazon. Does Needle have this kind of functionality?

Any ideas why your plugin isn’t working for me?

Sorry for late answer. I was busy celebrating Eid-ul-fitr.

The error is for wrong database settings. Please recheck the database setting.

Well I found some time to try this again and got the same result. Your plugin doesn’t work for me. I created a new database with a new username and password and still got the same error: when browsing to https://mywebsite.com/search/index.php.

Connection Failed: Access denied for user ‘username’@’localhost’ (using password: YES)

Not sure what to do next. I have many mysql database platforms installed on my server working just fine so I know it isn’t my database that is causing the problem.

According to your documentation all I have to do is upload files to server, create database, import sql tables, modify conn.php and I should be good to go. Seems simple enough but something is wrong. I dropped all the tables and used the exact same database to do a test with another plugin and it installed with no errors so it must be something else with your script or something I am missing.

I am going to have to ask for a refund as this plugin won’t work for me.

I’ve tried to visit your link but it is not working. If you still want for a refund you can ask for it.

Is there any way we can correspond via email so I can provide you with details without posting them here for security reasons? I would like to try and get this to work but obviously I am missing something.

Here is my email address smartrahat@gmail.com

Feel free to contact me anytime.

So I have tried to contact you via email a few times but you never responded and I see my support has now expired. I still haven’t gotten your script to work and I had to walk away for a while but I am ready to give it another try if you will answer my previous emails that were sent to you during my support period please.

Sorry for the problem. Normally I replied withing 1 day. I think I’ve missed some. Can you please give me a another mail or give me you email address.

Don’t worry about the support expire. I’ll always support you if there is any issue from my side.

Check your spam folder as I sent you an email Thursday. I sent it to this email address which you gave me via envato back in May. smartrahat at gmail dot com. My email is webmaster at vanislebc dot com.

Got your email in spam folder. Sorry for the misunderstanding. I’ve replied your email.

Sent you two more emails in the last 12 hours with no response.

Sorry brother, I just woke up. I’ve checked the link, looks like the database password is wrong. Make sure you are using database password instead of cPanel password.

Double checked my database username and password and both are correct. Even changed the password to be sure but I got the same result. Is your script compatible with mysql 8?

It will work on any PHP script.

One more question if you don’t mind? Will this script (v1) continue to be updated in the future or do you have plans to focus on the Laravel version (v2) instead?

No problem, you can ask my anything until you satisfied.

There is no v1 now.

I’ve two versions now. PHP version and Laravel V2 version.

I update them when they need to be updated.

Thank you.

Okay thanks for letting me know.

Was wondering how this script indexes my website? It is a very large one and the last time I tried to use a search engine script it kept timing out.

Okay never mind, found the info about how your script indexes websites.

I already have a search form built into my html nav bar.

Will I be able to use your script by adding one line to the “form action call”?

Please, check the console for the error

XHRGEThttp://localhost:8080/hello/faceted.php?_token=bolOKge9ACHvDkXn7EeHYU2vHRAyqyyX04tSy1lo&search=&colors[]=3&price=241;604&entriesPerPage=6 [HTTP/1.0 500 Internal Server Error 2ms]

XHRGEThttp://localhost:8080/hello/faceted.php?_token=bolOKge9ACHvDkXn7EeHYU2vHRAyqyyX04tSy1lo&search=&price=241;604&entriesPerPage=6

What’s interesting is: once i use the slider, the filtering works according to the values concerning the price, BUT: if I then click a couple of checkboxes, no matter which ones, brand or whatever, NOTHING happens, I don’t even get an error in the console, the console just keeps logging the events from the slider, while the slider still works. But if i THEN open the console and click any checkbox, an XHR GET error occurs immediately after clicking any checkbox with the console open. Odd. However, after resetting the filters, everything works fine, all checkboxes, etc. But once i use the slider at some point, the other filters don’t work anymore. This happens with the standard setup. Also one other thing: in the version I bought and downloaded from codecanyon, the loading gif is in the images folder but not integrated in the code of the application.

Thank you for detecting the issue. I’ve fixed it and update the project with the fix. Please, download again for a working version.

Hey smartrahat, thank you for your support! i’ve tested the new version, but unfortunately, now the “clear filters” button doesn’t work anymore. ERROR: XHRGEThttp://localhost:8080/j/faceted.php?search=&price=$0 – $500&sorting=category_id&direction=asc&qty=6 [HTTP/1.0 500 Internal Server Error 2ms]

The combination of range slider and other filtrers works now though!

Hi, this works actually:

PAGE: faceted.php

if ($search) { YOUR CODE IS HERE } else { $result=null; echo json_encode([‘result’=>$result,0,0,0]); } Does this look ok. Or a better way to do this?

In index.php file search for this block of code.

<script>
    $(window).on("load",function(){
        $("#amount").val("$0 - $1000");
        faceted();
    })
</script>

Now, remove or comment the faceted() function.

I hope, this will solve your issue.

Please, contact me if you need any help.

Hi, thanks, not really what I was trying to do. My code seems to work as I wanted it too so all should be good. The point was when you’ve used the SEARCH field and then emptied it again, I don’t want all the posts showing – I wanted none showing…

Hi again, is there a way to limit the Ajax search so it doens’t begin searching until after the first 3 chars are typed? Thanks

Hi there,

Find the code block shown below.

<script>
    $("#search").keyup(function(){
        faceted();
    })
</script>

And replace it with this code. It will trigger the faceted() function if the search field have 3 character or more.

<script>
    $("#search").keyup(function(){
        let search = $(this).val();
        if(search.length >= 3 || search.length === 0){
            faceted();
        }
    })
</script>

To solve your previous comment remove || search.length === 0 this from above code.

If you have more changes, don’t hesitate to knock me.

Great thank you. My client is concerned about security. I’ve heard stories of ‘DRO P DATABASE’ or similar being able to passed through to the Database from the SEARCH field. Can you let me know any security you have to avoid this sort of injection? Thanks

Also if you don’t mind, I have another one – how would I go about filtering out ‘functional’ words from the search. Words that are not really Search Terms such as, and, I we, have, we etc etc. Would you know of a class or function to add to this script of yours please?

Meant to say Rahat, very pleased with the script

Hi, not heard any response to latest questions. Could you elaborate on the security side of things please?

I’m extremely sorry for the late. I was so busy finishing my next product. Good thought about the MySql Injection.

Though, the search field will connect with more queries (including joining and group by) there is less chance of drop or modify the database.

For better safety you can use mysqli_real_escape_string() in search queries. Go to faceted.php file and replace

$search = $conn,$_GET['search'];

With this line

$search = mysqli_real_escape_string($conn,$_GET['search']);

To omit certain words from string, you may create a new function with these code.

function trimmed($string)
{
    $omit_words = ['and','we','or','have','is','i'];   // remove the spaces
    rsort($omit_words); // need to sort so that correct words are replaced 
    return str_replace($omit_words,'',$string);
}

I hope this will solve your problem.

Thanks for this. Where would the Search field call this from?

Try the direct link https://needle.smartrahat.com/

Thanks, I just get a spinning logo and no results. Tried a few different times?

I’ve tested it. It’s absolutely fine.

Not for me unfortunately

Can you please tell me, which options you were choose when it not work?

Hi, I’ve tried all sorts. Can you tell me what to try to see it working?

I’ve built a bespoke blog. Would this work as a general search field to filter blogs? Thanks

Check your desire options like the screenshot.

Hi, its the SEARCH FIELD i’m interest in – if I could use this to bring up my blogs. That doesn’t return results…

Thanks brother, I’ve found the issue and fixed it.

Ahh yes working well now. A couple more questions if you don’t mind? I work with PHP MYSQL – would I be able to integrate with my bespoke blog you think? Secondly – hows the security for calling the Database. Has this been taken into account. Thanks.

1. Ask as many question as you need.
2. You can use this in bespoke blog. Need an extra page for details, if you have it then OK.
3. Of course it’s secure for calling from database.

Thanks. Could you give me an example of integration for PHP please?

Are you talking about documentation?