ilovephp Posted August 6, 2014 Share Posted August 6, 2014 Hi all, i would like to ask, how to insert the CHECKED check box date value into database (checked_table) and insert the UNCHECKED check box date value into database (unchecked_table)? can someone please assist me on this matter? if my code is as shown below:- thank you very much. $startDate = strtotime($datefrom); $endDate = strtotime($dateto); $date = $startDate; while( $date <= $endDate) { echo "<input type='checkbox' name='date' value ='".date('d-m-Y', $date)."' class='chk'>";echo date('d-m-Y', $date) .' '; $date = strtotime('+1 day', $date); } <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js" type="text/javascript"></script><script src="http://code.jquery.com/ui/1.9.1/jquery-ui.min.js" type="text/javascript"></script><script type="text/javascript"> $(document).ready(function () { $("#submit_hod").click(function() { getValueUsingClass(); }); }); function getValueUsingClass(){ var chkArray = []; $(".chk:checked").each(function() { chkArray.push($(this).val()); }); var selected; selected = chkArray.join(',') + ","; if(selected.length >= 1){ alert ("done insert selected date"); }else{ alert ("error"); }}</script> <label>Date:- FROM</label><input type="date" name="ldatefrom" value="<?php echo $leavedatefrom;?>"><label>TO</label> <input type="date" name="ldateto" value="<?php echo $leavedateto;?>"><input id="submit_hod" type="submit" name="submit"> Link to comment Share on other sites More sharing options...
justsomeguy Posted August 6, 2014 Share Posted August 6, 2014 Give all the checkboxes a name like "date[]", which will make them an array in PHP ($_POST['date'] will be an array of checked values). Unchecked values are not submitted to the server, so you can either loop through the dates again and check if each date was submitted, or write a list of all of the checkbox values into a hidden input and submit all of the values with the rest of the form so that you can loop through them and see if each was checked or not. Link to comment Share on other sites More sharing options...
ilovephp Posted August 7, 2014 Author Share Posted August 7, 2014 Thanks alot! i made it! the date values have been successfully inserted into database. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now