How to store php checkboxes values into mysql?

Question

Please give a simple and sample code and also give check birthdate code between 1950 to 1995.

Answer 1

You can't check checkboxes in Php, but you can set values in javascript that will be passed to Php:

the form:

<form id="myform"... action=.. method=post

onsubmit = "js_check(document.forms['myform']); return false;" >

<input type = checkbox name = checkbox1 ...>

<input type = checkbox name = checkbox2 ...>

<input type = hidden name = phpbox1>

<input type = hidden name = phpbox2>

<input submit>

</form>

function js_check(theForm)

{

if (theForm.elements['checkbox1'].checked)

theForm.elements['phpbox1'].value = 1;

if (theForm.elements['checkbox2'].checked)

theForm.elements['phpbox2'].value = 1;

}

Your receiving Php script reads phpbox#.  If set to 1, then box is checked.

---------------------------

Date check:

<javascript>

var dtChar = "-";

var minYear = 1950;

var maxYear = 1995;

function isInteger(s)

{

var i;

for (i = 0; i < s.length; i++)

{  

// Check that current character is number.

        var c = s.charAt(i);

        if (((c < "0") || (c > "9"))) return false;

    }

    // All characters are numbers.

    return true;

}

function stripCharsInBag(s, bag)

{

var i;

    var returnString = "";

    // Search through string's characters one by one.

    // If character is not in bag, append to returnString.

    for (i = 0; i < s.length; i++)

{  

        var c = s.charAt(i);

        if (bag.indexOf(c) == -1) returnString += c;

    }

    return returnString;

}

function daysInFebruary (year)

{

// February has 29 days in any year evenly divisible by four,

    // EXCEPT for centurial years which are not also divisible by 400.

    return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );

}

function DaysArray(n)

{

for (var i = 1; i <= n; i++)

{

this[i] = 31

if (i==4 || i==6 || i==9 || i==11) {this[i] = 30}

if (i==2) {this[i] = 29}

   }

   return this

}

function isDate(dtStr) // format DD-MM-YYYY

{

var daysInMonth = DaysArray(12);

var pos1 = dtStr.indexOf("-");

var pos2 = dtStr.indexOf("-",pos1+1);

var strDay = dtStr.substring(0,pos1);

var strMonth = dtStr.substring(pos1+1,pos2);

var strYear = dtStr.substring(pos2+1);

// alert (strDay+","+strMonth+","+strYear);

if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1);

if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1);

strYr = strYear;

for (var i = 1; i <= 3; i++)

if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)

month = parseInt(strMonth);

day = parseInt(strDay);

year = parseInt(strYr);

if (strMonth.length<1 || month<1 || month>12)

return("Please enter a valid date");

if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month])

return("Please enter a valid date");

if (strYear.length != 4 || year==0 || year<dtMin || year>dtMax)

return("Please enter a valid 4 digit year between 1950 and 1995");

if (dtStr.indexOf("-",pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, "-"))==false)

return("Please enter a valid date");

return("");

}