StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCalender with checkbox: How to insert information into database from checkbox
text
Body
copied!<p>I am trying to create a calender with a checkbox for each date. When a user clicks the submit button, I want to get those selected dates inserted into the database and those which are not selected would be deleted from the database if those already exist before. I have created a index.php page where I wrote the following code to generate dates: </p> <p>index.php:</p> <pre><code><form name="form1" method="post" action="show.php"> <?php $year="2011"; $month="8"; $d=cal_days_in_month(CAL_GREGORIAN,1,2011); $i=1; while($i<=$d) { ?> <input type="checkbox" name="date[]" value="<? echo " $year-$month- " . $i . ""."<br>"; ?>"> <? echo " $year-$month- " . $i . ""."<br>"; ?> <? $i++; } ?> <input type="submit" name="Submit" value="Submit"> </form> </code></pre> <p>show.php:</p> <pre><code><? mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error()); mysql_select_db("database"); $media_array = $_POST['date']; foreach ($media_array as $one_media) { $source .= $one_media.", "; } $media = substr($source, 0, -2); $query = "INSERT INTO table1 (id,media) VALUES('', '$media')"; $result = mysql_query($query); } ?> </code></pre> <p>And then I created page another page named show.php where I tried to write codes for inserting information, but I failed. Would you please kindly help me to do this? I have tried my best but I couldn't make it happened. Thanks in advance.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload