How to save name of select option instead of value

Question

I have this code:

$("#subscription").on('change', function(){
  $('#plan').val($(this).val());
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<select name="bank_name" class="form-control input-md chosen-select" id="subscription">
  <option value="">Choose Bank</option>
  <option value="swiftbank1">bank 1</option>
  <option value="swiftbank2">bank 2</option>
</select>
<input type="text" id="plan" class="form-control input-md" name="swift">

What it does is add swift code in to the input field, that works fine!

Problem is that when I add data on database then both values is what I choose example I choose bank 1 then both will be saved as swiftbank1 .

I need it to save bank name (bank 1) and swift (swiftbank1) in database.

I understand that value is what it is but is it possible to add name in database instead of value? In this case this value works to be passed from selection to input.

Thanks

Do you mean with name for isntance bank 1 instead of swiftbank1? — utdev, Sep 09 '16 at 10:55
it saves swiftbank1 in database for option but yes i need it to save bank 1 instead — Ingus, Sep 09 '16 at 10:56
How are you generating these inputs, where does the information come from? You should only have to store 1 value in the database - the value - as the other can always be retrieved based on that value. — jeroen, Sep 09 '16 at 11:01
It should be in the database, a configuration file or something similar. — jeroen, Sep 09 '16 at 11:03
I believe [this](http://stackoverflow.com/questions/1085801/get-selected-value-in-dropdown-list-using-javascript) might answer your question. — B. Jansen, Sep 09 '16 at 11:11

devpro · Accepted Answer · 2016-09-09T12:06:25.180

3

You can use .text for getting selected text.

$("#subscription").on('change', function(){
var text = $("#subscription :selected").text();
var value = $("#subscription").val();
console.log(text); // this will print text
console.log(value); // this will print value
//var plan = $('#plan').val(text); // this will change the value of plan
$("#plan").attr("value",text); // this will add the value attribute 
$('#plan').val(text); // this will change the value of plan
$('#subscription :selected').val(value);
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<select name="bank_name" class="form-control input-md chosen-select" id="subscription">
<option value="">Choose Bank</option>
<option value="swiftbank1">bank 1</option>
<option value="swiftbank2">bank 2</option>
</select>
<input type="text" id="plan" class="form-control input-md" name="swift">

edited Sep 09 '16 at 12:06

answered Sep 09 '16 at 11:12

devpro

16,184
3
27
38

@IngusGraholskis: chk the snippet – devpro Sep 09 '16 at 11:22
this just copy bank name to SWIFT but at SWIFT need to be swiftbank1 – Ingus Sep 09 '16 at 11:30
it just copy bank name to input now instead of swift – Ingus Sep 09 '16 at 11:43
@IngusGraholskis: than just use `value` instead of `text` – devpro Sep 09 '16 at 11:44
@IngusGraholskis: in `$("#plan").attr("value",value);` and `$('#plan').val(value);` – devpro Sep 09 '16 at 11:46
it does the same thing my code did only yours is bigger .still saves option as swiftbank1 instead of bank 1 – Ingus Sep 09 '16 at 11:51
@IngusGraholskis: in these two lines, u can get everything `console.log(text); // this will print text console.log(value); // this will print value` u must need to learn this. – devpro Sep 09 '16 at 11:52
@IngusGraholskis: if i select `bank 1` than swift value should be `swiftbank1` and bank should be `bank 1` not `swiftbank1` .. right – devpro Sep 09 '16 at 11:55
yes that how it should look and be saved on database – Ingus Sep 09 '16 at 11:57
there is one good and one bad thing :D they do save but NAME result saves in SWIFT place and SWIFT result saves in NAME place.also before saving both results showing as bank name not name and swift – Ingus Sep 09 '16 at 12:02
also #subscription is the one saves wrong reslult. it should save as bank name not the #plan – Ingus Sep 09 '16 at 12:05
@IngusGraholskis: then change the value as u need. – devpro Sep 09 '16 at 12:07
@IngusGraholskis: finally, glad to help u – devpro Sep 09 '16 at 12:11

score 0 · Answer 2 · answered Sep 09 '16 at 11:00

0

try this to get text of selected option

$("#subscription").on('change', function(){
    $('#plan').val(this.options[this.selectedIndex].text);
});

answered Sep 09 '16 at 11:00

Sasikumar

863
5
9

https://jsfiddle.net/cjyzsxt6/ look at this fiddle. bank 1 is placed in the input box – Sasikumar Sep 09 '16 at 11:04
Thats not what i need – Ingus Sep 09 '16 at 11:06
hey wats the ouput you need from javascript. you need the value or text or both – Sasikumar Sep 09 '16 at 11:08
when user select "bank 1" javascript pass value "swiftbank1" to the input. the problem is that on putting it in database option value in database is also "swiftbank1" instead of "bank 1" – Ingus Sep 09 '16 at 11:11

score 0 · Answer 3 · answered Sep 09 '16 at 11:11

0

Since you will need to pass the value to store in database so a quick way is to keep the value as swiftbank1###bank1

Split the string with ### on server end and store them separately like this:

 $selectValue = $_POST['select_name'];
 $valueArray = explode("####",$selectValue);

$valueArray[0] will have swiftbank1 and $valueArray[1] will have bank1

answered Sep 09 '16 at 11:11

Danyal Sandeelo

12,196
10
47
78

I do not get it till end were will i put $valueArray? – Ingus Sep 09 '16 at 11:23
in your .php file where the form values are posted – Danyal Sandeelo Sep 09 '16 at 11:26
and were then swiftbank1###bank1 will store? – Ingus Sep 09 '16 at 11:31
no where, you just need to pass it to get concatenated value as post ... and then your new values will be accessed by `$valueArray[0]` and `$valueArray[1]` – Danyal Sandeelo Sep 09 '16 at 11:33
i m sorry i m a newbe in arrays :D – Ingus Sep 09 '16 at 11:42

score 0 · Answer 4 · answered Sep 09 '16 at 11:14

0

use this $('#plan').val($('#subscription option:selected').text());

answered Sep 09 '16 at 11:14

Ankur Pathak

49
6

it just copy bank name to input – Ingus Sep 09 '16 at 11:25
no in input must be this swiftbank1 and need that bank name saves in option value – Ingus Sep 09 '16 at 11:38
you mean you want the textbox to show the value of option but want to store the text in the DB. Is that so.. ? – Ankur Pathak Sep 09 '16 at 12:13
Its fixed check for checked answer :) – Ingus Sep 09 '16 at 12:13
Please, always give some explanation and not only the plain code – andreas Sep 09 '16 at 13:32

How to save name of select option instead of value

4 Answers4