ansaurus

Question

Retrieving saved checkboxes' name and values from database

Answer 1

A:

To save the settings into the database you have to use UPDATE, not INSERT. First you must know the user_id. Then you'll have to issue a query like:

$query = "update User set val = '" . mysql_real_escape_string($str)
       . "' where user_id = $user_id";

You can use PHP's explode function to get an array of values out of your string.

$values = explode(',', $val);

kmkaplan 2009-01-03 10:05:32

Answer 2

+2 A:

In the html form, instead of having

<input type="checkbox" name="choice" value="123">

Do:

<input type="checkbox" name="choice[]" value="123">

This will make the choices available as an array to you.

Then change your php code for inserting the choices into the databse to this:

<?php

$str='';
foreach ($_POST['checked'] as $val)
{
    $str.=$val.',';
}

$str=substr($str,0,-1);//Remove the final comma from the end

$sql="UPDATE users SET vals='$str' WHERE user_id='$user_id'";
mysql_query($sql) or die(mysql_error());

?>

Then when displaying the choices back to the user, do something like this:

Php:

<?php

$checked=array();
$sql="SELECT vals FROM users WHERE user_id='$user_id'";
$result=mysql_query($sql) or die(mysql_error());

$row=mysql_fetch_assoc($row);
$vals=explode(',',$row['vals']);


foreach ($vals as $val)
{
    if ($val !='' && is_numeric($val))
     $checked[$val]='checked';
}

function set_checked($value)
{
    global $checked;
    if (isset($checked[$value]))
     return 'checked';
    else
     return '';
}

?>

In the html:

<input type="checkbox" name="choice[]" value="123" <? echo set_checked('123');?>>

P.S if it helps, please don't forget to upvote / mark as correct :)

P.P.s make sure you replace $user_id with the user id of the user or another way to identify him in the queries.

Click Upvote 2009-01-03 10:58:31

Answer 3

A:

A few questions before I can really write the answer:

Are those checkbox values unique. e.g LEAD DEEP KEEL is the only checkbox that will ever have the value 1825?

2.Do you want to save the sum of the values? e.g. 701 + 1802 + 211 as well?
Will you have associated tables. e.g. will you need to be able to independently select user rows based on their choice?

stuartloxton 2009-01-03 10:59:33

Answer 4

A:

hi stuartloxton

yes these values are unique,, i dont want to save the sum of values they are just for displaying to user,, i have a table contains user register info and conatains also a field that i save the selected checkboxes in

2009-01-03 11:50:45

does my code help?

Click Upvote 2009-01-03 13:03:25

ansaurus

tags:

views:

answers:

Retrieving saved checkboxes' name and values from database

related questions