So I am ok at PHP and MySQL. I can get things done. But I learned many years ago and haven't kept up with the changes.
I have an e-commerce site. On the back end, when I get a customer phone call and have to manually enter an order, it's difficult. They usually order multiple items, and sometimes they order by the SKU, and sometimes by the title. When they order by the title or SKU, they don't always name the title correctly (as we have it in our system).
So what I would like, is a one line box on my entry form system that will do an autocomplete based on the title OR SKU. For example. If I have an item called "Little Red Box" with a SKU of 123-456, I want to be able to enter any form of any of it like "red box" or "456", etc and get the results. If I find the correct result, I want to be able to either click ADD or ENTER and store that, then another autocomplete box comes up for the next item. That's all I need.
I have an example PHP file with an array of sample items. I can convert your finished work to integrate it with my database. Also, saved results can just be in session variables.
The ADD routine can be like AJAX based (no page refresh), or it's ok if the page is reloaded. I'm not the least bit knowledgeable about objects, so would prefer no object based routines unless highly commented. jQuery is fine. Just would prefer nothing special like loaders, optimizers, etc. And security is not an issue as I'm the only one entering data in a secure area.
Hopefully this makes sense. I just need this portion. When this is done, I can handle the order taking process (name, shipping address, etc).
So a sample PHP file would be:
$items = array
array("Little Red Box",123-456,29.95),
array("Little Green Box",123-486,19.95),
array("Big Square Brick",123-156,39.95),
array("Big Round Pipe",123-156,29.45),
// This will be the database sample you'll autocomplete from
// Then add the selected item to a session array upon ADD
40 pekerja bebas membida secara purata $164 untuk pekerjaan ini
Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat.
Hello: I can make the autocomplete for you. I can run a script which will index search terms to your catalog. That will be the most difficult. Autocomplete has frontend scripts readily available.