please help with mulitpal value checkboxs

tennisnick

Hey there, I am trying to have users be able to enter multipal checkbox values and store it in the database. This is the code that I think should work but it is not.

This is for the registration page.

This is for the processing page.

if(isset($POST['creditTypes']))
{
$creditTypes=$POST['creditTypes'];

for ($i=0; $i<count($creditTypes); $i++)
$selected_creditTypes .= $creditTypes[$i] . ' ';
};

When I check the database for the info it just gives me the word array and no values. please help

Nick

SpecialFX

Try using a foreach loop, they seem to be more condusive to arrays.

if(isset($_POST['creditTypes'])){ 
$creditTypes = $_POST['creditTypes']; 
    foreach($creditTypes as $types){ 
        $selected_creditTypes .= $types.' '; 
    }
}

tennisnick

Thank you for your help.

I tried that exact code and now instead of an array it just gives me the last value that was checked.

cgraz

I don't see your database query in your post. What does that look like?

tennisnick

As far as the database goes it connects just fine and inputes everything but multipal values for the checkboxes.

			  $con = mysql_connect("localhost", "botlife-2", "botlife");

			   mysql_select_db("botlife-2", $con);
		$sql="INSERT INTO lenders (contactname, titlecompany, emailc, loginpass, state, zip
		,phone, fax, password, lenderbroker, leadsperday, loanType, creditTypes, propertyTypes, licensedStates)
		VALUES
		('$_POST[companyname]','$_POST[titlecompany]','$_POST[emailc]','$_POST[loginpass]','$_POST[state]'
		,'$_POST[zip]','$_POST[phone]','$_POST[fax]','$_POST[password]'
		,'$_POST[lenderbroker]','$_POST[leadsperday]','$_POST[loanType]','$_POST[types]','$_POST[propertyTypes]','$_POST[licensedStates]')";
		if (!mysql_query($sql, $con))
		{
		die('Error: ' . mysql_error());
		}
		echo "1 record added";

		mysql_close($con)

			  ?>

cgraz

Why are you using $POST['creditTypes'] earlier, and $POST['types'] in your query? Are you certain you're using the right value?

Secondly, $POST['types'] (or whichever of the two you are using) is an array. If you just try to insert $POST['types'] into a field, you're going to get the word Array as you are. But your array contains multiple values. How are you planning on inserting all of those values into a single field in your table? Credittypes is designed to hold one value, not an array of values.

You likely need to normalize your tables by creating a second table to hold credit types and linking it to this table's primary key. Than, just run a foreach loop to insert

foreach( $_POST['types'] as $value )
{
	mysql_query("INSERT INTO your_credittype_table (creditType) VALUES('" . $value . "')");
}