Connecting Tech Pros Worldwide Help | Site Map

Combining multiple form items to one DB field

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 17th, 2005, 09:59 AM
perplexed
Guest
 
Posts: n/a
Default Combining multiple form items to one DB field

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?


  #2  
Old July 17th, 2005, 09:59 AM
Gerald.Yeo@gmail.com
Guest
 
Posts: n/a
Default 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.

  #3  
Old July 17th, 2005, 09:59 AM
Pedro Graca
Guest
 
Posts: n/a
Default 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!
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.