Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old July 17th, 2005, 10: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, 10: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, 10: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

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 Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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 network members.
Post your question now . . .
It's fast and it's free

Popular Articles