PHP / MySQL / JSON encoding help

Question

I am trying to implement the auto-complete script from http://www.devbridge.com/projects/autocomplete/jquery/. It's asking for JSON output like:

{
 query:'Li',
 suggestions:['Liberia','Libyan Arab Jamahiriya','Liechtenstein','Lithuania']
}

I am using PHP/MySQL. My query to get the suggestions would be something like...

<?
$drug = $_GET['drug'];
$query = mysql_query("SELECT * FROM tags_drugs WHERE drug_name LIKE '$drug%'");
    while ($query_row = mysql_fetch_array($query))
        {
            $drug_name = $query_row['drug_name'];
        }

?>

This is where I'm stuck. How do I put the array $drug_name in the suggestions and encode it for json? Thanks in advance!

Bill the Lizard · Accepted Answer · 2011-06-23 23:53:27Z

2

Use

$drug_name[] = $query_row['drug_name'];

instead of $drug_name = $query_row['drug_name'];

Then use

?>
<script type="text/javascript">    
    var drugName = <?php echo json_encode($drug_name);?>
</script>

Use this grugName variable in your JavaScript.

edited Jun 23, 2011 at 23:53

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Feb 11, 2011 at 18:37

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-20 22:45:59Z

0

json_encode($drug_name)

From PHP.net - json_encode

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Feb 11, 2011 at 18:38

barfoon

28.4k29 gold badges97 silver badges140 bronze badges

Collectives™ on Stack Overflow

PHP / MySQL / JSON encoding help

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related