selected value get from db into dropdown select box option using php mysql error

Question

I need to get selected value from db into select box  please  tell me how to do it  Here is the code   Note   options  value depends on the category     lt  php     sql    select   from mine where username     user        res   mysql query  sql     while  list   mysql fetch assoc  res         category    list  category         username    list  username         options    list  options      gt    lt input type  text  name  category  value   lt  php echo   category    gt   readonly  readonly    gt   lt select name  course  gt      lt option value  0  gt Please Select Option lt  option gt      lt option value  PHP  gt PHP lt  option gt      lt option value  ASP  gt ASP lt  option gt   lt  select gt    lt  php        gt

User · Answer

Select value from drop down      lt select class  form-control  name  category  id  sel1  gt                      lt  php                              foreach  data as  key   gt  value                            gt                                                       lt option value   lt  php echo  data  key - gt name    gt   lt  php if  id name 0 - gt p name   data  key - gt name  echo  selected  selected      gt  gt  lt  php echo  data  key - gt name    gt  lt  option gt                       lt  php     gt      lt  select gt

User · Answer

for example   and please use mysqli   next time because mysql   is deprecated    lt  php  select  select   from tbl assign where id      GET  uid          q mysql query  select  or die  select    row mysql fetch array  q     gt    lt select name  sclient  id  sclient  class  reginput   gt   lt option value    gt Select Client lt  option gt   lt  php  s  select   from tbl new user where type  client     q mysql query  s  or die  s   while  rw mysql fetch array  q       gt   lt option value   lt  php echo  rw  login name      gt   lt  php if  row  clientname     rw  login name    echo  selected  selected      gt  gt  lt  php echo  rw  login name      gt  lt  option gt   lt  php     gt   lt  select gt

User · Answer

Answer is simple  when u pass value from dropdown  Just use as if else  for eg  foreach  result as  row                              GLOBALS  output       lt option value  quot    row  quot dropdownid quot     quot          GLOBALS  passselectedvalueid     row  quot dropwdownid quot       Selected               gt    row  valueetc     lt  option gt

User · Answer

I think you are looking for below code changes    lt select name  course  gt   lt option value  0  gt Please Select Option lt  option gt   lt option value  PHP   lt  php if  options   PHP   echo  selected  selected      gt   gt PHP lt  option gt   lt option value  ASP   lt  php if  options   ASP   echo  selected  selected      gt   gt ASP lt  option gt   lt  select gt

User · Answer

THE EASIEST SOLUTION It will add an extra  in your options but your problem will be solved   lt  php      if   editing    Yes            echo  quot  lt option value   quot   MyValue   quot  SELECTED gt  quot   MyValue  quot  lt  option gt  quot           gt

User · Answer

This may help you    php   sql    select   from mine where username     user      res   mysql query  sql   while  list   mysql fetch assoc  res      category    list  category     username    list  username     options    list  options      gt   lt input type  text  name  category  value   lt  php echo   category    gt   readonly  readonly    gt   lt select name  course  gt   lt option value  0  gt Please Select Option lt  option gt     Assuming  list  options   is a coma seperated options string   arr explode      list  options      lt  php foreach   arr as  value      gt      lt option value   lt  php echo  value    gt   gt  lt  php echo  value    gt  lt  option gt   lt  php    gt   lt  select gt    lt  php      gt

User · Answer

USING POD   lt  php  username    root    password        db    db name     dns    mysql host localhost dbname  db charset utf8mb4        conn   new PDO  dns  username   password        conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION         sql    select   from mine where username              stmt1    conn- gt prepare  sql        stmt1 - gt  execute array   POST  user           all    stmt1- gt fetchAll      gt        lt div class  controls  gt           lt select  data-rel  chosen   name  degree id  id  selectError  gt                     lt  php foreach  all as  nt    echo   lt option value   nt id  gt  nt name  lt  option gt      gt           lt  select gt        lt  div gt

User · Answer

The easiest way I can think of is the following   lt  php   selection   array  PHP    ASP    echo   lt select gt         lt option value  quot 0 quot  gt Please Select Option lt  option gt     foreach   selection as  selection         selected     options     selection     quot selected quot     quot  quot       echo   lt option    selected   value  quot    selection   quot  gt    selection   lt  option gt       echo   lt  select gt     The code basically places all of your options in an array which are called upon in the foreach loop  The loop checks to see if your  options variable matches the current selection it s on  if it s a match then  selected will   selected  if not then it is set as blank  Finally the option tag is returned containing the selection from the array and if that particular selection is equal to your  options variable  it s set as the selected option

User · Answer

BEST code and simple    lt select id  example-getting-started  multiple  multiple  name  category  gt        lt  php      query    select   from mine        results   mysql query  query        while   rows   mysql fetch assoc   results           gt       lt option value   lt  php echo  rows  category     gt   gt  lt  php echo  rows  category     gt  lt  option gt        lt  php              gt   lt  select gt

User · Answer

You can also do like this        lt  php   countryname    all meta for user  country      gt    lt select id  mycountry   name  country  class  user  gt        lt  php  myrows    wpdb- gt get results   SELECT   FROM wp countries order by country name         foreach  myrows as  rows           if   countryname     rows- gt id                 echo   lt option selected    selected  value     rows- gt id    gt    rows- gt country name   lt  option gt              else               echo   lt option value     rows- gt id    gt    rows- gt country name   lt  option gt                          gt   lt  select gt

User · Answer

Just Add an extra hidden option and print selected value from database   lt option value   lt  php echo  options   gt   hidden gt  lt  php echo  options   gt  lt  option gt   lt option value  PHP  gt PHP lt  option gt   lt option value  ASP  gt ASP lt  option gt

[php] selected value get from db into dropdown select box option using php mysql error

Examples related to php

Examples related to mysql