Inserting Multiple Checkbox Values into a single MySQL database Column

[dulskel11]

This code isn't working, and nothing comes up in the error logs, but also nothing inserts into the database. Can someone please take a look and see if there is something I'm missing? Please excuse my poor beginner PHP and HTML

[benanamen]

Pictures are for hanging on the wall. Post your actual code.

 

With that said, you are using obsolete code that has been completely removed from Php. You need to use PDO.

 

https://phpdelusions.net/pdo

Edited August 1, 2016 by benanamen

[Jacques1]

Your error handling is broken (you check the query string $query which is always truthy), and your VALUES have no category.

 

But, yes, do use PDO. It will save you many, many hours or writing useless code and struggling with strange problems.

[cyberRobot]

To fix the error handling, see Example #1 here:

http://php.net/manual/en/function.mysql-query.php

 

Of course, you will want to move away from the mysql_* functions as soon as possible, as benanamen and Jacques1 have suggested.

[Yohanne]

use for loop.....

for($i=0; $i <count($category); $i++)
  {
    $array = array('data =>', $data,
                   'year =>', $year,
                   'month =>', $month,
                   'day =>', $day,
                   'entrydate =>', $entrydate,
                   'envlopeNum =>', $envlopeNum,
                   'note =>', $note,
                   'category =>', $category[$i]);

     $query = "insert . . . . . . values $array . . . .";  // function insert
  }

[Jacques1]

What?

[Yohanne]

i just gave an idea and what is wrong. . .?

[Jacques1]

Your reply is two weeks late, it doesn't have anything to do with the problem, and it makes no sense. When you need to insert one item with four categories, you don't insert four items. Either you insert one item and three category associations (this is the correct way, but it requires an extra table), or you insert one item with a comma-separated list of categories (this is how the OP does it).