using jquery to load data from mysql database

Question

I'm currently using jquery's ajax feature or whatever they call it. To load data from mysql database. Its working fine, but one of the built in features of this one is to load all the data which is on the database when you press on backspace and there's no character left on the text box.

Here's my query:

SELECT * FROM prod_table WHERE QTYHAND>0 AND PRODUCT LIKE '$prod%' OR P_DESC LIKE '$desc%' OR CATEGORY LIKE '$cat%'

As you can see I only want to load the products which has greater than 0 quantity on hand.

I'm using this code to communicate to the php file which has the query on it:

$('#inp').keyup(function(){


                var inpval=$('#inp').val();

            $.ajax({
                type: 'POST',
                data: ({p : inpval}),
          url: 'querys.php',
          success: function(data) {
            $('.result').html(data);

          }





        });

    });

Is it possible to also filter the data that it outputs so that when I press on backspace and there's no character left. The only products that's going to display are those with greater than 0 quantity?

can you make alert(data) in success block?

Alex Pliutau
– Alex Pliutau

2011-01-13 14:50:36 +00:00
Commented Jan 13, 2011 at 14:50 — Alex Pliutau
– Alex Pliutau, Commented Jan 13, 2011 at 14:50

Felix Kling · Accepted Answer · 2011-01-13 14:58:08Z

2

I think all you have to do is to change your query to:

SELECT * 
FROM prod_table 
WHERE QTYHAND>0 
AND (
    PRODUCT LIKE '$prod%' 
    OR P_DESC LIKE '$desc%' 
    OR CATEGORY LIKE '$cat%'
)

Not 100% sure if it is the same in SQL, but most often, AND has precedence over OR. So your original query would read like:

WHERE (... AND ...) OR ... OR ...

Now, if you have an empty string, then "something LIKE '%'" will always match and only one OR has to match to include the record in the result set.

edited Jan 13, 2011 at 14:58

answered Jan 13, 2011 at 14:51

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

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

Collectives™ on Stack Overflow

using jquery to load data from mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related