I would like to find a better way to write this with out using so many if statements. What I need to do is parse the text file grab certain values from the file, and insert those values in a sql database and output it as kml or xml. If anyone can help would be greatly appreciated ..Thank you in advanced
<?php
require_once ("includes/database.php");
// WC/ATWC WMO HEADERS
//Associates Array
$header = array(
'WEPA41 PAAQ',
'WEPA43 PAAQ',
'SEAK71 PAAQ',
'SEUS71 PAAQ ',
'WEAK51 PAAQ ',
'WEAK53 PAAQ ',
'WEXX20 PAAQ ',
'WEXX22 PAAQ ',
'WEXX30 PAAQ ',
'WEXX32 PAAQ ',
'SEXX60 PAAQ ',
'NTXX98 PAAQ ',
//PTWC WMO HEADERS
'WEPA42 PHEB',
'WEHW40 PHEB',
'WEHW42 PHEB',
'SEHW70 PHEB',
'WECA41 PHEB',
'WECA43 PHEB',
'WEIO21 PHEB',
'WEIO23 PHEB',
'NTXX98 PHEB');
//print_r ($header);
//AWIPS ID WC/ATWC
$awips_id1 = "TSUWCA";
$awips_id2 = "TIBWCA";
$awips_id3 = "EQIAKX";
$awips_id4= "EQIWOC";
$awips_id5 = "TSUAK1";
$awips_id6 = "TIBAK1";
$awips_id7 = "TSUAT1";
$awips_id8 = "TIBAT1";
$awips_id9 = "TSUATE";
$awips_id10 = "TIBATE";
$awips_id11 = "EQIAT1";
$awips_id12 = "TS TMSG";
//AWIPS ID PACIFIC
$awips_id13 = "TSUPAC";
$awips_id14 = "TIBAC";
$awips_id15 = "TSHUWX";
$awips_id16 = "TIBHWX";
$awips_id17 = "EQIHWX";
$awips_id18 = "TSUCAX";
$awips_id19 = "TIBCAX";
$awips_id20 = "TSUIOX";
$awips_id21 = "TIBIOX";
// RANDOM VARIABLES
$tbn = "TSUNAMI BULLETIN NUMBER";
$from = "FROM:";
$to = "TO:";
$subject = "SUBJECT";
//
$orginTime = "ORIGIN TIME";
$cord = "COORDINATES";
$depth = "DEPTH";
$loc = "LOCATION";
$mag = "MAGNITUDE";
//
$eva = "EVALUATION";
//
$email = "EMAIL ADDRESS";
$aftn = "AFTN ADDRESS";
$fax = "FAX";
//
$watch = "WATCH";
$warning = "WARNING";
$advisory = "ADVISORY";
$links = "HTTP://";
$head = "/[A-Z]{6}[A-Z]{4}/";
//Paterns
$blnum = "/\d{6}$/"; // output 6 #
$ugc="/^[A-Z]{3}\d{3}/"; //output 3 letters and 3 #
$pat ="/^\d{3}$/";
$found = false;
//for ($header=0; $header<=22; $header++)
//Files
$filename = "ptwc.txt";
//Open the file
$fp = fopen($filename,"rb") or die ("file Cannot be opened");
//Read the file
$data = fread($fp, filesize($filename));
while(!feof($fp))
{
$data .=fgets($fp, 1024);
}
//close the file
fclose($fp);
//Break up the line
$line = explode("\r\n", $data);
//Search the file for a sting that matches and dispplays the line
$i= (0) -1;
switch ($i)
{
case 0:
break;
case 1:
break;
case 2: $i=15;
break;
case 15: $i=124;
break;
}
foreach($line as $line)
{
if(strpos($line, $header[$i]) !== false)
{
echo $line;
}
if(strpos($line, $awips_id1) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id2) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id3 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id4 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id5) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id6 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id7 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id8) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id9 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id10 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id11 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id12 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id13 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id14 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id15 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id16) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id17 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id18 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id19 ) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id20) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $awips_id21) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $orginTime) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $cord) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $loc) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $mag) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $depth) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $eva) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $to) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $subject) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $from) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $tbn) !== false)
{
$found = true;
echo $line."<br>";
}
if(strpos($line, $links) !== false)
{
$found = true;
echo $line . "<br />";
//echo "<a href='$line);'>$line</a>"."<br/>";
}
if (preg_match($ugc, $line)) {
$found = true;
echo $line."<br />";
}
if (preg_match($blnum, $line)){
//echo "Match was found"."<br/>";
echo $line."<br />";
}//else
//echo "Nothing found"."</br/>";
if (preg_match($pat, $line)) {
echo $pat."<br />";
}
mysql_query("INSERT INTO dbtable (wmo_header, prDate)
VALUES ('$line', '$line')");
//end of foreach
}
if(!$found)
{
echo 'No match found';
}
?>
