Connecting Tech Pros Worldwide Help | Site Map

Combining multiple form items to one DB field

perplexed
Guest
 
Posts: n/a
#1: Jul 17 '05
Is there a way to combine the values of multiple form items such as two
textboxes and one radio button for insertion into one MYSQL database
field?

Gerald.Yeo@gmail.com
Guest
 
Posts: n/a
#2: Jul 17 '05

re: Combining multiple form items to one DB field


Just use the dot operator to join the fields, i.e.

$combined = $_POST['textfield_1'] . $_POST['textfield_2'] .
$_POST['radio_button'];

that way you can use $combined to insert into MySql attribute. Hope
this helps.

Pedro Graca
Guest
 
Posts: n/a
#3: Jul 17 '05

re: Combining multiple form items to one DB field


perplexed wrote:[color=blue]
> Is there a way to combine the values of multiple form items such as two
> textboxes and one radio button for insertion into one MYSQL database
> field?[/color]

I think you would do better by revising your database structure.

Anyway, try this (unchecked and missing validation):

$combined = '';
$combined .= serialize($_POST['text1']);
$combined .= serialize($_POST['text2']);
$combined .= serialize($_POST['radio']);
/* write $combined to a DB text column */


And reading it back in:

$combined = 's:5:"text1";s:5:"text2";b:1;';
/* last value was read from the DB */
$values = explode(';', $combined);
$text1 = unserialize($values[0]);
$text2 = unserialize($values[1]);
$radio = unserialize($values[2]);

--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!
Closed Thread