php - Display predefined value in dropdown list -


i have list of vendors wish edit them. on click of edit button, redirected page editvendor.php have parametrs wish edit, in page have 2 interdependent dropdown list through can categorize each vendor under scpecific category , subcategory. code dropdown is

<script> $(document).ready(function(){     $('#cat').change(function(){         var catid = $('#cat').val();          if(catid != 0)         {             $.ajax({                 type:'post',                 url:'fetchsubcat2.php',                 data:{id:catid},                 cache:false,                 success: function(returndata){                     $('#subcat').html(returndata);                 }             });         }     }) }) </script>  <fieldset>     <label>category</label>     <select name="catid" id="cat" >         <option value=""> please select category </option>         <?php                 $sql = "select * category";                 $result = mysqli_query($con, $sql);                  if (mysqli_num_rows($result) > 0) {                     while($row = mysqli_fetch_assoc($result))                          {                             $catname=$row["category"];                             $catid=$row["id"];         ?>         <option value="<? echo $catid;?>"><? echo $catname;?></option>                         <?}                 }?>     </select> </fieldset>   <fieldset>     <label>sub category</label>     <select name="subcatid" id="subcat" >         <option></option>     </select> </fieldset>

code fetchsubcat2.php

<?php     require 'connection.php';     $catid =  $_request['id'];           $sql = "select * subcategory catid='".$catid."'";         $result = mysqli_query($con, $sql);          if (mysqli_num_rows($result) > 0)              {                 ?><option value="">select subcategory</option><?                 while($row = mysqli_fetch_assoc($result))                      {                         $subcatname=$row["subcatname"];                         $subcatid=$row["id"]; ?>  <option value="<? echo $subcatid;?>"><? echo $subcatname;?></option>                   <?}             }         else             {?>                 <option value="">no sub category </option>             <?}?>

now want if vendor under category , subcategory in place of "please select category" , "select subcategory" existing category , subcategory should displayed. shown below, in place of

enter image description here

i want

enter image description here

after if want change category/subcategory can clicking on dropdown list.

table view

vendor table

id vendorname catid catname subcatid subcatname 1 abc 1 c1 3 s3

for optiontag, 1 associated vendor, add selected parameter pre-select in select list.

for need know, category vendor belongs to, can't find code referring that, example , bit of guesswork: id of category vendor belongs , in while loop of of categories check, if id matches vendor-catid:

<?php while($row = mysqli_fetch_assoc($result)) {     $catname=$row["category"];     $catid=$row["id"];     ?>     <option value="<? echo $catid;?>" <?php echo ( $catid === $vendorcatid ? 'selected' : ''); ?>><? echo $catname;?></option> <?}

Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more