
In Progress
Posted
I need piece of php code which will allow me to select specific rows via checkbox from a table and then insert them into a mysql database. So far I have the following code but it does not work: <tr> <?php while ($row = $task->fetch(PDO::FETCH_ASSOC)) {?> <th scope="row"><?= ($task['task_id']); ?></th> <td><?= ($row['year']); ?></td> <td><?= ($row['description']); ?> <input name="description[]" id="description" value="<?= $row['description']?>" type="hidden"> </td> <td class="align-middle"> <input name="selector_tasks[]" id="selector_tasks" type="checkbox" value="<?php echo $row['task_id']; ?>"> </td> </tr> <button type="submit" name='insertrecords' class="btn btn-primary">Save</button> <?php if (isset($_POST['insertrecords'])){ $N = count($_POST['selector_tasks']); for($i=0; $i < $N; $i++) { $task_id = $_POST['selector_tasks'][$i]; $description=$_POST['description'][$i]; $conn->query(" INSERT INTO tasks (task_id, description) VALUES ( '$task_id[$i]', '$description[$i]')"); } } ?> .
Project ID: 38736173
103 proposals
Remote project
Active 2 yrs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
103 freelancers are bidding on average $20 USD/hour for this job

Hello, I am interested in your project. Look at my profile. I am expert in these tasks that mention in your project description. I have more than 9 years of work experience. Time and budget will be decided after detailed discussion on chat or call. I am hoping for your positive response. Regards
$20 USD in 40 days
9.3
9.3

Hello, I understand you want to select specific rows using checkboxes and insert them into a MySQL database. To achieve this, let's streamline the PHP code to properly handle the data from the checkboxes. We will make sure to fetch the correct task IDs and descriptions for insertion. My approach involves ensuring the HTML form is correctly structured to send data and the PHP script processes it accurately. Are the task IDs and descriptions already being correctly retrieved and displayed in your table? Regards, Muhammad Awais
$25 USD in 37 days
8.2
8.2

With over 9 years of professional experience in PHP, MySQL, and Bootstrap, I'm confident that I'm the right fit for your project. I have a strong background in database programming and have successfully executed similar functionalities in many web applications before. Specifically, I've built complex "select and insert" features that allow users to transfer data from tables into databases using checkbox selection. My coding expertise extends to various development tools such as Shopify, WooCommerce, Moodle, and more - a testament to my versatility as a developer. Drawing from this breadth of experience, I can assure you clean and optimized code that will address the issue you're currently facing with the non-functional script. Moreover, I understand the importance of time management in project delivery; that's precisely why my team and I are committed to making sure each task is completed efficiently and within set deadlines. We believe in open communication throughout the project duration to make necessary corrections or improvements early on. Choose me for prompt, reliable service with attentive after-care support!
$20 USD in 40 days
8.2
8.2

Hi, I understand that you need a PHP code snippet that allows you to select specific rows from a table using a checkbox and insert them into a MySQL database. However, the current code you provided seems to have issues. Few questions come to mind: 1. Could you provide more details about the structure of your database? 2. What kind of errors or issues are you currently facing with the code? We have been providing IT solutions for over 22 years and I'm confident that we can handle your request efficiently. I'm ready to start immediately once we've clarified these details. Please feel free to ask any questions or arrange a call for further discussion. Best Regards, Rohit.
$22 USD in 15 days
8.1
8.1

Hello, I’d be happy to help you with this PHP feature. I can provide a clear, efficient solution that will allow you to select specific rows using checkboxes and then insert them into your MySQL database. I’ll make sure the code is easy to customize and fully responsive, so you can easily select and store the data you need. Questions Do you have a specific table structure in mind for this feature? Would you like any additional validation or confirmation before the data is inserted? Are there any specific fields you want to be included in the database insert process? I’m confident I can bring your vision to life. Let’s discuss the specific details in private to ensure everything meets your expectations. I am a TOP Rated Freelancer, and you can check my reviews here as well: https://www.freelancer.com/u/kamran2012. Looking forward to potentially working together on this project. Thanks and Best regards, Kamran
$25 USD in 40 days
7.7
7.7

Dear Lorenzo, Based on your project description, it seems that you are looking for a PHP code snippet to select specific rows via checkboxes from a table and then insert them into a MySQL database. Your current code needs some modifications to achieve the desired functionality. To address this, we can make the following adjustments to your existing code: 1. Ensure that the form tag encapsulates the table and the submit button. 2. Modify the button to be within the form tag for proper submission. 3. Adjust the query to correctly insert the selected rows into the database. Additionally, we can optimize the code to handle the insertion of multiple rows efficiently. Before proceeding further with the modifications, could you please provide more details on the structure of your "tasks" table in the MySQL database? This information will help in tailoring the code to suit your database schema. Looking forward to your response to proceed with the necessary modifications. Regards, Kanika
$18 USD in 10 days
6.9
6.9

Dear Client, I understand that you need a PHP code snippet to select specific rows via checkboxes from a table and insert them into a MySQL database. The current code you provided seems to have an issue and does not work as expected. My approach would be to review the code, ensure the correct variable names are used, and fix any syntax errors to make it functional. Additionally, I will optimize the code to securely handle the database insertion process and provide a user-friendly interface for selecting rows. I have expertise in MySQL, PHP, and Bootstrap which are the required skills for this project. Before proceeding, could you please clarify if there are any specific validation requirements for the data being inserted into the database to ensure data integrity and security? Regards,
$25 USD in 36 days
7.0
7.0

Hello, I'm Remus and I will be happy to help you. I can get the issue fixed and make get multiple insert part. Ready to start right now and deliver within 1 hour. Thank you!
$20 USD in 1 day
7.0
7.0

Sure, I can do this, send me a message so we can discuss it,
$20 USD in 40 days
6.7
6.7

Dear Lorenzo, I have carefully reviewed your request for a PHP code snippet to select specific rows via checkboxes in a table and insert them into a MySQL database. Your existing code has the foundation but needs adjustments for functionality. Before proceeding, could you please clarify if you are encountering any specific errors or issues when attempting to save the selected rows into the database? This information will help me tailor the solution to address the root cause effectively. Looking forward to your insights to provide you with an optimized solution. Regards, Rashid
$25 USD in 24 days
6.4
6.4

Here’s a revised version of your code with the necessary corrections. I’ve fixed issues related to PHP logic, HTML structure, and the way data is passed and inserted into the database. <form method="post"> <table class="table"> <tr> <th>Task ID</th> <th>Year</th> <th>Description</th> <th>Select</th> </tr> <?php // Loop to generate rows from the database query while ($row = $task->fetch(PDO::FETCH_ASSOC)) { ?> <tr> <th scope="row"><?= $row['task_id']; ?></th> <td><?= $row['year']; ?></td> <td> sorry cant send full code here, please open chat, thanks
$15 USD in 40 days
6.2
6.2

With a strong background in PHP, MySQL, and considerable experience with database manipulation, I am confident I can resolve the issue you're facing. Alongside managing databases using PHPMyAdmin and coding with PDO, I have successfully handled complex projects involving data insertion, search, and retrieval procedures. Your task is a common problem many developers encounter, and I am adept at writing efficient code to tackle similar issues. What sets me apart as a developer is my innate proficiency in different technology stacks - MEAN/MERN, LAMP, Laravel, CodeIgniter - giving me the ability to approach your project from various angles if needed. I am knowledgeable in jQuery which can be useful for manipulating DOM elements when handling form data. Lastly, my commitment to client satisfaction would ensure that we're on the same page throughout the project. You can depend on diligent work from me; I'll diligently check your code for any potential errors before finally optimizing and implementing it to guarantee optimal performance.
$20 USD in 40 days
6.3
6.3

Dear Lorenzo, I am excited to apply for this project. At BytesBlitzz, we specialize in designing exceptional and extensive websites and mobile applications using Figma and Adobe XD and then using modern technology stacks which includes Custom Languages and all CMS (WordPress, Shopify, WebFlow, etc) we develop them with having keen eyes on the details and user-experience. Also, you can have a glance at our profile here www.freelancer.com/u/bytesblitzz Our commitment to excellence means we not only meet but exceed expectations. We approach every project with a blend of creativity and technical prowess, ensuring your vision comes to life seamlessly. Key offerings include: • Unlimed revisions and multiple variations (On Mockups) • Dedicated Project Manager for clear communication and daily updates • 24/7 chat support for ongoing assistance • Delivery within agreed timelines • Post-Deployment maintenance up to 45 days • Free Deployment • Quality Assurance (Manual/Automation) • Video tutorials at the end for better understanding of how to manage things later We are eager to giving you a warm welcome at BytesBlitzz and ready to discuss how we can contribute to your project's success. Please let us know a convenient time to connect so we can escalate the QNA session and can get started. Best Regards, BytesBlitzz ••••••••••• P.S.: Our portfolio will be shared in Chat •••••••••••
$20 USD in 7 days
5.9
5.9

Hello, I have carefully reviewed your project requirements for selecting multiple rows in a table using checkboxes and inserting them into a MySQL database. To achieve this, I will first modify the PHP code to properly handle the form submission and data insertion process. I will ensure that the selected rows are captured and processed correctly before inserting them into the database. I will also validate the input data to prevent any potential errors during the insertion process. Additionally, I will optimize the code for better performance and security measures. I am confident in my ability to deliver a high-quality solution that meets your needs. Let's discuss further details and get started on this project. Thank you.
$25 USD in 7 days
6.1
6.1

Hi, I have gone through your initial requirements and read carefully and analyzed our skills best suit your project requirements. I have ✔️8+Years of experience in web development and Web Designing. With a focus on crafting polished, corporate-themed websites, I'll elevate your online presence to captivate business professionals. Expect a sleek, user-friendly design with fully responsive for all devices that showcases your services effectively. My experience in designing for this niche ensures a deep understanding of modern design elements while maintaining a corporate aesthetic. Through meticulous attention to detail, I'll optimize your website for SEO and mobile responsiveness, ensuring maximum visibility and accessibility. Trust my expertise to deliver a standout platform that resonates with your target audience seamlessly. Thanks & Regards, Ravi Kumar
$15 USD in 40 days
6.0
6.0

Hello, I see that you're looking for a PHP solution to selectively insert rows from a table into a MySQL database based on user checkbox selections. I have hands-on experience with similar tasks, where user-selected data is processed for dynamic entries into databases, ensuring efficient data handling and user-friendly interfaces. Your current code shows a great start; however, I'll enhance it by handling each selected row and inserting it accurately, addressing issues like `undefined indexes` and optimizing the database insertion process. I'll also ensure your code is fully secure and follows best practices, such as binding parameters in SQL queries, which is vital for data integrity and protection against SQL injection. By leveraging my expertise in PHP, MySQL, and Bootstrap, I'll provide a streamlined solution that allows smooth selection, insertion, and error-free operation, tailored exactly to your requirements. Let’s discuss this in more detail, so I can align precisely with your needs and deliver the optimal solution. Best Regards, Dotgix Technologies
$20 USD in 40 days
5.7
5.7

Hello there! I can help you select specific rows via checkbox from your table and ensure they’re correctly inserted into your MySQL database. I’ll write clean, functional PHP code that captures the selected entries accurately and securely updates your database. With experience in PHP and MySQL, I’ve handled similar projects and understand the requirements for capturing and processing form data efficiently. Let’s chat more about your project needs! Kind Regards, Arbaz A.
$17 USD in 12 days
5.9
5.9

Hi! I can create PHP code to select rows via checkboxes and insert them into your MySQL database seamlessly. Let's get it working right!
$25 USD in 40 days
5.7
5.7

Hi Lorenzo, I'm thrilled to work on your project Select multiple rows in table and insert in database. With experience in PHP, MySQL, Bootstrap, I am confident in delivering high-quality results for your project. ✅ Available 24/7 for 100% satisfaction. ✨ Experience My Web Design and Development Work ✨ To showcase my skills and creativity, I invite you to explore my portfolio: https://www.freelancer.com/u/softiarttech Let's connect in chat to discuss your project further and start work now. Thank You
$20 USD in 7 days
5.6
5.6

Hi there, I just came across your project details for the Select multiple rows in table and insert in database Could we have a quick chat to discuss the project? I have over 15 years of experience in PHP, WordPress, WooCommerce, and various other technologies, including Laravel, Magento, Shopify, and front-end frameworks like Bootstrap and Angular. I appreciate your consideration and look forward to the opportunity to work together. Thanks and regards, M. Atif
$15 USD in 1 day
5.1
5.1

Prato, Italy
Payment method verified
Member since Oct 25, 2010
€30-250 EUR
$30-250 USD
€30-250 EUR
$15-25 USD / hour
₹1500-12500 INR
₹12500-37500 INR
$10-30 USD
$250-750 USD
₹1500-12500 INR
$30-250 USD
₹250000-500000 INR
₹1500-12500 INR
$250-750 USD
$10-30 USD
$250-750 USD
$10-30 USD
$25 USD
$30-250 USD
₹1500-12500 INR
₹600-1500 INR
£10-20 GBP
$250-750 USD
$240-2000 HKD