[RESOLVED] PHP array to Javascript array undefined

[Dranve]

Hello all,

my problem is getting the value from PHP array I get from MySQL query into the Javascript array, which says it is UNDEFINED.

If I use this code, everything is ok:

<?php
$n = array('test','test2','test3');
print_r($n);
echo '<br>';
 echo '<script type="text/javascript">';
 echo 'var List = new Array("', join($n,'","'), '");';
 echo '</script>';
?>

<script type="text/javascript" language="javascript"> 
document.write(List);
</script>

Output is:

PHP: Array ( [0] => test [1] => test2 [2] => test3 )
Javascript: test,test2,test3

The problem is with the array I get from Database:

<?php
$con = mysql_connect('databse', 'user', 'password');
mysql_select_db("database_name", $con);
$query="Select field from table";
$result=mysql_query($query,$con);
$rows=mysql_num_rows($result);
$n = array();
for($i=0;$i<$rows;$i++)
{
$data=mysql_fetch_row($result);
$n[] = $data[0];
}
print_r($n);
echo '<br>';
echo '<script type="text/javascript">';
echo 'var List = new array("', join($n,'","'), '");';
echo '</script>';
?> 

<script type="text/javascript" language="javascript"> 
document.write(List);
</script>

Output is:

PHP: Array ( [0] => test [1] => test2 [2] => test3 )
Javascript: undefined


I'm a bit confused why is that, so help would be much appreciated.
Thnx.

[lordspace]

I'd use this function

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

Example #1 A json_encode() example
<?php
$arr = array ('a'=>1,'b'=>2,'c'=>3,'d'=>4,'e'=>5);

echo json_encode($arr);
?>

The above example will output:

{"a":1,"b":2,"c":3,"d":4,"e":5}

[Dranve]

Thnx for the reply, but the server I'm working on is on PHP 5.0 which doesn't support json function and I cannot change that (not my server, hosting).

[lordspace]

have you seen this link: http://gggeek.altervista.org/sw/article_20061113.html

[Kor]

Thnx for the reply, but the server I'm working on is on PHP 5.0 which doesn't support json function.

Who said so? Anyway, here's some alternatives, in case the json functions were not implemented in a certain version of PHP:
http://tinsology.net/2011/04/php-jso...-alternatives/
See also the comment below!

[Dranve]

Thank you very much for your answers, but I've found a quick and easy solution.

    <script>
    var list=[];
    <?php
      $db=mysql_connect('dbhost','username','password') or die('Error connecting to the server');
      mysql_select_db('mydatabase') or die('Error selecting database');
      $result=mysql_query('SELECT * FROM mytable') or die ('Error performing query');
      while($row=mysql_fetch_array($result, MYSQL_ASSOC)){
    ?>
    list[list.length]=<?php echo '"'.$row['name'].'"'?>;
    <?php
      }
    ?>
    </script>

I've got it from this site: http://www.devshed.com/c/a/PHP/PHP-a...ient-part-1/1/

Now there is the problem of UTF-8 encoding 'cause my text is in Croatian and some symbols aren't showing properly. So, if someone knows the solution, that would be great. Thnx.

[Dranve]

I'm getting better. Just put

 mysql_query("SET NAMES 'utf8'"); 

under mysql_connect.

Once more, thnx for all your help.