jQuery to execute PHP MySQL query

Question

Here's what I've got. I'm trying to have jquery run a mysql query.

This is my PHP:

<select name="kingdom" id="kingdom" >
    <option value="standard">-- Kingdom --</option>
        <?php
            $the_d = $_POST['d'];
            $filter = mysql_query("SELECT DISTINCT sci_kingdom FROM tbl_lifedata WHERE sci_domain = '$the_d'");
                while($row = mysql_fetch_array($filter, MYSQL_NUM))
                    {
                        $row['name'];
                        //echo "<option value='$row[0]'>$row[0]</option>";
                    }
        ?>
</select>

And my jQuery:

$('#domain').change(function () {

    var selectval = $('#domain').val();

    $.post("search.php", {
        d: selectval
    }, function (data) {
        $('.result').html(data);
    });
});

Right now I would just like to have jQuery spit out the values of the mysql result. When I have that working, I can have them populate a select box. What I get now is the html of search.php but nothing to do with the mysql query.

Note that your code has a SQL injection vulnerability on line 5. — thomasrutter
– thomasrutter, Commented Jun 21, 2012 at 1:35
You are not outputting the values from the query. You merely have $row['name'] in the fetch loop. You're using numeric keys in the fetch, so $row['name'] wouldn't be set anyway. — Michael Berkowski
– Michael Berkowski, Commented Jun 21, 2012 at 1:35

Eswar Rajesh Pinapala · Accepted Answer · 2012-06-21 03:31:30Z

2

You should actually print what you are retrieving from the DB.

<select name="kingdom" id="kingdom" >
                <option value="standard">-- Kingdom --</option>
                <?php 
                $the_d = mysql_real_escape_string($_POST['d']);//thanks to @Mansfield
                $filter = mysql_query("SELECT DISTINCT sci_kingdom FROM tbl_lifedata WHERE sci_domain = '".$the_d."'");
                while($row = mysql_fetch_array($filter, MYSQL_NUM))
                {
                    echo "<option value='$row[0]'>$row[0]</option>";

                }

                ?>
            </select>


 //or you can also use mysql_fetch_array($filter, MYSQL_ASSOC) if you want to print $row['name']

Updated answer:

<script src="jquery.min.js"></script>
<input type='text' class="domain" id="domain"/>
<div class="result" id="result"></div>
<script>
$('#domain').change(function() {

            var selectval = $('#domain').val();

            $.post(
                "test.php", 
                { d : selectval },
                function(data) {
                    $('.result').html(data);//my bad should be displaying data retrenched
                }
                );
});
</script>

///test.php contents:

<?php
print $the_d = mysql_real_escape_string($_POST['d']);// see if the scripts are working fine until here, if so, then see below.
//test your mysql result by doing a print_r($row.)    
?>

post the result of print_r($row);

edited Jun 21, 2012 at 3:31

answered Jun 21, 2012 at 1:36

Eswar Rajesh Pinapala

4,9314 gold badges35 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

chrsgrffth Over a year ago

Thank you for reminding me about the real escape string! What do I need to do to my jQuery to get it to populate? Right now, after these changes, it still isn't working.

chrsgrffth Over a year ago

Yes! It comes up with the value of the select onchange. What can I do from here??

chrsgrffth Over a year ago

How would I do that? How can I get the results from the query and use them to populate the select box?

chrsgrffth Over a year ago

Hmm..the only thing that is happening is the $('.result').html(selectval) is appearing, nothing from the mysql query appears

Eswar Rajesh Pinapala Over a year ago

My bad, I was testing this and I left the selectval like that, it should update the result div with data but not selectval

|

Collectives™ on Stack Overflow

jQuery to execute PHP MySQL query

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related