inserting muptiple checkboxes into one column of database

burna

hy everybody!

for a application i need to add several checkboxes (about 25) into one column in a mysql-database.

i just read about 20 threads in the forum but i did not find a soloution for this.

i only have to save the checked values in database.

the second part of the application is the result of the database where I display the right image for the clicked checkbox.

could anybody help me?
would appreciate it a lot!

bernard

Percadan

Not sure what you are trying to do.
Do you want to input 25 different variables into one column of the table or some result from a function of the 25 variables.

Please elaborate.

tekky

if you are trying to put 25 values into 1 column, you really need to redo the schema for the DB... ideally, you would put 1 value per column...

What kind of data are you trying to track, that would determine how feasible this task is... and how simple it can be made...

broc7

You could use a 25-character string: "ynynnnynyynnynyny...". You could search on individual positions too, I think, but this wouldn't be the best way of storing 25 bits of information in a db.

Percadan

You mean 200 bits?

tekky

Originally posted by Percadan
You mean 200 bits?

burna says about 25... nowhere near 200....

burna

thanks for the answers, i know that my database structure is to small for this application. but i dont wanna make 25 or 30 or more columns for one function!!

isn't there a way to seperate the variables (f.a. 1,5,20,40) and explode the "," and pick the numbers for the right images?

do you think this would work?

broc7

25 yes/no's is 25 bits of information. But of course you're right, if you convert them to y's and n's youv'e got 200 bits. 400 if they're in unicode.

broc7

Another way to do it is bitwise. I'm not familiar with the built-in php functions for this, but basically your first checkbox would be given a value of 1, the second 2, the third 4, the fourth 8, etc. You add them together where that position is yes (or 1). So first yes, second no, and third yes would be 5 (101 in base 2).

Storing 25 bits would require a number up to (2^26)-1, or 67,108,864.

burna

Originally posted by Percadan
Not sure what you are trying to do.
Do you want to input 25 different variables into one column of the table or some result from a function of the 25 variables.

yes, i want to input 25 different variables into one column of table!

each textbox is a variable.

cahva

Check out serialize()-function. Thats what you need.
Heres a little example:

<form method="get" action="form.php"> 
<input type="text" name="var1">
<input type="text" name="var2">
<input type="text" name="var3">
<input type="submit" value="Submit" name="submit">
</form>
<?php
if (!empty($_GET['submit'])) {
        echo '<PRE>';
        $ser=serialize($_GET);
        $ser2=unserialize($ser);
        echo $ser."\n"; // This is what goes to mysql
        print_r($ser2); // Just to show how it works
        echo '</PRE>';
}
?>

burna

Originally posted by cahva
Check out serialize()-function. Thats what you need.
Heres a little example:

<form method="get" action="form.php"> 
<input type="text" name="var1">
<input type="text" name="var2">
<input type="text" name="var3">
<input type="submit" value="Submit" name="submit">
</form>
<?php
if (!empty($_GET['submit'])) {
        echo '<PRE>';
        $ser=serialize($_GET);
        $ser2=unserialize($ser);
        echo $ser."\n"; // This is what goes to mysql
        print_r($ser2); // Just to show how it works
        echo '</PRE>';
}
?>

[/B]

WOW! thats exactly what i've searched for!
thanks a lot!!

but how does the code for the result page look like (result page should display for every individual checkbox a image)

[checkbox 1] => 1.gif

could you help me once again?
i am not so good at array-functions!

greetz,
burna