Generate Javascript Array from Mysql select

Question

I wonder if anyone can help - I want to select a table and create Javascript a array with the return values. Here's what I have so far:

con = mysql_connect("localhost","usrname","password");

if (!$con) {
    die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);
$ql = "SELECT theMessage FROM email_message";
$result = mysql_query($ql) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
    $allMessage = $row['theMessage'] . " ";
}

$arr = array($allMessages);
$script = '<script>var newArr = new Array(' . implode(' ', $arr) . ');</script>';
echo $script;

But instead, it just shows me empty array like this: var newArr = new Array();

EGOrecords · Accepted Answer · 2012-02-02 15:51:30Z

3

Change the line

$allMessage = $row['theMessage'] . " ";

to

$allMessages[] = $row['theMessage'] . " ";

(adding a s to the variable name, and adding the []) because you are overwriting your result every time you read a new line, and afterwards read from a different (empty) variable!

Now you should implode the array not with spaces, you should implode it with ", " or with "', '", depending on what data is stored.

You could also put the output directly into the fetch-loop, but thats just an idea for you.

What you really should consider about is reading the json_encode() and json_decode():

http://www.php.net/manual/en/function.json-encode.php

http://www.php.net/manual/en/function.json-decode.php

Hope i could help.

answered Feb 2, 2012 at 15:51

EGOrecords

1,9792 gold badges20 silver badges33 bronze badges

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

Comments

Ethan · Accepted Answer · 2013-09-05 15:08:09Z

0

have you considered using json_encode()?

I would use a mysql_fetch_assoc, then in my 'while' loop, push each item into a php array, then use the built in json_encode function to create a javascript object which you can easily use.

EDIT: Do NOT use mysql_ functions. There are similar functions in PDO and MySQLi to achieve the same goal. Use those.

edited Sep 5, 2013 at 15:08

answered Feb 2, 2012 at 15:34

Ethan

2,7942 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

Generate Javascript Array from Mysql select

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