Is there a way to use javascript variable as part of PHP SQL page?

Question

I have a variable within a laravel PHP page, held within Javascript. I currently print / output this as:

${data.id}

I now want to connect to PHPMyAdmin to check to see if the ID is within a table. However, I realise I can't use the ID number in PHP - as this is done on the server side and JS on the client side. A little stuck.

Unfortunately, I'm on a shared hosting package so node.js isn't a solution I can use.

Any help would be great! I think I can use AJAX, but unsure on how this would look.

Use Ajax in jQuery to send an asynchronius call to PHP

Qirel
– Qirel

2019-05-26 13:34:04 +00:00
Commented May 26, 2019 at 13:34 — Qirel
– Qirel, Commented May 26, 2019 at 13:34
Thank you . What would that look like?

nathan
– nathan

2019-05-26 13:37:04 +00:00
Commented May 26, 2019 at 13:37 — nathan
– nathan, Commented May 26, 2019 at 13:37

Arsat · Accepted Answer · 2019-05-26 14:14:49Z

1

here the AJAX sample.

$.ajax({
  method: "POST",
  url: "some.php",
  data: { id: data.id}
})
  .done(function( response) {
    console.log(response);
    //TODO:process your response here if receive response from php file.

  });

answered May 26, 2019 at 14:14

Arsat

262 bronze badges

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

2 Comments

nathan Over a year ago

Thank you. OK. Within 'some.php', how does the variable get passed? $select = 'SELECT *'; $from = ' FROM table '; $where = ' WHERE id = $id ORDER BY $id DESC LIMIT 5';

Никита Гулис Over a year ago

In PHP you can get this value from $_POST and then use it however you like.

Collectives™ on Stack Overflow

Is there a way to use javascript variable as part of PHP SQL page?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related