jQuery $.getJSON() not sending value

Question

The first File is: form.php.

I can't send the values (1 or 2) to my other file.

Can anyone help me out?

$(function () {
    $('#cod_cidades').change(function () {
        if ($(this).val()) {
            $('#s').hide();
            var valor = ($(this).val());
            $('.carregando').show();
            $.getJSON('vara.ajax.php', { cod_cidades: $(this).val(), ajax: 'true' }, function (j) {
                var options = '<option value=""></option>';
                for (var i = 0; i < j.length; i++) {
                    options += '<option value="' + j[i].s + '">' + j[i].nome + '</option>';
                }
                $('#s').html(options).show();
                $('.carregando').hide();
            });
        } else {
            $('#s').html('<option value="">– Escolha um estado –</option>');
        }
    });
});

Varas.ajax.php

This is the part that i get the value.

$id_cidade = mysql_real_escape_string( $_REQUEST['cod_cidades'] );

No errors? Or what? Any request going? Keep your console open and check. — Praveen Kumar Purushothaman, Jan 16 '16 at 21:33
Instead of `$_REQUEST[]` does `$_GET` have the contents? Maybe it's disabled in `php.ini`? — Ohgodwhy, Jan 16 '16 at 21:34
there is this error "unreachable code after statement" on console — Nagib Matni, Jan 16 '16 at 21:44
db connection (and query) is what, `mysql_`? `mysqli_`? PDO? other? could be relevant. — Funk Forty Niner, Jan 16 '16 at 21:48
*"mysqli, I don't thin that this is the problem."* - Err... yes that is a problem, if not **THEE** problem. `mysql_real_escape_string()` does NOT mix with `mysqli_` and `mysql_real_escape_string( $_REQUEST['cod_cidades'] )` will never populate and is probably why your code is failing. — Funk Forty Niner, Jan 16 '16 at 21:53
would you like me to submit that as answer to close this then? seeing I got this one ;-) — Funk Forty Niner, Jan 16 '16 at 22:02
actually, seeing that I was the one to spot the problem, you should be accepting my answer ;-) as posted below. @NagibMatni http://stackoverflow.com/a/34832655/1415724 which is pretty much how Stack rolls ;-) — Funk Forty Niner, Jan 16 '16 at 22:05

score 0 · Answer 1 · answered Jan 16 '16 at 22:02

"mysqli, I don't thin that this is the problem." - Err... yes that is a problem, if not THEE problem. mysql_real_escape_string() does NOT mix with mysqli_ and mysql_real_escape_string( $_REQUEST['cod_cidades'] ) will never populate and is probably why your code is failing. Fred -ii- 7

score 0 · Answer 2 · answered Jan 16 '16 at 22:04

This (and I had a feeling that's what the problem was) "Spidey sense tingling".

mysql_real_escape_string( $_REQUEST['cod_cidades'] )

and you mentioned in comments that you are using mysqli_ to connect with, after my asking you about it.

That MySQL function does not mix with mysqli_.

You need to use its mysqli_ equivalent:

mysqli_real_escape_string($connection, $_REQUEST['cod_cidades'] )

You will need to change the $connection variable to match the one you are using.

jQuery $.getJSON() not sending value

2 Answers2