I know for a fact that pulling checkbox answers from an html form and storing things in a mysql table requires a different method than a radio question, because all of my radio questions store into my mysql table flawlessly.
I would like to know what exactly that code is?
Another programmer helped me by telling me this code, but it still does not store the answers from the html into the mysql, even though I get an echo of which checkbox questions were actually selected.
$partnerspresentation=$_POST['partnerspresentation'];
foreach ($partnerspresentation as $partnerspresentationname)
{
echo "$partnerspresentationname is checked";
}
$partnersorientation=$_POST['partnersorientation'];
foreach ($partnersorientation as $partnersorientationname)
{
echo "$partnersorientationname is checked";
}
$partnersgender=$_POST['partnersgender'];
foreach ($partnersgender as $partnersgendername)
{
echo "$partnersgendername is checked";
}
$partnersage=$_POST['partnersage'];
foreach ($partnersage as $partnersagename)
{
echo "$partnersagename is checked";
}
$partnersethnicity=$_POST['partnersethnicity'];
foreach ($partnersethnicity as $partnersethnicityname)
{
echo "$partnersethnicityname is checked";
}
$partnerethnicity=$_POST['partnerethnicity'];
foreach ($partnerethnicity as $partnerethnicytname)
{
echo "$partnerethnicityname is checked";
}
$partneradjectives=$_POST['partneradjectives'];
foreach ($partneradjectives as $partneradjectivesname)
{
echo "$partneradjectivesname is checked";
}
$sqlClientInfo= "INSERT INTO `Client_Info` (Last_Name, First_Name, Middle_Name, Date_of_Birth, Street_Address, City, State, Zip_Code, Phone_Number, Email, Preferred_Contact, Gender, Sexual_Orientation, Race_Ethnicity,
Gender_Presentation, Body_Type, Height, Weight, Felony, Partners_Gender, Partners_Sexual_Orientation,
Partners_Race_Ethnicity, Partners_Gender_Presentation, Partners_Body_Type, Partners_Age, Partners_Height, Turn_On, Turn_Off, Celebrity_Crush, First_thing_you_notice, Deal_Breaker)
VALUES ('$_POST[lastname]','$_POST[firstname]','$_POST[middlename]','$_POST[birthdate]',
'$_POST[streetaddress]','$_POST[city]','$_POST[state]','$_POST[zip]','$_POST[phone]',
'$_POST[email]','$_POST[contactmethod]','$_POST[yourgender]','$_POST[yourorientation]',
'$_POST[ethnicity]','$_POST[yourpresentation]','$_POST[bodytype]','$_POST[height]',
'$_POST[weight]','$_POST[felony]','$partnersgender','$partnersorientation',
'$partnerethnicity','$partnerspresentation','$partnerbodytype',
'$partnersage','$_POST[partnersheight]','$_POST[turnon]','$_POST[turnoff]',
'$_POST[celebritycrush]','$_POST[firstthing]','$_POST[dealbreaker]')";
// run query Client_Info and check result
if (!mysql_query($sqlClientInfo,$con))
{
die('Error: ' . mysql_error());
} else {
echo 'Query Client_Info was successful<br>';
}
I also receive this error: Warning: Invalid argument supplied for foreach()
Yet I still get this echoed back to me: Query Client_Info was successful
Any way to fix this? I am relatively new at programming so detailed explanation would be best.
