Pass a database value to JavaScript

Question

I retrieved all of my friends' names which are currently online using MySQL joins and PHP.

Now I want to insert their names inside JavaScript for chatting with them.

<a href="javascript:void(0)" onclick="javascript:chatWith('Friend1')">Friend1 </a>
<a href="javascript:void(0)" onclick="javascript:chatWith('Friend2')">Friend2 </a>

I am unable to do this. Because I don't know how to call JavaScript inside PHP or viceversa.

while($get_usernames=mysql_fetch_array($get_users_query)) {             
    echo '<br>'.$get_usernames['username'];                         
}

I want to show each of $get_usernames['username'] as Friend1, Friend2, inside JavaScript

you are trying to access database that is on server from javascript that run on client side?? you need to call ajax that will fetch data from db and return result. — Bojan Kovacevic
– Bojan Kovacevic, Commented Mar 22, 2013 at 14:08

Hari krishnan · Accepted Answer · 2013-03-22 14:07:01Z

2

You can use AJAX to call a php page and get value from that.

Call the php page and after querying simply return value using echo. You can get that value using responseText in javascript

http://www.tizag.com/ajaxTutorial/ajaxphp.php

answered Mar 22, 2013 at 14:07

Hari krishnan

2,1164 gold badges20 silver badges28 bronze badges

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

2 Comments

Bojan Kovacevic Over a year ago

if he dont mind, probably using jQuery for ajax would be much easier to learn.

Hari krishnan Over a year ago

@BojanKovacevic yes jquery is awesome simple and easier

Blunderfest · Accepted Answer · 2013-03-22 14:12:20Z

1

If you want to place some PHP variable inside javascript, a simple way of doing it is by simply using the php loop inside your page to create the a tags.

Something like this:

$aTagList = "";
while($get_usernames=mysql_fetch_array($get_users_query)) {             
    $aTagList .= "<a href='javascript:void(0)' onclick='javascript:chatWith(\"".$get_usernames['username']."\")>".$get_usernames['username']."</a>";                         
}

Then echo the $aTagList wherever you need it in the page with some inline code.

<?php echo $aTagList; ?>

Not sure if I got all the escaping correct, but it should give you the right idea.

answered Mar 22, 2013 at 14:12

Blunderfest

1,8542 gold badges28 silver badges47 bronze badges

2 Comments

Mithun Sudheendran Over a year ago

i can't echo $aTagList, it causing some side of page missing

Blunderfest Over a year ago

What exactly is it causing? Is the php page that you are executing the query on the same that you are printing the a tags?

chrisblomm · Accepted Answer · 2013-03-22 15:31:41Z

0

Something like:

<?php
$aUsernames = array();
while($get_usernames=mysql_fetch_array($get_users_query)) {             
    array_push($aUsernames, $get_usernames['username']);                         
}
foreach($aUsernames as $name) {
?>
<a href="javascript:void(0)" onclick="javascript:chatWith('<?php echo $name; ?>')"><?= $name; ?> </a>
<?php
}
?>

Using AJAX is much neater ofcourse, but this will suffice if it is all in one PHP file.

Also I would like to encourage you to move to PDO or Mysqli since mysql functions are deprecated.

edited Mar 22, 2013 at 15:31

answered Mar 22, 2013 at 14:13

chrisblomm

3141 silver badge8 bronze badges

1 Comment

Mithun Sudheendran Over a year ago

chrisblomm still some errors there, the javascript causing the error... could you please rectify this, and post again..thanks in advance

Collectives™ on Stack Overflow

Pass a database value to JavaScript

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related