PHP/MySQL - Add automatic lot sequencing to existing data entry form

We have an existing PHP data entry form that accepts a few values from users (Item, Lot Number, Label Qty, etc). Currently the Lot Number field is defined by the user for all items. When a user enters an item number and a label quantity, the defined lot number repeats on every label in that print job (Example: 10 labels with Lot Number 12345)

Items are currently being displayed in a drop down menu which is generated from a MySQL table. We would like to add a feature to this form so when an item is selected, the page knows if it is a "Kit" item or not (this value is defined in the item table along with every item number). If kit_item = 'Y' then the Lot Number field should be hidden from the form (or disabled) and the lot numbers for the requested labels should be generated dynamically from a sequence.

Both scenario examples:

Method 1: Non-Kit Items (current functionality)

User defines a label qty of 10

User defines a non-kit item (Item1234)

User defines Lot Number (9876)

10 labels print for Item1234 all containing lot number 9876

Method 2: Kit Items (New functionality)

User defines a label qty of 10

User defines a kit item (KitItem4567)

Lot Number field is disabled automatically when item is selected

10 labels print for KitItem4567 - each with a unique Lot Number 001 - 010

We can define a table for this that can hold the starting sequence number and use for tracking of these numbers going forward. Or if you have a better way of doing this, we are open to suggestions. The simplest and most elegant solutions are best.

With the existing functionality (Method 1), a single record gets inserted into a MySQL table since the lot number is the same for all labels in the request.

For Method 2, I expect a loop will need to be used to insert a single row for EACH label in the request, each with its own unique sequenced lot number.

Beceriler: PHP, MySQL, Javascript

Daha fazlasını gör: php mysql add discussion forum page, php mysql add update delete, php mysql add modify delete, php mysql add delete edit table, php mysql add item ebay, flash php mysql add delete modify clients, php mysql data entry form, smarty php mysql add item form, create php mysql add edit text, simple mysql php data entry form, php mysql add button, php mysql add user items, map php mysql add point, php mysql add caption photo gallery, php mysql add daily horoscope api, php mysql add cart ajax

İşveren Hakkında:
( 118 değerlendirme ) huntley, Canada

Proje NO: #22715301



hello! I can do the feature you've requested. I'll be using a loop as you've described and an incrementing number for the lot number. also regarding the disable of the field, I'll be using ajax calls in order to get Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(47 Değerlendirme)

Bu iş için 35 freelancer ortalamada $141 teklif veriyor


Hello, which framework are you using for this? It seems using jquery will do this job. If you provide me cpanel I can handle today.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(956 Değerlendirme)

Hello, I am clear with the provided functionality and method 2 which you like to be implemented. Please initiate a discussion in the messages and share link and access of your existing form to get a better understand Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(215 Değerlendirme)

HI, I can assist you with PHP/MySQL . Here is a sampling of the few of my work contained at my portfolio: https://www.freelancer.com/u/extreamcode.html This is a placehoolder bid, I would be able to quote final price a Daha Fazla

$140 USD in 7 gün içinde
(87 Değerlendirme)

Hi, Could I take a look at your current form and the schema of the database table to give a optimized plan for this project Is the Kit item flag has been included into the table yet? Thanks Ngan Le

$140 USD in 2 gün içinde
(346 Değerlendirme)

Hello? How are you? I am excited to work with you on backend coding. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] [login to view URL] https:/ Daha Fazla

$155 USD in 3 gün içinde
(137 Değerlendirme)

Hello, Greetings!! I have a question for METHOD 2. Can we discuss this, please?? I will love to assist you with this task, and I can start working immediately. Latest Work: [login to view URL] ( Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(162 Değerlendirme)

Thank you for your posted project and hope you are doing great. I am Neeraj and very happy to have a chance of bidding your project. I've read your project description carefully and would love to work on this project w Daha Fazla

$100 USD in 10 gün içinde
(281 Değerlendirme)

Greetings sir, I have read your project details and i will develop/update your php script to add method to for kit item to handle automatic/sequence lot numbers. Sir, i can deliver this project sooner than you ex Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(140 Değerlendirme)

Hello, i am ready to help you update/make changes to your existing data entry form as per requirement. I have gone thro the details and confident to implement the task. I am PHP expert and assure you quality work and l Daha Fazla

$140 USD in 5 gün içinde
(104 Değerlendirme)

"I am PHP and MYSQL expert and i understand your form issue, i will do it perfectly" Hello there, my name is Anusuya and i’m a full-time, reliable, and highly experienced Freelancer with expertise in website designing Daha Fazla

$140 USD in 7 gün içinde
(106 Değerlendirme)

Hi will query your database with Ajax on form interaction and manipulate the form input fields as needed. Will need to see your form code and dB setup to give you a detailed solution but there are many ways to kill the Daha Fazla

$120 USD in 2 gün içinde
(84 Değerlendirme)

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Daha Fazla

$240 USD in 5 gün içinde
(61 Değerlendirme)

Hi, I am very interested to your project and ready to start right now. I have read your project requirement carefully. I have 10 years plus experience in web developing I can meet your requirement Give me one chance to Daha Fazla

$50 USD in 4 gün içinde
(74 Değerlendirme)

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional PHP , HTML expert with over 5 years of experience. It seems Daha Fazla

$140 USD in 7 gün içinde
(25 Değerlendirme)

Hi there !!, I have 9+ years of experience in Software Development, acting in national and international projects in many areas like: analysis, Architecture, Development and Testing. *** 300+ projects with 100% feedba Daha Fazla

$60 USD in 3 gün içinde
(31 Değerlendirme)

I am expert in php/MySQL and well suited for this job. It will require ajax validations for doing this job. Are you using any ecommcerce platform or it is purely custom php based site. Please provide me details over ch Daha Fazla

$100 USD in 2 gün içinde
(56 Değerlendirme)

Hello, how are you today? I've read your description and I am very interested in your project. I’m a passionate and meticulous Developer, and an unstoppable Dreamer. Please check my profile URL below you can check Daha Fazla

$140 USD in 2 gün içinde
(25 Değerlendirme)

Hi there, I can implement dynamic lot numbering for Kit Items as mentioned in the project description. As you have mentioned, a new table for storing lot number sequence would be the best approach for this new functi Daha Fazla

$100 USD in 3 gün içinde
(23 Değerlendirme)

Hello? How are you? I have read your project detail. Did you use any framework for your website? Or is it just a core PHP? I will do my best for your project. Fast and Best result. Thank you.

$100 USD in 7 gün içinde
(14 Değerlendirme)

Hello, how are you? As a php expert with abundant experience, I'm glad to see your project. I can do my best to help you. Your project is very suitable for me, hope your good response. Thanks.

$250 USD in 7 gün içinde
(12 Değerlendirme)