SQL no inserting properly into DB?

[rootKID]

Hi W3S! Time for another question (lol)

 

So, i've been struggling with this for the past 2 days now, and can't seem why the SQL not would insert the damn query :/

 

The thing is, i have ALOT of checkboxes/information that has to be inserted to the database IF the checkbox is checked.

 

This is the code for the checkboxes (new_data.php):

// <center>TITLE HEADER</center> (80 Items)$checkboxes_centers = array(	"<center>Navn</center>",	"",	"",	"",	"<center>Informationer</center>",	"",	"",	"",	"",	"",	"",	"",	"",	"",	"",	"<center>Fødselsdags Dato</center>",	"",	"<center>Nuværende Stilling</center>",	"",	"",	"",	"<center>Civiltilstand</center>",	"",	"",	"",	"",	"",	"",	"<center>Kandidatens Billede</center>",	"",	"<center>Beskrivelse (Af Kandidat)</center>",	"",	"<center>Nøgleord</center>",	"",	"",	"",	"",	"",	"<center>Karakterisering</center>",	"",	"<center>Tilføjelser</center>",	"",	"<center>Styrke</center>",	"",	"<center>Største Success</center>",	"",	"<center>Svaghed</center>",	"",	"<center>Under Pres</center>",	"",	"<center>Konfliktsituation</center>",	"",	"<center>Motiv</center>",	"",	"<center>Karrierer</center>",	"",	"<center>Ryger</center>",	"",	"<center>Sygdomme</center>",	"",	"<center>Opsigelsesvarsel</center>",	"",	"",	"",	"<center>Gage</center>",	"",	"",	"",	"",	"",	"",	"",	"",	"",	"",	"",	"<center>Eksamen</center>",	"",	"",	"<center>Beskæftigelse</center>",	"",	"<center>Reference (1)</center>",	"",	"",	"",	"",	"",	"",	"",	"<center>Reference (2)</center>",	"",	"",	"",	"",	"",	"",	"",	"<center>Reference (3)</center>",	"",	"",	"",	"",	"",	"",	"",	"<center>Relevant</center>",	"",	"<center>Fritid</center>",	"",	"<center>Jobsøgende</center>",	"",	"<center>Jobsamtale</center>",	"",	"",	"",	"<center>Være Til Jobsamtale?</center>",	"",	"",	"",); // End "$checkboxes_centers"// <label> text </label> (80 Items)$checkboxes_names = array(	"VIS SEKTION",	"Fornavn",	"Mellemnavn",	"Efternavn",		"VIS SEKTION",	"Gadenavn",	"Nr",	"Etage",	"Side",	"Postnr",	"By",	"Land",	"Email",	"Telefon",	"Mobil",		"VIS SEKTION",	"Fødseldato (CPR / 6-cifre)",		"VIS SEKTION",	"Stillings Titel",	"Stillings Virksomhed",	"Stillings Job",		"VIS SEKTION",	"Tilstand",	"Drenge Hjemme",	"Drengenes aldre",	"Piger Hjemme",	"Pigernes aldre",	"Hvordan kom de til?",		"VIS SEKTION",	"Kandidat Billede",		"VIS SEKTION",	"Beskriv dig selv",		"VIS SEKTION",	"Nøgleord 1",	"Nøgleord 2",	"Nøgleord 3",	"Nøgleord 4",	"Nøgleord 5",		"VIS SEKTION",	"Karakterisering",		"VIS SEKTION",	"Tilføjelser",		"VIS SEKTION",	"Styrke",		"VIS SEKTION",	"Største Success",		"VIS SEKTION",	"Svaghed",		"VIS SEKTION",	"Under Pres",		"VIS SEKTION",	"Konfliktsituation Takling",		"VIS SEKTION",	"Motiv",		"VIS SEKTION",	"Karriere",		"VIS SEKTION",	"Ryger",		"VIS SEKTION",	"Sygdomme",		"VIS SEKTION",	"Varsel antal måneder",	"Varsel særligt måneder",	"Klausuler",		"VIS SEKTION",	"Forventet månedsløn",	"Smærtegrænse",	"Nuværende månedsløn",	"Pension valuta",	"Bonus spørgsmål",	"Bonus valuta",	"PC/ADSL?",	"Bil",	"Telfon",	"Mobil",	"Andet",		"VIS SEKTION",	"Eksamen (Ja / Nej)",	"Forklaring",		"VIS SEKTION",	"Beskæftigelsesløn",		"VIS SEKTION",	"(1) Navn",	"(1) Titel",	"(1) Virksomhed",	"(1) Relation",	"(1) TLF",	"(1) Mobil",	"(1) Mail",		"VIS SEKTION",	"(2) Navn",	"(2) Titel",	"(2) Virksomhed",	"(2) Relation",	"(2) TLF",	"(2) Mobil",	"(2) Mail",		"VIS SEKTION",	"(3) Navn",	"(3) Titel",	"(3) Virksomhed",	"(3) Relation",	"(3) TLF",	"(3) Mobil",	"(3) Mail",		"VIS SEKTION",	"Relevant",		"VIS SEKTION",	"Fritid",		"VIS SEKTION",	"Jobsøgende (Ja / Nej)",		"VIS SEKTION",	"Jobsamtale (Ja / Nej)",	"Virksomhed",	"Dato",		"VIS SEKTION",	"Været Til Jobsamtale",	"Virksomhed",	"Dato"); // End "$checkboxes_names"// NO SPACES IN CONTENT! THESE ARE <input id="$ids">!!! (80 Items)$checkboxes_ids = array(	"section_names",	"fornavn",	"mellemnavn",	"efternavn",		"section_information",	"info_gadenavn",	"info_nr",	"info_etage",	"info_side",	"info_postnr",	"info_by",	"info_land",	"info_email",	"info_telefon",	"info_mobil",		"section_borndate",	"foedsel_dato",		"section_stilling",	"stilling_titel",	"stilling_virksomhed",	"stilling_job",		"section_civil",	"civil_tilstand",	"civil_drengehjemme",	"civil_drengesalder",	"civil_pigerhjemme",	"civil_pigersalder",	"civil_hvordan",		"section_avatar",	"billede",		"section_beskrivelse",	"beskriv_dig_selv",		"section_noegleord",	"noegleord_et",	"noegleord_to",	"noegleord_tre",	"noegleord_fire",	"noegleord_fem",		"section_karakterisering",	"karakterisering",		"section_tilfoejelser",	"tilfoejelser",		"section_styrke",	"styrke",		"section_stoerste_success",	"stoerste_success",		"section_svaghed",	"svaghed",		"section_under_pres",	"under_pres",		"section_konflikt_takling",	"konflikt_takling",		"section_motiv",	"motiv",		"section_karriere_oensker",	"karriere_oensker",		"section_ryger",	"ryger",		"section_sygdomme",	"sygdomme",		"section_opsigelsesvarsel",	"varsel_antal_mdr",	"varsel_saerligt_mdr",	"klausuler",		"section_gageforventninger",	"gage_oenskede_maaneds_loen",	"gage_smaertegraense",	"gage_nuvaerende_maaneds_loen",	"gage_pension_valuta",	"gage_bonus_spoergsmaal",	"gage_bonus_valuta",	"gage_pcadsl",	"gage_bil",	"gage_telefon",	"gage_mobil",	"gage_andet",		"section_eksamensbeviser",	"eksamen_ja_nej",	"eksamen_forklaring",		"section_anden_loen",	"anden_beskaeftigelses_loen",		"section_referencer_one",	//"ref_one",	"ref_one_navn",	"ref_one_titel",	"ref_one_virksomhed",	"ref_one_relation",	"ref_one_tlf",	"ref_one_mobil",	"ref_one_mail",		"section_referencer_two",	//"ref_two",	"ref_two_navn",	"ref_two_titel",	"ref_two_virksomhed",	"ref_two_relation",	"ref_two_tlf",	"ref_two_mobil",	"ref_two_mail",		"section_referencer_three",	//"ref_three",	"ref_three_navn",	"ref_three_titel",	"ref_three_virksomhed",	"ref_three_relation",	"ref_three_tlf",	"ref_three_mobil",	"ref_three_mail",		"section_relevant",	"relevant",		"section_fritid",	"fritid",		"section_jobsoende_ja_nej",	"jobsoende_ja_nej",		"section_jobsamtale_ja_nej",	"jobsamtale_ja_nej",	"jobsamtale_virksomhed",	"jobsamtale_dato",		"section_jobsamtale_vaeret_ja_nej",	"jobsamtale_vaeret_ja_nej",	"jobsamtale_vaeret_virksomhed",	"jobsamtale_vaeret_dato",); // End "$checkboxes_ids"for($i=0; $i < sizeof($checkboxes_names); $i++){	echo $checkboxes_centers[$i];	echo "<input type='checkbox' checked='checked' name='cat[dsfs_".$checkboxes_ids[$i]."]' id='".$checkboxes_ids[$i]."' value='' style='float: left;'>";	echo "<label for='".$checkboxes_ids[$i]."' style='float: left;'>".$checkboxes_names[$i]."</label>";}

and this is the code for the check-boxes insertion (add_data.php):

$dsfs_id_runner = $ds_FK_dsg_id_runner;$checkboxes = (isset($_POST['cat']) ? $_POST['cat'] : array());if( isset($checkboxes) ){	// K == Keys	// V == Values	$keys = array();	$values = array();		foreach( $checkboxes as $k => $v )	{		$keys[] = $k;		$values[] = 1;	}		$query_dsfs = "INSERT INTO dataskema_forms_settings ( ".implode(',', $keys)." ) VALUES ( ".implode(',', $values)." )";	$mysqli->query($query_dsfs);		//die("You just passed the checkpoint of where the query SHOULD have been successfully made!");}

Since i have a "for-loop" at the checkboxes to make them because i have ALOT of them, i thought to make an array of a sort to insert into the database for me.

The names are EXACLY the same in the database with the one exception of a prefix added to them, which is (dsfs_)... this was only to make sure the database names were unique, and form was unique.

 

Any ideas to why i simply can't insert this one Oo?

I mean when i had the error of a wrong variable, it made a simple query to the database (almost working), but now when it's correct... wont do it... whatever i do, any ideas? This is kind of urgent (sort of)...

 

Thanks alot in advance if anyone can help me!

[justsomeguy]

That's a great example of why not to use parallel arrays. Instead of 3 big arrays, why not 1 array of checkbox objects that contain all of the details for each checkbox?You should print out the insert query, hopefully you can spot the problem there. If not, get the error from MySQL after trying to run the query.