How To Insert Html Select Value As Text In Mysql Via Php

I have this select field: ` TSolution 1: Are 775>Tbilisi, 776>Kutaisi static data in html? Simply you can create an array like$regions = array('775'=>'Tbilisi','776'=>'Kutaisi'); Copyand before processing form substitute values:$region = $regions[$_POST['region']]; CopySolution 2: Set up a switch statement with all the values listed and their corresponding names. The major advantage of this is that you have all possible "safe" values already listed, therefore if a user tries to use SQL injection, they won't be able to attack you because it will revert to your default case. However the disadvantage is that if there are lot of fields, you will have to list them all. I'm pretty sure there might be a way to hack the system, to get "innerHTML" property with the POST request, but I'm not sure.$region = $_POST["region"]; switch($region){ case"775": $insert = "Tbilisi"break; ...//more cases default: //if no case matches, do something here break; } CopySolution 3: I don't know if you still need this info, but: 1. first of all, why don't you use the select option like this? <optionvalue="Tbilisi">Tbilisi</option><optionvalue="Kutaisi">Kutaisi</option>CopyThen the Php will take the name directly. If for any reason, the option above is not possible, I would also suggest jQueryuse this (to post your value -as region name - to you php script):$var = $("#regioni option:selected" ).text(); $.post( "your-php-script.php", { region:$var } ); Copythis code above should be included in an event handler (onclick, onselect...) depending what you need. read more about jquery, you need it. Share Post a Comment for "How To Insert Html Select Value As Text In Mysql Via Php" Top Question Firefox, Chrome, Safari Have Grey Background For Mp4 Html5 Video Any video (that I can make) with a white background becomes… Red Border Still Appears On Inputs After Resetting An HTML 5 Form Firefox I have an HTML 5 form! Great, I'm excited! I decide to … Svg Animation And Firefox I'm struggle with SVG animation drawing, which is work … How To Save Html5 Geolocation Data To Python Django Admin? Is it possible to save the javascript html5 geolocation lat… How To Hide/show Tabs Using Jquery I have four tabs.On loading only the first tab is opened an… Form To Iframe Submission - How Do You Reset The Form After File Upload? I have a form that submits the results to an iframe. The su… How To Limit The Html Table Records In Each Page I am populating a table in my jsp which has more than 20 re… How To Display A Python String As Html In Jupyter Notebook In IPython notebook, I used to be able to display a python … How To Add Placeholder Field?

I've been trying to add placeholder in input type='…