Variable From PHP to Javascript

Question

I have this code in html:

<a id="<?echo $result[id]?>" onclick="displayResult()"></a>

And i want to get this id number from link without refresh the page to this function:

<script>
function displayResult()
{ 
<?
connection = mysql_connect('localhost', 'root', '...');
$db = mysql_select_db('webfaturas', $connection);
$sql = mysql_query("SELECT * FROM `artigos` WHERE id = $id");
$resultado = mysql_fetch_array($sql); 
?> 
</script>

So i can do sql query WHERE id = id that cames from without refresh the page.

What you have done will just get the values during the page load and wont change at all during execution, you need Ajax to do what you want to do — skv
– skv, Commented Aug 7, 2013 at 17:03
Doesn't this code introduce a security risk with SQL injection? — Christopher Marshall
– Christopher Marshall, Commented Aug 7, 2013 at 17:04

JRizz · Accepted Answer · 2013-08-07 17:08:49Z

1

What you'll want to do is grab the ID of the link via javascript, and POST it to your php script using AJAX. jQuery makes this easier than using just straight javascript - I suggest reading the documentation. http://api.jquery.com/jQuery.post/

answered Aug 7, 2013 at 17:08

JRizz

2263 silver badges12 bronze badges

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

Comments

bosspj · Accepted Answer · 2013-08-07 17:10:37Z

0

Like the comments have said using ajax to get what you need is the best way to go about doing it.

Wikipdia says: http://en.wikipedia.org/wiki/Ajax_(programming) tl;dr

Basically you make a call to another page using javascript and any data you collected. It will then return some sort of data structure (usually JSON or XML)

Then render the results.

Thats the simple way to do it.

(I know the internets will hate me for this) jQuery has a function just for it called ajax

answered Aug 7, 2013 at 17:10

bosspj

806 bronze badges

Comments

Robbie JW · Accepted Answer · 2013-08-07 17:18:21Z

0

Like other people have said, AJAX is the best way to go about this.

jQuery provides the easiest way to do this.

Send the ID to a PHP page using jQuery's $.ajax function, get the data using either $_GET["id"] or $_POST["id"], depending on how you sent the AJAX, do your SQL query and then send a response back to the browser (as if it were a normal web page, using echo).

answered Aug 7, 2013 at 17:18

Robbie JW

7391 gold badge9 silver badges22 bronze badges

Collectives™ on Stack Overflow

Variable From PHP to Javascript

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related