How do I insert multiple checkbox values into a table?

by

You should specify 

<input type="checkbox" name="Days[]" value="Daily">Daily<br>

as array.

Add [] to all names Days and work at php with this like an array.

After it, you can INSERT values at different columns at db, or use implode and save values into one column.

Didn’t tested it, but you can try like this. Don’t forget to replace mysql with mysqli.

<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>
<input type="checkbox" name="Days[]" value="Monday">Monday<br>
<input type="checkbox" name="Days[]" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days[]" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days[]" value="Thursday">Thursday <br>
<input type="checkbox" name="Days[]" value="Friday">Friday<br>
<input type="checkbox" name="Days[]" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

<?php

// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

$checkBox = implode(',', $_POST['Days']);

if(isset($_POST['submit']))
{       
    $query="INSERT INTO example (orange) VALUES ('" . $checkBox . "')";     

    mysql_query($query) or die (mysql_error() );

    echo "Complete";

}

?>

More Related Contents:

  1. Delete multiple rows by selecting checkboxes using PHP
  2. Im trying to create some temporary tables in mysql using php
  3. the update query just update the last row and affect other with it’s value
  4. How to insert images into a database using PHP [closed]
  5. How to change mysql to mysqli?
  6. php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
  7. MySQLi prepared statements error reporting [duplicate]
  8. Convert latin1 characters on a UTF8 table into UTF8
  9. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  10. Connect to a MySQL server over SSH in PHP
  11. Using strtotime for dates before 1970
  12. How to store NULL values in datetime fields in MySQL?
  13. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  14. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  15. What is the advantage of using try {} catch {} versus if {} else {}
  16. Javascript function post and call php script
  17. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  18. Trying to access array offset on value of type bool
  19. onbeforeprint() and onafterprint() equivalent for non IE browsers
  20. How to get a query error from prepare() in PDO PHP?
  21. Fatal error: Call to a member function query() on null
  22. How to insert json array into mysql database
  23. MySQL GROUP BY and Fill Empty Rows
  24. mysql injection damages?
  25. PHP PDO how to run a multiple query request?
  26. How does “do something OR DIE()” work in PHP?
  27. adding 1 day to a DATETIME format value
  28. Query on a many-to-many relationship using Doctrine with Symfony2
  29. How to use cURL to fetch specific data from a website and then save it my database using php
  30. Connect to a MySQL server over SSH in PHP

Leave a Comment