How To Insert Html Select Value As Text In Mysql Via Php December 14, 2023 Post a Comment I have this select field: ` City...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 IE8 And Border Css Property On Select Menus I am getting a really strange behaviour when viewing a very… Twitter REST API: Possible To Hotlink Twitter Images? Why No Image Display In Firefox? I am trying to extract images from Twitter REST API and dis… Force Download For Blob Created With FileWriter In JavaScript HTML5 introduces the FileWriter class. With this class you … How Can One Make A Container's Child Divs Match The Width Of The Largest Child In IE7? This seems like it should be a duplicate - I've found m… Show Hide Div In One Area I have been looking all day to try and find something that … Why My Website Display Only One Image On IPad? I have problems with my website. There is displayed only on… Html Formatted Text In An Email In Java try{ String msg='Happy BirthDay Dear, '+na… Collapsible Panel In Html/css I'm putting together a website. I need help creating th… Force A Div To Show Up And Overlay Whatever Is In Fullscreen I have a Chrome extension that inserts a menu into the page… What Is The Correct Way For Redirecting From The Domain Name Itself To A Page In A Directory? I want anyone browsing for 'MyDomain.com' to see wh… December 2024 (1) November 2024 (40) October 2024 (59) September 2024 (20) August 2024 (362) July 2024 (338) June 2024 (685) May 2024 (1285) April 2024 (776) March 2024 (1534) February 2024 (1715) January 2024 (1344) December 2023 (1408) November 2023 (439) October 2023 (703) September 2023 (310) August 2023 (330) July 2023 (275) June 2023 (344) May 2023 (212) April 2023 (138) March 2023 (136) February 2023 (170) January 2023 (270) December 2022 (124) November 2022 (231) October 2022 (176) September 2022 (163) August 2022 (290) July 2022 (93) Menu Halaman Statis Beranda © 2022 - Html5 Tutorial