javascript - Removing one option from select dropdown generated by jquery -


i working on basic administrator functionality of social network , came across issue of not being able remove option select dropdown list generated using jquery. dropdown list contains users of social network. administrator upon clicking on "delete account" deletes corresponding record database.

now question being - when click on "delete account" works fine option username still there in dropdown list , possible picked - when picked returns dozens of php warnings , errors because record not in database anymore. how can remove option straight away? tried following, doesn't work.

admin_panel.php (only relevant stuff)

<select name='users' id='users'>         <option value="" disabled selected>select user</option>         <?php             $sql = mysql_query("select * users id <>'".$_session['user_id']."'order username desc") or die(mysql_error());                 $userlist = [];                 while($row=mysql_fetch_assoc($sql)){                     $username = $row['username'];                     $userid = $row['id'];                     $userlist .= '<option name="userid" value='.$userid.'>'.$username.'</option>';                 }             echo $userlist;         ?>     </select></br></br></div>     <div id="user_info">         <!-- generated user info table-->     </div>  <script type="text/javascript">  "$('#user_info').on('click', '#deleteaccount', function(e){     data.command = 'deleteaccount'     data.userid = $('#users').val()     $.post(theurl, data, function(result){         //do want response.         $('#delete_account_success').html(result);     })     $("#users option[value='data.userid']").remove();     $('#delete_account_success').show();     $('#delete_account_success').fadeout(5000); }) </script>

processuser.php (part of switch statement)

if(isset($_post['command'])){     $cmd = $_post['command'];     $userid = $_post['userid'];   $sql=mysql_query("select * users id='".$userid."'"); $userdata = []; while($row = mysql_fetch_assoc($sql)){     $userdata['userid'] = $row['id'];     $userdata['username'] = $row['username'];     $userdata['name'] = $row['name'];     $userdata['date'] = $row['date'];     $userdata['email'] = $row['email'];     $userdata['avatar'] = $row['avatar'];     $userdata['about'] = $row['about'];     $userdata['admin'] = $row['admin']; }  switch($cmd){  case 'deleteaccount':         $sql= "delete users id =".$userid;         $result=mysql_query($sql);         echo "<img src='pics/ok.png' class='admin_updated_ok'>";     break; }

on line

$("#users option[value='data.userid']").remove();

you're removing option items #users value equal string literal data.userid

try changing to

$("#users option[value='" + data.userid + "']").remove();

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more