checkboxes

zooropa

I wonder if someone could point me in the right direction.

I have a simple table tbl_friends with just 2 fields:

friend_id
first_name

I have a page called checkbox.php which contains 3 checkboxes (Tom, Dick and Harry) and one submit button. When I check Tom and Harry then click Submit I would like the firstname field to add 2 new records, namely Tom and Harry to the first_name field (friend_id is just an autonumber primary key).

I just can't figure out the syntax to make this happen. I believe i want to create a checkbox array hence the square braces [] but i don't understand what that means - i just read it.

When I click the Submit button, the friend_id field is auto-incrementing so i know the connection to the database and query string is ok.

Code below:

<?php

require_once('mysqli_connect.php');

if (isset($_POST['submitted'])){

$fn=trim($_POST['first_name']);

$q1="INSERT INTO tbl_friends (first_name) VALUE ('$fn')";

$r=mysqli_query($dbc,$q1);

if ($r) {
echo '<h1>Data Sent OK</h1>';
}
mysqli_close($dbc);
exit();

}

Tom <input type="checkbox" name="friends[]" value="<?php echo $POST['first_name'];?>"/>
Dick <input type="checkbox" name="friends[]" value="<?php echo $POST['first_name'];?>"/>
Harry <input type="checkbox" name="friends[]" value="<?php echo $_POST['first_name'];?>"/>

</form>

dagon

your form is wrong for a start, the value would be blank on first send as there would be not $_POST array so you would not know what was checked.

zooropa

Thanks Dagon - I guessed my form was wrong but i'm still no further forward! Does anyone fancy modifying my code and re-posting - that would be a big help!

zooropa

I managed to solve my problem: Code as follows:

<br />

<br />

<label>
<input type="checkbox" name="first_name[]" value="Harry" id="test_2" />
Harry</label>

<br />

<?php
require_once('mysqli_connect2.php');
foreach($_POST['first_name'] as $index => $val){
$q1="INSERT INTO tbl_friends (first_name) VALUES('$val')";
$r = mysqli_query($dbc,$q1);
}
?>

and the contents of mysqli_connect2.php (for a mysql user = mark with password=sprite)are

<?php

DEFINE ('DB_USER','mark');
DEFINE ('DB_PASSWORD','sprite');
DEFINE ('DB_HOST','localhost');
DEFINE ('DB_NAME','sitename');

$dbc=@mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) OR die ('Could not connect to MySQL:'.mysqli_connect_error());