php - How to Display Option Name in Dropdown using Javascript -


i have 2 dropdowns values populated mysql. second dropdown values depends on first dropdown option.

anyways, code working. using code posting hospital_id php. want display hospital_name text on dropdown well, of able display hospital_id.

please see me code below , suggest me solution:

$query = "select bp_id,bp_name mfb_billing";   $result = $db->query($query);    while($row = $result->fetch_assoc()){     $categories[] = array("bp_id" => $row['bp_id'], "val" => $row['bp_name']);   }    $query = "select bp_id, hospital_id, hospital_name mfb_hospital";   $result = $db->query($query);    while($row = $result->fetch_assoc()){     $subcats[$row['bp_id']][] = array("bp_id" => $row['bp_id'], "val" => $row['hospital_id']);   }    $jsoncats = json_encode($categories);   $jsonsubcats = json_encode($subcats);

this script:

<script type='text/javascript'>       <?php         echo "var categories = $jsoncats; \n";         echo "var subcats = $jsonsubcats; \n";       ?>       function loadcategories(){         var select = document.getelementbyid("categoriesselect");         select.onchange = updatesubcats;         for(var = 1; < categories.length; i++){           select.options[i] = new option(categories[i].val,categories[i].bp_id);                   }       }       function updatesubcats(){         var catselect = this;         var catid = this.value;         var subcatselect = document.getelementbyid("subcatsselect");         subcatselect.options.length = 0; //delete options if present         for(var = 0; < subcats[catid].length; i++){           subcatselect.options[i] = new option(subcats[catid][i].val,subcats[catid][i].hosp);         }       }     </script>

this form:

<body onload='loadcategories()'>    <form id="reportvalue" action="testpj2.php" method="post">      <select id='categoriesselect'>         <option value="1">select billing provider</option>     </select>      <select name='hospitalname[]' id='subcatsselect' multiple='multiple'>         <option value="all">select billing provider</option>     </select> <label for="from">from</label> <input type="text" id="from" name="from"> <label for="to">to</label> <input type="text" id="to" name="to"> <?php //$a = $_request['hospitalname[]']; //echo $a; ?>    <input type="submit" name="submit" value="submit">   </form>

html

 <select id="someid"></select>

javascript

 document.getelementbyid('someid').innerhtml="  <option value='value1'>"+option1+"</option>  <option value='value2'>"+option2+"</option>  <option value='value3'>"+option3+"</option>";

update:

for dynamic data sql query,

try putting these codes after query execution. replace $row['value'] , $row['option'] respected dynamic values.

 echo"<script type='text/javascript'> var str = '' </script>";  while($row = $result->fetch_assoc())  {      echo"<script type='text/javascript'>     str = str + '<option value='+".$row['value']."+'>'+".$row['option']."+'</option>        </script>";  }  echo"<script type='text/javascript'>      document.getelementbyid('someid').innerhtml = str     </script>";

-

Popular posts from this blog

c# - ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file -

overview i want replace oracle.dataaccess orcale. managed dataaccess, opening connection latter throws ora-12537 network session end of file exception. exception message / stack trace {oracleinternal.network.networkexception (0x000030f9): ora-12537 : netzwerksession: dateiende @ oracleinternal.network.readerstream.read(orabuf ob) @ oracleinternal.ttc.orabufreader.getdatafromnetwork() @ oracleinternal.ttc.orabufreader.read(boolean bignoredata) @ oracleinternal.ttc.marshallingengine.unmarshalub1(boolean bignoredata) @ oracleinternal.ttc.ttcprotocolnegotiation.readresponse()} i trying connect oracle 11g database , not have client installed on local machine. working test application (unmanaged) using oracle.dataaccess works fine . using system; using oracle.dataaccess.client; namespace app.odp.unmanaged { internal class program { private static void main(string[] args) { //dummy connection string
Read more

matlab - Compression and Decompression of ECG Signal using HUFFMAN ALGORITHM -

i want compress , decompress ecg signal stored text message text file , find out file size, cr,prd ratio,and qs. here code compression , decompression of ecg signal using huffman algorithm. i'm trying find out file size, compression ratio,prd ratio,qs. but error i'm getting the ecg file in text format. %clearing variables , screen enter code here clear all; close all; clc; [file1]=uigetfile('*.txt'); %fprintf('enter ecg file name :%s',file1); p=file1; t=sprintf('%s',p); b1=dlmread([file1]); len=length(b1); lead=input('enter lead number :'); %lead=str2double(lead); col2=b1(1:end,lead); e=fix(sqrt(len)); m=1; i=1:e j=1:e g2(i,j)=fix(col2(m)*1000); %amplifying 1000 m=m+1; end end g3=g2; i=1:e j=1:e
Read more

utf 8 - split utf-8 string into bytes in python -

i trying split utf-8 string bytes in python 3. problem is, when use bytearray, byte, encode etc functions array size of element 14 bytes, not 1 byte expected. need split text file sequence of bytes , send them byte after byte using sockets. tried this: infile = open (file, "r") str = infile.read() byte_str = bytes(str, 'utf-8') print("size of byte_str",sys.getsizeof(byte_str[0])) print gives me 14, need 1... suggestion? quoting official documentation : sys.getsizeof(object[, default]) return size of object in bytes. object can type of object. built-in objects return correct results, not have hold true third-party extensions implementation specific. only memory consumption directly attributed object accounted for, not memory consumption of objects refers to. if given, default returned if object not provide means retrieve size. otherwise typeerror raised. getsizeof() calls object’s __sizeof__ method , adds
Read more