PHP Backend order form w/autocomplete. Modify example

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

Kemahiran: PHP, MySQL, Javascript, HTML, Kejuruteraan Perisian

Lihat lagi: php script order form calculated size, php menu order form, php coding order form, autocomplete search box in php mysql, php autocomplete from database example, autocomplete textbox in php mysql with ajax, autofill php form from mysql database, search box with suggestions dropdown, auto fill input form with php mysql and jquery, php autocomplete textbox from database example, ajax search box php mysql like google, php total order form, php dynamic order form, php restaurant order form, php product order form, php pizza order form script, php service order form, php food order form, custom php shopping order form, php javascript order form

Tentang Majikan:
( 5 ulasan ) Berkeley, United States

ID Projek: #20827756

40 pekerja bebas membida secara purata $164 untuk pekerjaan ini


Hello! We are a team of 30+ web developers based in Russia. Having the required skills, we will be glad to help you with your project. We have some questions for you to clear up before we start. Please message us, Lagi

$350 USD dalam 3 hari
(122 Ulasan)

Hello! I am an expert WordPress developer, having 12+ years of experience and designed and developed 2000+ websites. I have checked your requirement and available to develop an attractive and responsive website immedi Lagi

$200 USD dalam 7 hari
(254 Ulasan)

Dear Sir, We are really glad that you posted a project on freelancer. Our skills and experience speak in our freelancer portfolio. Kindly lets discuss and we will ask you queries to clear our understanding regarding t Lagi

$250 USD dalam 9 hari
(129 Ulasan)

How are you? I have read your description carefully. Very Interesting. Your project is proper to me. I have many experiences in web and mobile. So I can finish your project perfectly. If you hire me, I will do my best. Lagi

$140 USD dalam 7 hari
(148 Ulasan)

We have built several ecommerce stores like [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lagi

$250 USD dalam 9 hari
(378 Ulasan)

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.

$250 USD dalam 2 hari
(161 Ulasan)

Dear Sir. I am interesting in your project. I'm senior Laravel, PHP, SQL, Javascript developer. I am sure, I will do my best to work with you on your project to present the best possible outcome for you. I will also do Lagi

$140 USD dalam 7 hari
(171 Ulasan)

Hello.! I'm a full stack web developer. I'm a great command on PHP. I have so many years of experience in core PHP. Please check my recently done project for PHP https://surmawala.pk. I'll do fast work and quality work Lagi

$250 USD dalam 7 hari
(187 Ulasan)

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$150 USD dalam 7 hari
(180 Ulasan)

Hello, I've read your project description and I want to tell you that I can modify or make changes in your existing PHP Backend order form for you as per your [login to view URL] have a quick chat to discuss this pro Lagi

$90 USD dalam 10 hari
(191 Ulasan)

Hi, I checked your project details and already done similar autocomplete form previously with this [login to view URL] Please come online so we can discuss other details and start working. Please Lagi

$140 USD dalam 5 hari
(78 Ulasan)

Dear Sir. How do you do? I have seen your description very carefully and posting to you my idea. you can see my many work history from my profile. If you give me a chance to interview, I'll explain in more detail and Lagi

$140 USD dalam 7 hari
(42 Ulasan)

Dear Client Thank you for this opportunity.' I have rich experiences in php and I have read your job requirement in detail. I am sure I can help you with that code. Please give me a chance to do your job. Let's chat an Lagi

$100 USD dalam 2 hari
(53 Ulasan)

Hey I am interested to work on this project. What I understand is you want a dropdown whenever you enter sku or product name then product should automatically be shown there. (Offcouse if there will be a perfect match Lagi

$200 USD dalam 4 hari
(62 Ulasan)

Hello, how are you? Thank you for your project posting. I have read your description with care and I am very interested in your project. And I am a php expert with rich development experience. So I am sure that I can d Lagi

$100 USD dalam 2 hari
(39 Ulasan)

how r u? I checked your description carefully and understood your intention quickly. sorry but I don't like to introduce my skills and experience. if you entrust me your project, I will finish your project with my skil Lagi

$250 USD dalam 5 hari
(5 Ulasan)

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.

$59 USD dalam 2 hari
(82 Ulasan)

Hello client.⭐⭐⭐⭐⭐ I read carefully your proposal. I am a professional web and full stack developer. * No Upfront-Amount needed to Begin your Project * Ready to Start as Immediate, Unlimited Revisions & Proper Testing Lagi

$250 USD dalam 4 hari
(35 Ulasan)

~~Hello, Sir!~~ Nice to meet you. i am a full web developer with over 5 years on freelancer.com. Very familar with Website design, javascript, Bootstrap,Wordpress, Html5, React, VUEjs, Angular, Smart and Creatvie fron Lagi

$140 USD dalam 3 hari
(64 Ulasan)

Hi, i am a professional website developer and designer from more than 6 years. My expert zone includes Wordpress, Woocommerce, Custom plugins, PHP laravel etc. i have develop variety of websites. I can fulfill all of Lagi

$220 USD dalam 7 hari
(71 Ulasan)