PHP inserting multiple checkbox AND textbox arrays into MySQL Database

by

You shouldn’t be using implode. That puts a comma-separated list of everything in the form into each row that you insert, and repeats this for every box that’s checked. You should just insert one item in each row, by indexing the arrays.

However, when you have a checkbox in a form, it only submits the ones that are checked. The result of this is that the indexes of the $_POST['checkbox'] array won’t match up with the corresponding $_POST['item'] and $_POST['quantity'] elements. You need to put explicit indexes into the checkbox names so you can relate them.

<form method = "POST">

<input type = "hidden" name = "item[]" value = "cupcake">
<input type = "text" name = "items" value = "cupcake" readonly><br>
<b>Price :</b> <span name = "price" value = "3.00">$17.00</span><br>
Quantity: <input tabindex="1" name="quantity[]" min="0" max="5" type="number" class="quantity" value="1" /><br>
<input tabindex="1" name="checkbox[0]" type="checkbox" value="17" /><span>Add to Cart</span></label></div></div></td><br>

<input type = "hidden" name = "item[]" value = "cake">
<input type = "text" name = "items" value = "cake" readonly><br>
<b>Price :</b> <span name = "price" value = "20.00">$20.00</span><br>
Quantity: <input tabindex="1" name="quantity[]" min="0" max="5" type="number" class="quantity" value="1" /><br>
<input tabindex="1" name="checkbox[1]" type="checkbox" value="20" /><span>Add to Cart</span></label></div></div></td><br>

<input type = "submit" name = "insertBT"><br>
</form>

Then your PHP code can be like this:

$stmt = $conn->prepare("INSERT INTO purchases (Product, Quantity, Price) VALUES (?, ?, ?)");
$stmt->bind_param("sis", $name, $quantity, $price);
foreach ($_POST['checkbox'] as $i => $price) {
    $name = $_POST['name'][$i];
    $quantity = $_POST['quantity'][$i];
    $stmt->execute();
}

BTW, putting the prices in your HTML seems like a bad idea. Nothing stops the user from modifying HTML using the web inspector before they submit the form, so they could lower the price. You should get the prices from the database when processing the form.

Also, notice that in your original code you opened the database connection using MySQLi, but then you tried to do the insert using mysql_query instead of $conn->query(). You can’t mix APIs like that; myql_query can only be used when you open the connection with mysql_connect.

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. PHP PDO and Mysql [closed]
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. How to loop through a mysql result set
  8. Doctrine 2 and Many-to-many link table with an extra field
  9. Post form and update multiple rows with mysql
  10. MySQL/PHP Error:[2002] Only one usage of each socket address (protocol/network address/port) is normally permitted
  11. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  12. Easy way to export a SQL table without access to the server or phpMyADMIN
  13. using nulls in a mysqli prepared statement
  14. How can I count the numbers of rows that a MySQL query returned?
  15. How to run the PHP script at scheduled time
  16. How to handle error for duplicate entries?
  17. How to handle PDO exceptions [duplicate]
  18. MySql PHP select count of distinct values from comma separated data (tags)
  19. mysql_insert_id() returns 0
  20. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  21. How do I get database column names in Laravel?
  22. PDO and MySQL Fulltext searches
  23. How can I do a migration in laravel 5.5?
  24. Best way to store IP in database?
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. SQL Query with binary data (PHP and MySQL)
  27. How to get last inserted id from table MySQL [duplicate]
  28. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  29. Save array in mysql database
  30. find in set in laravel ? example

Leave a Comment