The text input names don’t match the $_POST keys you are looping. Using [] in the input name attribute is for handling multiple inputs, not multiple keys.
Try replacing name="search[batch_no]" and name="search[rfid_chip_no]" with simply name="search_batch_no" and name="search_rfid_chip_no" and looping $_POST instead of $_POST["search"].
Also you need to check the conditions match, as only code and category are matched in your input processing, there is no sign of batch_no or rfid_chip_no, so I have no idea how it could be ‘working locally’ unless it is simply selecting all records locally because the query condition is ignored.
Related Posts:
- Has anyone tried putting PHP ActiveRecord on WordPress?
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- Adding Custom Forms
- Databases – Submitting data from inputs to database [closed]
- db converts decimal number wrong
- Get wp_current_user_id using PHP and MySQL
- Adding data to custom wordpress database table
- $_POST returning empty values
- How to send custom form submissions to WordPress Database?
- Confuse between forms and tables
- Updating the database after parsing CSV document
- Insert data from form to database
- How to pass username into form that sends data to database
- Custom form that stores data in mysql database
- Putting form result in my database
- Bulk data save in custom table
- Can’t insert into a database wordpress
- How to return number of found rows from SELECT query
- what is the use of /wp-includes/SimplePie?
- Inserting choice in database table
- WP API V2 returning Invalid User ID
- How to insert PHP code in a WordPress Post
- How To Make Connection To WordPress Data Base In A Plugin?
- How to auto login user again after change user_login
- Handling error states with admin_post
- Creating wordpress user registration form
- Duplicate domain database to local – How?
- submit the form to same page
- How can I call a row of user specific data from a custom table added to the WP Database
- How to merge local and live databases?
- How to track a users progress through pages by inserting data into WordPress Database?
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Ajax form submit within a Post Metabox
- wp_insert_post not working
- Upload Image in a WordPress page using PHP
- Prevent Data Resubmission On Page refresh
- SQL QUERY – Select a value directly from the database
- Any possible way to make $wpdb->get_results() return anything else than array?
- Transferring working local PHP site to wordpress – with database (MySQL)
- Custom Form Processing Issue
- My form action url is being prepended with a directory that does not exists
- Getting id of poll from WP database
- Storing Array from returned database query and using the array in a new query
- Custom profile field with birthday. Troubles with
- How does WordPress know wich language is chosen when there is a database connection error
- How can I save unique user data on my site? [closed]
- Post + form + action + results on the same page
- Dynamic content in template
- Why Won’t My Inputs in a form with a Get method work together?
- How to get the value of input hidden html from text editor to custom page template?
- Contact form won’t submit
- Using custom tables for old posts
- How to show a ‘correct’ message after submit a form?
- “operation successful” message
- User register hook is not working in woocomerce register form
- How can I import an excel column into wordpress database?
- WordPress Block developer from exporting Database via PHP
- Execute a function every hour in the background
- Create page with custom php script and fetched data
- How do I display offsite database info on my wordpress site?
- WordPress and MySQL: trying to print data using PHP from user_meta custom field data
- How to send form data from WordPress (Meta Box) to an OData service?
- Most commented posts by time period (last 12h, last 24h and etc)
- WordPress shortcode returns the data before
- Shortcode to embed Edit Account form not working
- Form Submission Not Working In Custom Theme
- Why does my user not get added to the database on custom registration?
- Set default Database Storage Engine when creating tables with plugins?
- How do I make this Metabox show current DB value?
- Pass important values server-side when processing form
- Why when I create a new post I found 2 record related to this post into the posts database table?
- Make a page (url) not cacheable [closed]
- WordPressUser Submission Form
- How to use multiple check-box values to work in a function and insert values in database
- Testing a Form’s Zipcode Field with Regular Expressions to Determine WordPress Page Behaviour
- SQL error with custom query
- Unserialize Custom Field & Save as Multiple Rows in WordPress Database
- What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
- Create a new account on site B with data from the purchase of site A
- I want it to detect the duplicate comment and give a warning on the same page
- wp_update_post gives 500 internal error
- wp-login.php?redirect_to=https problem
- If input field has value Require another field – PHP
- Front end/Database connection in WP
- can’t delete a row from post_meta table
- Submitting my form to the database and then redirecting to payment site
- Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
- AJAX Not Working With WordPress Database properly
- Post from front end form to post_meta
- Accessing values entered via form – try again
- Nonce fail after second submit attempt
- Styling admin page rows in order of importance (checkboxes)
- Manipulate database of WordPress site with my own scripts
- Problems with plugin that fetches data from database with ajax
- Let users register weight each day and save it in DB
- Using Nonce for my Form
- Query specific posts per user selections from dropdown menus
- Fetching wpdb data from a php file seems to break?
- Insert into db with foreach problem