Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- campo select puxando do banco valores
- //php
- <?php
- require_once '../conexao.php';
- $PAISES_AMERICA_LATINA = array(1,2,3,4,5,6,7,8,9);
- $ID_PAIS = $_REQUEST['id_pais'];
- $par = $_REQUEST['par'];
- if (!in_array($ID_PAIS, $PAISES_AMERICA_LATINA)) {
- if ($par == 'N') {
- $sqlExtra .= " sql";
- } else {
- $sqlExtra .= " sql ";
- }
- } else {
- $sqlExtra .= " sql";
- }
- $categorias = array();
- $model = new Model();
- $sql = "SELECT id, nome FROM CATEGORIAS";
- $categorias_db = $model->Select($sql);
- if (count($categorias_db) > 0) {
- foreach ($categorias_db as $cat) {
- $categorias[] = array(
- 'cod_categorias' => $cat->id,
- 'nome' => $cat->nome,
- );
- }
- }
- echo json_encode($categorias);
- ?>
- js
- function loadCombo(selobj, url)
- {
- jQuery(selobj).empty();
- jQuery.getJSON(url, function(data)
- {
- var options = '<option value="0"> escolha </option>';
- jQuery.each(data, function(key, value) {
- var cod = value['cod_categorias'];
- var nome = value['nome'];
- options += '<option value="' + cod + '">' + nome + '</option>';
- }
- );
- jQuery(selobj).html(options);
- });
- }
- jQuery(function() {
- jQuery("#ID_PAI").change(function() {
- var PAISES_AMERICA_LATINA = [1,2,3,4,5,6,7,8,9];
- if (jQuery.inArray(parseInt(jQuery("#ID_PAI").val()), PAISES_AMERICA_LATINA) != -1) {
- var params = "&id_pais=" + jQuery(this).val() + "&par=N";
- loadCombo(jQuery("#comboid").get(0), '../ajax/loadCombo.php?b=1' + params);
- }else{
- var params = "&id_pais=" + jQuery(this).val() + "&par=S";
- loadCombo(jQuery("#comboid").get(0), '../loadCombo.php?b=1' + params);
- }
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement