php array in javascript variable for jquery autocomplete

Question

I am using jquery autocomplete and trying to define the values for the auto complete options.

I am trying to create a javascript variable from a php array. So far i have:

<?php
$usernames = get_records_sql("SELECT firstname,lastname FROM {$CFG->prefix}user ORDER BY lastname DESC");    
?>

<script language="javascript">
var names = ['<?php echo $usernames; ?>'];
</script>

I just need to convert the array to this format

var names= ["firstname lastname", "firstname lastname", "firstname lastname"];

Any help would be much appreciated.

Array ( [testing] => stdClass Object ( [lastname] => testing [firstname] => testing ) [test] => stdClass Object ( [lastname] => testing [firstname] => test ) [ab-temp] => stdClass Object ( [lastname] => test [firstname] => ab-temp ) ) — Codded
– Codded, Commented Nov 17, 2011 at 12:45
Can't see how this can be converted directly to JS array - looks like Peter answer has most chances to do what you're after. — user447356
– user447356, Commented Nov 17, 2011 at 12:47

score 2 · Accepted Answer · 2011-11-17 12:37:11Z

2

Use the json_encode() function to encode a PHP array to a JavaScript array.

You can modify the below code to your specifications:

$arr = array();
// depending on the value get_records_sql() returns, you may have to modify
// this loop:
foreach($usernames as $row)
{
    $arr[] = $row['firstname'] . ' ' . $row['lastname'];
}
$output = json_encode($arr);

edited Nov 17, 2011 at 12:37

answered Nov 17, 2011 at 12:31

user142162

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

1 Comment

Peter Over a year ago

he wants "firstname lastname"

Peter · Accepted Answer · 2011-11-17 13:06:22Z

1

var names = [<?php 
    $tmp = Array();
    foreach($usernames as $row) $tmp[] = '"'.$row->firstname.' '.$row->lastname.'"'; 
    echo join(',', $tmp);
?>];

edited Nov 17, 2011 at 13:06

answered Nov 17, 2011 at 12:34

Peter

17k9 gold badges55 silver badges77 bronze badges

3 Comments

Codded Over a year ago

hi peter, thanks for the answer. I cant get it working though. $usernames outputs as - Array ( [testing] => stdClass Object ( [lastname] => testing [firstname] => testing ) [test] => stdClass Object ( [lastname] => testing [firstname] => test ) [ab-temp] => stdClass Object ( [lastname] => test [firstname] => ab-temp ) )

Peter Over a year ago

Ok so your rows are objects (not arrays). So you may use $row->column_name instead $row['column_name']. I updated my answer.

Codded Over a year ago

:) thank you very much, it works like a dream. I should have known that.

David Barker · Accepted Answer · 2011-11-17 12:36:56Z

0

This should work (untested)

foreach ($usernames as $key => $row) {
    $user[] = $row['firstname'].' '.$row['lastname'];
}

echo "<script language=\"javascript\">var names = ['" . implode(',',$user) . "'];</script>";

Cycle through rows, append each name to array $user, implode the array into a string and output.

answered Nov 17, 2011 at 12:36

David Barker

14.6k3 gold badges51 silver badges77 bronze badges

Collectives™ on Stack Overflow

php array in javascript variable for jquery autocomplete

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related