php - How to we insert the value between the <option> and </option> into phpmyadmin database, instead of option value?

one text

Solution:

I dont konw if you will need option value also. but if you want only option name value then you can do this with jquery:

<script type="text/javascript">
    $('#location').on('change', function() {
        var selectedOption = $(this).find(':selected').attr('name');
        setIframeSource();
    });
</script>

<select name="loc" id="location"> 
  <li>TV</li>
     <option value = "" disabled selected>Select Channel</option>
     <option name="News" Value="News"><p>News</p></option>
     <option name="ABC News" value="https://www.youtube.com/embed/w_Ma8oQLmSM">ABC News</option> 
     <option name="RT" value="https://www.youtube.com/embed/NvCSr7qzAAM?rel=0&showinfo=0&modestbranding=1" frameborder="0" allowfullscreen="">RT</option> 
     <option name="Bloomberg Live" value="https://www.youtube.com/embed/dp8PhLsUcFE?rel=0&modestbranding=1">Bloomberg Live</option> 
     <option name="Skynews" value="https://www.youtube.com/embed/x5EZPXBuh7g">Sky News</option> 
    
  </select>

and then sent selectedOption variable with ajax.