Advertisement
gilcierweb

campo select puxando do banco valores

Oct 24th, 2013
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
jQuery 1.80 KB | None | 0 0
  1. campo select puxando do banco valores
  2. //php
  3.  
  4. <?php
  5.  
  6. require_once '../conexao.php';
  7.  
  8. $PAISES_AMERICA_LATINA = array(1,2,3,4,5,6,7,8,9);
  9.  
  10. $ID_PAIS = $_REQUEST['id_pais'];
  11. $par = $_REQUEST['par'];
  12. if (!in_array($ID_PAIS, $PAISES_AMERICA_LATINA)) {
  13.    
  14.     if ($par == 'N') {
  15.         $sqlExtra .= " sql";
  16.     } else {
  17.         $sqlExtra .= " sql ";
  18.     }
  19.    
  20. } else {
  21.     $sqlExtra .= " sql";
  22. }
  23.  
  24. $categorias = array();
  25. $model = new Model();
  26.  
  27. $sql = "SELECT  id, nome FROM CATEGORIAS";
  28.  
  29. $categorias_db = $model->Select($sql);
  30.  
  31. if (count($categorias_db) > 0) {
  32.     foreach ($categorias_db as $cat) {
  33.         $categorias[] = array(
  34.             'cod_categorias' => $cat->id,
  35.             'nome' => $cat->nome,
  36.         );
  37.     }
  38. }
  39.  
  40. echo json_encode($categorias);
  41. ?>
  42.  
  43. js
  44. function loadCombo(selobj, url)
  45. {
  46.     jQuery(selobj).empty();
  47.     jQuery.getJSON(url, function(data)
  48.     {
  49.         var options = '<option value="0"> escolha </option>';
  50.         jQuery.each(data, function(key, value) {
  51.             var cod = value['cod_categorias'];
  52.             var nome = value['nome'];
  53.             options += '<option value="' + cod + '">' + nome + '</option>';
  54.         }
  55.         );
  56.         jQuery(selobj).html(options);
  57.     });
  58. }
  59.  
  60. jQuery(function() {
  61.     jQuery("#ID_PAI").change(function() {
  62.  
  63.         var PAISES_AMERICA_LATINA = [1,2,3,4,5,6,7,8,9];
  64.  
  65.         if (jQuery.inArray(parseInt(jQuery("#ID_PAI").val()), PAISES_AMERICA_LATINA) != -1) {
  66.             var params = "&id_pais=" + jQuery(this).val() + "&par=N";
  67.             loadCombo(jQuery("#comboid").get(0), '../ajax/loadCombo.php?b=1' + params);
  68.         }else{
  69.             var params = "&id_pais=" + jQuery(this).val() + "&par=S";
  70.             loadCombo(jQuery("#comboid").get(0), '../loadCombo.php?b=1' + params);
  71.         }
  72.  
  73.     });
  74. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement