Insert Multiple Checkbox Value in Database Using PHP

Question

how can i insert loop value into database stored all values into array please take a look and suggest me

$data['name'] = mysql_real_escape_string($_POST['name']);
    $data['email'] = $_POST['email'];
    $data['password'] = $_POST['password'];
    $data['gender'] = $_POST['gender'];
    $data['dob'] = $_POST['dob'];
    $data['address'] = $_POST['address'];
    $data['country'] = $_POST['country'];
    $data['hobbie'] = $_POST['hobbie'];

$checkElement = "";
    foreach($data['hobbie'] as $check=>$chkValue){
        $checkElement = $chkValue.","."<br>";

        echo $data['hobbie']= $checkElement;
// here i am getting all value

    }
//outside of loop i am getting only last value

Your loop is only referencing the 'hobbie' index of your array: foreach($data['hobbie'] as $check=>$chkValue){ - is this expected? — Callan Heard
– Callan Heard, Commented Sep 7, 2015 at 17:17
yes i jst want to get the values into $data['hobbie'] what ever in the checkboxes array so that i can directly inserted into table — user4464505
– user4464505, Commented Sep 7, 2015 at 17:47
how you can directly insert into table with $data['hobbie'];. Since, you don't know how many hobbies are selected. You need to have for loop for multiple selected checkbox. Insertion will be done inside for loop only. — Nana Partykar
– Nana Partykar, Commented Sep 7, 2015 at 17:49

Nana Partykar · Accepted Answer · 2015-09-07 18:19:31Z

1

$data['name'] = mysql_real_escape_string($_POST['name']);
$data['email'] = $_POST['email'];
$data['password'] = $_POST['password'];
$data['gender'] = $_POST['gender'];
$data['dob'] = $_POST['dob'];
$data['address'] = $_POST['address'];
$data['country'] = $_POST['country'];
$Hobbie = $_POST['hobbie'];

$TotalCheckedHobbie=sizeof($Hobbie);
$Hobbies = "";
for($i=0;$i<$TotalCheckedHobbie;$i++)
{
    $Hobbie=$Hobbie[$i];
    $Hobbies=$Hobbie.",";
}
echo $Hobbies;

edited Sep 7, 2015 at 18:19

answered Sep 7, 2015 at 17:21

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user4464505 Over a year ago

Hi danish I have already created a function for insertion now i am getting Array ( [name] => Chrish [email] => [email protected] [password] => 222 [gender] => male [dob] => 08/05/1988 [address] => Mumbai [country] => India [hobbie] => Array ( [0] => Cricket [1] => Hockey [2] => Badminton [3] => Volleyball ) ) these value bt in India[hobbie] i dont want array in want only value that can insert into direct.

Nana Partykar Over a year ago

@user4464505: Edited. Check it.

Collectives™ on Stack Overflow

Insert Multiple Checkbox Value in Database Using PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related