Combo box and datafile

dips_007

i am reading a data file as followed element 4 and 5 are the county and cities how do i get this data in to 2 combo boxes??

/* open the data file */

$fn = fopen("cites","r");

/* now to read the files record by record */

while($rec = fgets($fn,256))
{

	/* split each record into fields (: is separator) */

	$elem = split(":",$rec);

	if($elem[0] == $town1)
	{
		$g1 = 1;
		$x1 = $elem[4];
		$y1 = $elem[5];
	}
	if($elem[0] == $town2)
	{
		$g2 = 1;
		$x2 = $elem[4];
		$y2 = $elem[5];
	}

sidney

make an array of x2 and y2
when reading info from file

$x2[] = $elem[4];
$y2[] = $elem[5];

then do two loops for each arry

echo"<select name=\"country\" size=\"10\">";
$i=0;

//start loop array X2

echo"<option value=\"$x2[$i]\">$x2[$i}</option>";
$i++;

//end loop
</select>

and repeat another loop with y2

dips_007

still having trouble woth the conbo box
i keep getting a error "Parse error: parse error, expecting `']'' " on the echo"<option value

/ open the data file /

$fn = fopen("/home/staff/acad/jphb/geog/towns/townsx","r");

/ now to read the files record by record /

while($rec = fgets($fn,256))
{

/ split each record into fields (: is separator) /

$elem = split(":",$rec);

$x2[] = $elem[0];

echo"<select name=\"country\" size=\"10\">";
$i=0;

echo"<option value=\"$x2[$i]\">$x2[$i}</option>";
$i++;

</select>
}

sidney

<?php
/* open the data file */ 
$fn = fopen("/home/staff/acad/jphb/geog/towns/townsx","r"); 
/* now to read the files record by record */ 
$i=0;

echo"<select name=\"country\" size=\"10\">"; 

while($rec = fgets($fn,256)) 
{ 
/* split each record into fields (: is separator) */ 
$elem = split(":",$rec); 

$x2[] = $elem[0]; // array created to store select values for future use

echo"<option value=\"$elem[0]\">$elem[0]</option>"; 
$i++; 
} 
?>
</select>

dips_007

Thanks for that.

how do i get the second list in to that
so that one is the county and the other is the city
ibn the file that would be elemnt 1

i would also like to try to get one box to limit the other one itf that is possable. with no repeats

sidney

store all elements in array x2 and use this array to make combo boxes as below

dont know what you mean about one box to limit the other one

 * open the data file */  

$fn = fopen("/home/staff/acad/jphb/geog/towns/townsx","r");  

/* now to read the files record by record */  

echo"<select name=\"country\" size=\"10\">";  

while($rec = fgets($fn,256))  

{
 $elem = split(":",$rec); 
 if(!in_array($x2,$elem)) // if allready in array skip it
 {
/* split each record into fields (: is separator) */  

$x2[] = array($elem[0], $elem[1]);   // array created to store select values for future use 
echo"<option value=\"$elem[0]\">$elem[0]</option>";  

} 
}// second combo box
echo"</select><select name=\"whatever\" size=\"10\">";
foreach($x2 as $key => $array)
{ echo"<option value=\"$array[1]\">$array[1]</option>";   

?> 
 </select>

dips_007

thanks got both combo boxes to appear but there still seems to be duplicates in both boxes.

And what i meant but one box effecting the other was like a fillter eg i pick west midlands for county then the next box should have a list of cites for west midlands. if u know what i mean i think i need javascript for this though

sidney

no you could display the one combo and submit page on change

taking the result from first combo to generate a second with twons whiles still displaying the first

the only javascript would be the on change

as to multiple records repeating them selfs if you showed us the database file i might be able to help more

this one should compile all data into arry and when displaying remove repeated enteries

 /* open the data file */  

$fn = fopen("/home/staff/acad/jphb/geog/towns/townsx","r");  

/* now to read the files record by record */    

while($rec = fgets($fn,256))  

	{
	$elem = split(":",$rec);  

/* split each record into fields (: is separator) */  

	$x2[] = array($elem[0], $elem[1]);   // array created to store select values for future use  

	}// second combo box
echo"<select name=\"country\" size=\"10\">";
$check=array();
foreach($x2 as $key => $array)
	{
	if(!in_array($check,$array[0]))
		{
		$check[]=$array[0];
		echo"<option value=\"$array[0]\">$array[0]</option>";   

		}
	}
echo"</select><select name=\"town\" size=\"10\">";	 
$check=array();
foreach($x2 as $key => $array)
	{
	if(!in_array($check,$array[1]))
		{
		$check[]=$array[1];
		echo"<option value=\"$array[1]\">$array[1]</option>";   

		}
	}
echo"</select>";

dips_007

Bellow is the basic structure of the datafile i think the way the combo boxes come up are not right because its trying to make sure that a whole row is not repeated but not the city or county eg newport is repeated 5 times becuase of each county.
Can list boxes show two columns?? becuase that might help me if i can not get any thing else to work

City County Latitude LongitudeEastingNorthing

NEWLYN CL -19980 -19980 146 28

NEWMALDEN LD -960 -960 520 168

NEWMARKET SF 1440 1440 563 262

NEWMILLS DY -7200 -7200 400 385

NEWMILNS SH -15600 -15600 253 636

NEWMILTON HE -5940 -5940 424 94

NEWNHAM GR -8820 -8820 368 211

NEWPORT EX 780 780 552 234

NEWPORT GW -10800 -10800 330 187

NEWPORT IW -4680 -4680 449 89

NEWPORT PK -17400 -17400 205 239

NEWPORT SE -8519 -8519 375 318

sidney

how many data files do you have for could i see countrys

also it would be better to seperate all fields with a -

NEWLYN-CL-19980-19980-146-28
NEWMALDEN-LD-960-960-520-168

dips_007

Oh sorry there is only one datafile its county and cites
county = the 2 letters after the city

dips_007

and the - sign is not a seprator it is the minus sign for the dimensions the file is split by spaces

sidney

try that it loads one select and then once you pick a country it loads next select with towns that match that country

   <?php error_reporting(E_ALL);
/* open the data file */ 
  $fn= file("test.txt");   

/* now to read the files record by record */     

foreach($fn as $rec)   

    { 
    $elem = explode(" ",$rec);   

/* split each record into fields (: is separator) */   

    $countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]);   // array created to store select values for future use   

    } 
echo"<form name=\"frm\"method=\"post\"><select name=\"country\" onchange=\"document.forms['frm'].submit()\" size=\"10\">"; 
$check=array(); 
foreach($countryarray as $key => $array) 
    { 
    if(!in_array($array[1],$check)) 
        { 
        $check[]=$array[1]; 
        echo"<option value=\"$array[1]\">$array[1]</option>";    

        } 
    } 
echo"</select>";
if(isset($_POST['country'])) 
	{
	$countryid=$_POST['country'];
	echo"<select name=\"town\" size=\"10\">"; 
	foreach($countryarray as $key => $carray) 
    	{ echo $countryid."-".$carray[1];
    	if($countryid==$carray[1]) 
        	{ 
        	echo"<option value=\"$carray[0]\">$carray[0]</option>";    

        	} 
    	} 
	}
 ?></select> </form>

dips_007

does not work i get lots of warnings for each element

Warning: Undefined offset: 1 in /home/stud/1/c0083433/public_html/RoutePlanner/RoutePlanner.php on line 48

<?php error_reporting(E_ALL);
/ open the data file /

$fn = file("/home/staff/acad/jphb/geog/towns/townsx","r");

/ now to read the files record by record /

foreach($fn as $rec)

{

$elem = explode(" ",$rec);

/ split each record into fields (: is separator) /

$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]);

}

echo"<form name=\"frm\"method=\"post\"><select name=\"country\" onchange=\"document.forms['frm'].submit()\" size=\"10\">";

$check=array();

foreach($countryarray as $key => $array)

{

if(!in_array($array[1],$check))

{

$check[]=$array[1];

echo"<option value=\"$array[1]\">$array[1]</option>";

}

}

echo"</select>";
if(isset($POST['country']))

{
$countryid=$POST['country'];
echo"<select name=\"town\" size=\"10\">";

foreach($countryarray as $key => $carray)

{ echo $countryid."-".$carray[1];
if($countryid==$carray[1])

{

echo"<option value=\"$carray[0]\">$carray[0]</option>";

}

}

}
?>
</select>
</form>

sidney

stange i get no errors and there isnt 48 lines of code there

leads me to think problem is else where

dips_007

thi is the code i have it is a table with ur code and extra input boxes

error is on line 26 "$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]); "

I think

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Route Planner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php error_reporting(E_ALL);
/ open the data file /
$fn = file("/home/staff/acad/jphb/geog/towns/townsx","r");
/ now to read the files record by record /
foreach($fn as $rec)
{
$elem = explode(" ",$rec);
/ split each record into fields (: is separator) /
$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]);
}
echo"<form name=\"frm\"method=\"post\"><select name=\"country\" onchange=\"document.forms['frm'].submit()\" size=\"10\">";
$check=array();
foreach($countryarray as $key => $array)
{
if(!in_array($array[1],$check))
{
$check[]=$array[1];
echo"<option value=\"$array[1]\">$array[1]</option>";
}
}
echo"</select>";
if(isset($POST['country']))
{
$countryid=$POST['country'];
echo"<select name=\"town\" size=\"10\">";
foreach($countryarray as $key => $carray)
{ echo $countryid."-".$carray[1];
if($countryid==$carray[1])
{
echo"<option value=\"$carray[0]\">$carray[0]</option>";
}
}
}
?>
</select>

    </td>
</tr>
<tr> 
  <td>Town 2 </td>
  <td><input name="town2" type="text" id="town22"></td>
</tr>
<tr> 
  <td>Town 3 </td>
  <td><input name="town3" type="text" id="town32"></td>
</tr>
<tr> 
  <td>Start time </td>
  <td><input name="StartTime" type="text" id="StartTime2"></td>
</tr>
<tr> 
  <td>Stop duration </td>
  <td><input name="StopDuration" type="text" id="StopDuration2"></td>
</tr>
<tr> 
  <td>Speed (mph)</td>
  <td><input name="Speed" type="text" id="Speed2"></td>
</tr>
<tr> 
  <td><input name="submit" type=submit></td>
  <td>&nbsp;</td>
  <td width="32%">&nbsp;</td>
  <td width="35%">&nbsp;</td>
</tr>

</table>
</div>
</form>
<hr>
<pre>
Number of visitors: 
Last Review Date: 
</pre>
<hr>
</body>
</html>

sidney

still no probs my end runs fine no errors all i changed is the txt file

$fn = file("/home/staff/acad/jphb/geog/towns/townsx","r");

to the one on my server to test

error is on line 26 "$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]); "

these element are from $fn so problem proberly the file is not being split or reading lines properly

dips_007

Sorry that was a problem on my beharf sorted that problem out.
It shows the first box but when i slect a option a errormessage comes up.

error:' document.forms.from1' is null or not an object

<?php error_reporting(E_ALL);
/ open the data file /
$fn = file("townsx","r");
/ now to read the files record by record /
foreach($fn as $rec)
{
$elem = explode(":",$rec);
/ split each record into fields (: is separator) /
$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]);
}
echo"<form name=\"from1\"method=\"post\"><select name=\"country\" onchange=\"document.forms['from1'].submit()\" size=\"10\">";
$check=array();
foreach($countryarray as $key => $array)
{
if(!in_array($array[1],$check))
{
$check[]=$array[1];
echo"<option value=\"$array[1]\">$array[1]</option>";
}
}
echo"</select>";
if(isset($POST['country']))
{
$countryid=$POST['country'];
echo"<select name=\"town\" size=\"10\">";
foreach($countryarray as $key => $carray)
{ echo $countryid."-".$carray[1];
if($countryid==$carray[1])
{
echo"<option value=\"$carray[0]\">$carray[0]</option>";
}
}
}
?>
</select>

sidney

you have two form tags need to keep first one and remove second and change submit button name to anthing but submit

as below

 <form name="form1" method="post" action="RoutePlanner2.php"> 

<table width="98%" border="0"> 
<tr> 
<td width="13%">Town 1 </td> 
<td width="20%"><input name="town1" type="text" id="town1"></td> 
<td colspan="2" rowspan="6"> 

<?php error_reporting(E_ALL); 
/* open the data file */ 
$fn = file("townsx","r"); 
/* now to read the files record by record */ 
foreach($fn as $rec) 
{ 
$elem = explode(":",$rec); 
/* split each record into fields (: is separator) */ 
$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]); 
} 
echo"<select name=\"country\" onchange=\"document.forms['form1'].submit()\" size=\"10\">"; 
$check=array(); 
foreach($countryarray as $key => $array) 
{ 
if(!in_array($array[1],$check)) 
{ 
$check[]=$array[1]; 
echo"<option value=\"$array[1]\">$array[1]</option>"; 
} 
} 
echo"</select>"; 
if(isset($_POST['country'])) 
{ 
$countryid=$_POST['country']; 
echo"<select name=\"town\" size=\"10\">"; 
foreach($countryarray as $key => $carray) 
{ echo $countryid."-".$carray[1]; 
if($countryid==$carray[1]) 
{ 
echo"<option value=\"$carray[0]\">$carray[0]</option>"; 
} 
} 
} 
?> 
</select>

dips_007

error : object dosn't support property or method

the form is called form1 which is for te whole table

<html>
<head>
<title>Route Planner</title>
</head>

<?php error_reporting(E_ALL);

/ open the data file /

$fn = file("townsx","r");

/ now to read the files record by record /

foreach($fn as $rec)

{

$elem = explode(":",$rec);

/ split each record into fields (: is separator) /

$countryarray[] = array($elem[0], $elem[1], $elem[2], $elem[3], $elem[4], $elem[5]);

}

echo"<select name=\"country\" onchange=\"document.forms['form1'].submit()\" size=\"10\">";

$check=array();

foreach($countryarray as $key => $array)

{

if(!in_array($array[1],$check))

{

$check[]=$array[1];

echo"<option value=\"$array[1]\">$array[1]</option>";

}

}

echo"</select>";

if(isset($POST['country']))

{

$countryid=$POST['country'];

echo"<select name=\"town\" size=\"10\">";

foreach($countryarray as $key => $carray)

{ echo $countryid."-".$carray[1];

if($countryid==$carray[1])

{

echo"<option value=\"$carray[0]\">$carray[0]</option>";

}

}

}

?>

</select>

    </td>
</tr>
<tr> 
  <td>Town 2 </td>
  <td><input name="town2" type="text" id="town22"></td>
</tr>
<tr> 
  <td>Town 3 </td>
  <td><input name="town3" type="text" id="town32"></td>
</tr>
<tr> 
  <td>Start time </td>
  <td><input name="StartTime" type="text" id="StartTime2"></td>
</tr>
<tr> 
  <td>Stop duration </td>
  <td><input name="StopDuration" type="text" id="StopDuration2"></td>
</tr>
<tr> 
  <td>Speed (mph)</td>
  <td><input name="Speed" type="text" id="Speed2"></td>
</tr>
<tr> 
  <td><input name="submit" type=submit></td>
  <td>&nbsp;</td>
  <td width="32%">&nbsp;</td>
  <td width="35%">&nbsp;</td>
</tr>

</table>
</div>
</form>

</body>
</html>