javascript - on change jquery only works once for db values -

-

i have 3 select boxes ids first-choice, second-choice , third choice.

  <select id="first-choice" style="border-radius: 0; width: 100%;"  class="form-control" name="area">                                     <option value="">-select-</option>                                     <option value="">all</option>                                     <?php                                     global $connection;                                     $area_query = "select distinct area archivo length(area) > 1";                                     $result_area = mysqli_query($connection, $area_query );                                     while($row_a = mysqli_fetch_array($result_area)):                                     ?>                                         <option><?php echo $row_a['area'] ?></option>                                     <?php endwhile;?>                                 </select>  <select id="second-choice" style="border-radius: 0; width: 100%"  class="form-control" name="category">                                    <option value="">-select-</option>                                  </select>  <select id="third-choice" style="border-radius: 0; width: 100%"  class="form-control" name="product">                                     <option value="">-select-</option>                                   </select>

and have following jquery code: 

$(document.body).on('change','#first-choice',function(){     //alert('change happened');     $("#second-choice").load("../config/select_eng.php?choice=" + $("#first-choice").val());  });   $(document.body).on('change','#second-choice',function(){     //alert('change happened');     $("#third-choice").load("../config/select_eng_2.php?choice=" + $("#second-choice").val());  });

the thing works once, first select box second not second third. why this? please help.

the php code first one:

$choice = $_get['choice']; $query = "select distinct category archivo area='$choice' , base = 'engineering'"; $result = mysqli_query($connection, $query); while ($row = mysqli_fetch_array($result)) { echo "<option >" . $row{'category'} . "</option>";

the php code second:

$choice = $_get['choice']; $query = "select distinct platform_type archivo category='$choice'"; $result = mysqli_query($connection, $query); while ($row = mysqli_fetch_array($result)) { echo "<option value='{$row['platform_type']}'>" .  $row{'platform_type'} . "</option>";

}

you need exact copy of second in select_eng.php.

     <select id="second-choice" style="border-radius: 0; width: 100%"        class="form-control" name="category" id="area">            <option value="">-select-</option>            //select option populated db       </select>

and can put second select around span id:

   //use code in main page.   <span id="third-choice">     <select id="second-choice" style="border-radius: 0; width: 100%"         class="form-control" name="category">          <option value="">-select-</option>      </select>  </span>   //in select_eng.php, use                    $choice = $_get['choice'];    $query = "select distinct platform_type archivo               category='$choice'";    $result = mysqli_query($connection, $query);    echo '<select id="second-choice" style="border-radius: 0; width: 100%"         class="form-control" name="category">';    while ($row = mysqli_fetch_array($result)) {       echo '<option value="'.$row['platform_type'].'">'.$row['platform_type'] .'</option>';    }     echo '</select>';

id selector must unique. have 2 ids in select. not needid="area"` @ all. hope may help.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more