PHP array to Javascript Array?

homer09001

ok i got a puzzle for you lol.
im trying to modify a Java/AJAX autocomplete Combo Box script to autocomplete an airport ICAO code which i have stored in the database, obviously for the script to suggest an autocomplete option it needs to know the suggestions i know how to get them from the database in PHP but i don't know how to place it into an array that Javascript can read?

the codes echos on a page: http://test.dth-scripts.com/VASystem/icaocodes/index.php
the code behind that page:

<?php

include "../config.php3";
include "../dbconnect.php3";

$a = "SELECT * FROM $table5";
$b = mysql_query($a)or die(mysql_error());
while ($row = mysql_fetch_array($b)){
$icao = $row['icao'];
$An = $row['AirportName'];
echo "$icao - $An,";
}
?>

and the format the javascript array is in:

var customarray=new Array('an apple','alligator','elephant','pear','kingbird','kingbolt', 'kingcraft','kingcup','kingdom','kingfisher','kingpin');

so how the hell do i get the php query to place the results in the above javascript format?

wilku

<?php 

include "../config.php3"; 
include "../dbconnect.php3"; 

$a = "SELECT * FROM $table5"; 
$b = mysql_query($a)or die(mysql_error()); 
$icao = array();
$An = array();
while ($row = mysql_fetch_array($b)){ 
$icao[] = "'".$row['icao']."'"; 
$An[] = "'".$row['AirportName']."'"; 
} 
echo '<script type="text/javascript">'
echo 'var icao=newArray('.join(",",$icao).');';
echo 'var An=newArray('.join(",",$An).');';
echo '</script>';
?>

Hopefully, this will do what you want.

homer09001

wilku wrote:

<?php 

include "../config.php3"; 
include "../dbconnect.php3"; 

$a = "SELECT * FROM $table5"; 
$b = mysql_query($a)or die(mysql_error()); 
$icao = array();
$An = array();
while ($row = mysql_fetch_array($b)){ 
$icao[] = "'".$row['icao']."'"; 
$An[] = "'".$row['AirportName']."'"; 
} 
echo '<script type="text/javascript">'
echo 'var icao=newArray('.join(",",$icao).');';
echo 'var An=newArray('.join(",",$An).');';
echo '</script>';
?>

Hopefully, this will do what you want.

works almost perfectly only change i can't see to make is each value of the array needs to be $icao - $An so they appear like so: EGNT - Newcastle

wilku

Try to change my script according to your needs. This will help you more than reading a ready made script. Parts that need to be changed are:
- combining $icao and $An array into one (you've got concatenation operator "." to connect values from two fields with an additiona " - " string).
- using the combined array in a join.