Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 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. {
  11. if (in_array($val, $arr)) {
  12. echo ' selected';
  13. }
  14. }
  15.  
  16. $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";
  17. $result = $mysqli->query($sql);
  18. while ($row = $result->fetch_assoc()) {
  19. echo "<option value=\"$row[sid]\"";
  20. isSelected('$row[sid]', $categories);
  21. echo ">$row[secao_nome]</option>";
  22. }
  23. ?>
  24. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement