php - Using POST to get select option value from HTML form -

-

i have form different information. have select multiple options , want able send database in 1 or 0 / true or false. not working. code far:

              <select name="multipleselect[]" multiple>                 <option value="" disabled selected>choose option</option>                 <option name="esea" value="esea">esea</option>                 <option name="faceit" value="faceit">faceit</option>                 <option name="matchmaking" value="matchmaking">matchmaking</option>               </select>               <label>what looking play?</label>

and php:

$esea = 0; $faceit = 0; $matchmaking = 0; foreach ( $_post['multipleselect'] $value ) {     if ( $value == 'esea' )        { $esea = 1;       }     if ( $value == 'faceit' )      { $faceit= 1;      }     if ( $value == 'matchmaking' ) { $matchmaking= 1; } }        // sätt in datan   $sql = "insert users ( steamid, profilename, profileurl, avatar, region, age, ranks, esea, faceit, matchmaking, textarea1 ) values (      '{$mysqli->real_escape_string($_post['steamid'])}',      '{$mysqli->real_escape_string($_post['profilename'])}',     '{$mysqli->real_escape_string($_post['profileurl'])}',     '{$mysqli->real_escape_string($_post['avatar'])}',     '{$mysqli->real_escape_string($_post['region'])}',     '{$mysqli->real_escape_string($_post['age'])}',     '{$mysqli->real_escape_string($_post['ranks'])}',     $esea,     $faceit,     $matchmaking',     '{$mysqli->real_escape_string($_post['textarea1'])}')";   $insert = $mysqli->query($sql);

i know code doesnt work don't know make work. wan't send 1 or 0 depending on if chose alternative or not.

your <select> multiple selectable dropdown needs array, defined name="namethatmakessense[]"

<select name="namethatmakessense[]" multiple>

this return field called $_post['namethatmakessense'] array containing 1 or more values indicating items in dropdown selected. value="" attribute of <option> tag

then need preprocess namethatmakessense array pick values selected form multi select dropdown.

$esea = 0; $esea = 0; $esea = 0; foreach ( $_post['namethatmakessense'] $value ) {     if ( $value == 'esea' )        { $esea = 1;       }     if ( $value == 'faceit' )      { $faceit= 1;      }     if ( $value == 'matchmaking' ) { $matchmaking= 1; } }      $sql = "insert users               ( profilename, profileurl, avatar, region,                 age, esea, faceit, matchmaking, textarea1 )          values (   '{$mysqli->real_escape_string($_post['profilename'])}', '{$mysqli->real_escape_string($_post['profileurl'])}', '{$mysqli->real_escape_string($_post['avatar'])}', '{$mysqli->real_escape_string($_post['region'])}', '{$mysqli->real_escape_string($_post['age'])}', '{$mysqli->real_escape_string($_post['ranks'])}', $esea, $faceit, $matchmaking, '{$mysqli->real_escape_string($_post['textarea1'])}')";

Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more