How To Insert HTML Select Value As Text In MySQL Via PHP

I have this select field: ` T Solution 1: Are 775>Tbilisi, 776>Kutaisi static data in html? Simply you can create an array like $regions = array('775'=>'Tbilisi','776'=>'Kutaisi'); Copy and before processing form substitute values: $region = $regions[$_POST['region']]; Copy Solution 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; } Copy Solution 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? <option value="Tbilisi">Tbilisi</option> <option value="Kutaisi">Kutaisi</option> Copy Then the Php will take the name directly. If for any reason, the option above is not possible, I would also suggest jQuery use this (to post your value -as region name - to you php script): $var = $( "#regioni option:selected" ).text(); $.post( "your-php-script.php", { region: $var } ); Copy this 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 Input Type Datetime-local Is Not Working In Firefox I have an input type of datetime-local which is working fin… Google Org Chart Data Overflow Outside Of Div I'm using Google Org chart for a project and the conten… Using Bootstrap 4 Flexbox To Equally Divide Four Charts I am trying to plot four different stacked charts in one br… CSS Lighten Child Elements On Parent Mouseover here is my problem. I have a div which contains two other d… Div Is Shown In Wrong Position I have such code: Solution 1: Add margin: 0 auto … Some Weird Thing With Clear Both Via Css Pseudo :after Examine this code: HTML Sometext over here CSS .one { di… Disable Drop Down Option Using Jquery I need to disable options with value '- Sold Out -'… Element On Top Of Parent's Sibling I am trying to get an element to appear on top of its paren… Div Centering CSS I am struggling with my website, I am trying to get the div… Flex-box Only Display As Many Items That Fit In A Container I want to only use CSS to make it so I have a container whi… December 2024 (1) November 2024 (37) October 2024 (69) September 2024 (20) August 2024 (358) July 2024 (338) June 2024 (679) May 2024 (1294) April 2024 (687) March 2024 (758) February 2024 (840) January 2024 (759) December 2023 (809) November 2023 (367) October 2023 (556) September 2023 (291) August 2023 (325) July 2023 (276) June 2023 (346) May 2023 (212) April 2023 (139) March 2023 (143) February 2023 (174) January 2023 (255) December 2022 (121) November 2022 (228) October 2022 (809) September 2022 (164) August 2022 (289) July 2022 (93) Menu Halaman Statis Beranda © 2022 - Html5 Tutorial