Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. <select name="categories[]" id="example-getting-started"
  2. multiple="multiple" class="form-control">
  3. <?php
  4. $query = $mysqli->query("SELECT usuario_id, secao_id_cat FROM secao_usuarios WHERE usuario_id='$u[id]'");
  5. $dados = $query->fetch_assoc();
  6. $categories = explode(",",$dados['secao_id_cat']);
  7. //print_r($categories);
  8.  
  9. function isSelected($val, $arr){
  10. if(in_array($val, $arr)){
  11. echo ' selected';
  12. }
  13. }
  14. $sql = "SELECT sid, id_tipo_anun, secao_nome, amigavel, icone, tipo, secao_prod, status FROM secao WHERE tipo='cat' AND id_tipo_anun='3' AND secao_prod='sim' AND status='sim' AND destacar='sim' ORDER BY posicao ASC";
  15. $result = $mysqli->query($sql);
  16. while ($row = $result->fetch_assoc()) {
  17. echo "<option value=\"$row[sid]\""; isSelected('$row[sid]', $categories); echo ">$row[secao_nome]</option>";
  18. }
  19. ?>
  20. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement