checkbox to php database

Question

Hi I am working on an assignment to input 3 checked items into my database. I can't use arrays for this.

Here is my form:

 <p>What are your categories of interest? (Select as many as you'd 
 like below)</p>
 <input name="industry" type="checkbox" value="industry" 
 />Industry<br />
 <input name="technical" type="checkbox" value="technical" 
 />Technical<br />
 <input name="career" type="checkbox" value="career" />Career<br />

Here is my php:

$name = $_POST["name"];
$email = $_POST["email"];
$industry = $_POST["industry"];
$technical = $_POST["technical"];
$career = $_POST["career"];
$role = $_POST["role"];

include("includes/dbconfig.php");

$stmt = $pdo->prepare("INSERT INTO `contacts` (`contactid`, `name`, 
`email`, `industry`, `technical`, `career` `role`) VALUES (NULL, 
'$name', '$email', '$industry', '$technical', '$career', 
'$role');");

$stmt->execute();

header("location:contactthankyou.php");



?>

and my database table has 3 columns (industry, technical, career).

NOTHING WORKS please help

I tried this:

if(! isset($_POST["industry"]))
{$industry = "notchecked";

}else{
$industry = $_POST["industry"];}

It did not work...

And this:

$industry = false;
if( isset($_POST["industry"])) 
{
  $industry = true;
}

You've failed your condition of "_I can't use arrays for this._" by using any `$_POST` value, as that is an array. — GrumpyCrouton, Oct 23 '19 at 20:09
There is code missing here; where is the rest of the HTML/form? — Funk Forty Niner, Oct 23 '19 at 20:18
What are your categories of interest? (Select as many as you'd like below) .
Industry
Technical
Career — P Smith, Oct 23 '19 at 20:20
Basically, a checkbox field is only sent to the PHP IF it is checked. So you have to first test for its existance like `if ( isset($_POST['industry']) ){ // then it was checked` — RiggsFolly, Oct 23 '19 at 20:44

Gökhan Çelebi · Answer 1 · 2019-10-23T20:47:47.213

-1

you need to check which checkboxes are checked before save them. and than you need to give them a value, if not checked. Apply this code for each of them. For example:

if(!isset($_POST["industry"])){

$industry = "notchecked";

}else{
$industry = $_POST["industry"];

}

edited Oct 23 '19 at 20:47

answered Oct 23 '19 at 20:25

Gökhan Çelebi

16
1
2

Where does this go? Does it replace the php where I have $industry = $_POST["industry"]; – P Smith Oct 23 '19 at 20:34
I think that should be `if( ! isset($_POST["industry"]) ){` – RiggsFolly Oct 23 '19 at 20:45

checkbox to php database

1 Answers1