Run PHP with jQuery and use variable

Question

I'm making a website where you can find manuals of different brands of cars. I have a table with ID, NAME, LINK, and CATEGORY. I want that if you click the DIV with the attribute "ford", you select all from the table where category is ford. This is my code:

jQuery

$('div').click(function(){
    var cat = $(this).attr('category');
});

and the SQL:

$connect = new PDO('mysql:host=localhost;dbname=manuals', 'root','');
$cmd = $connect -> query("SELECT * FROM `manuals` WHERE `category`='ford'");
$resultado = $cmd->fetchAll(PDO::FETCH_ASSOC);

I know that PHP is a server side language and JS not, and JS is event driven, and all the story, but what is the easiest way to achieve this? Do I need to use forms and stuff?

Sorry for bad english!

Steve D · Accepted Answer · 2015-06-10 01:27:47Z

1

Use an $.ajax or $.post call and pass in the variable as a post (or get) variable.

answered Jun 10, 2015 at 1:27

Steve D

3932 silver badges20 bronze badges

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

1 Comment

pedritoalfonso Over a year ago

So, execute the ajax function when clicking the div, right? will try this... thanks

Gary Liu · Accepted Answer · 2015-06-10 01:30:39Z

1

U can use AJAX() to get HTTP communication with PHP in backend. see more in [link]http://api.jquery.com/jQuery.ajax/

answered Jun 10, 2015 at 1:30

Gary Liu

13.9k1 gold badge21 silver badges33 bronze badges

Collectives™ on Stack Overflow

Run PHP with jQuery and use variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related