/**
* ????????????????CSV??????????
* @param resource handle
* @param int length
* @param string delimiter
* @param string enclosure
* @return ??????????????????????FALSE??????
*/
function fgetcsv_reg (&$handle, $length = null, $d = ',', $e = '"') {
$d = preg_quote($d);
$e = preg_quote($e);
$_line = "";
while ($eof != true) {
$_line .= (empty($length) ? fgets($handle) : fgets($handle, $length));
$itemcnt = preg_match_all('/'.$e.'/', $_line, $dummy);
if ($itemcnt % 2 == 0) $eof = true;
}
$_csv_line = preg_replace('/(?:\r\n|[\r\n])?$/', $d, trim($_line));
$_csv_pattern = '/('.$e.'[^'.$e.']*(?:'.$e.$e.'[^'.$e.']*)*'.$e.'|[^'.$d.']*)'.$d.'/';
preg_match_all($_csv_pattern, $_csv_line, $_csv_matches);
$_csv_data = $_csv_matches[1];
for($_csv_i=0;$_csv_i<count($_csv_data);$_csv_i++){
$_csv_data[$_csv_i]=preg_replace('/^'.$e.'(.*)'.$e.'$/s','$1',$_csv_data[$_csv_i]);
$_csv_data[$_csv_i]=str_replace($e.$e, $e, $_csv_data[$_csv_i]);
}
return empty($_line) ? false : $_csv_data;
}

?>

<?php
//????????????????csv????????????function??
function showAllData($fname){
$file = @fopen($fname,'r') or exit('????????????');
echo "<table class=\"box\">\n<tr>\n";
$data=fgetcsv_reg($file);//???????????


$n = count($data);//????????????????
for($i=0; $i<$n; $i++){
echo "<th class='box'>" . $data[$i] ."</th>\n";
}
echo "</tr>\n";
while(!feof($file)){
$data = fgetcsv_reg($file);//???????????
echo "<tr>\n";
for($i=0; $i<$n; $i++){
echo "<td class='box'>" . $data[$i] ."</td>\n";
}

echo "</tr>\n";
}
echo "</table>\n";
}
?>

<?php
//????????????????????????????????
function addData($fname,$formData){
$file = fopen($fname,'a');//
flock($file,LOCK_EX);//
$data=implode(',',$formData);
fputs($file,"\n".htmlspecialchars($data));
flock($file,LOCK_UN);
fclose($file);
}
?>

<?php

//?????????????????????????????????????
function delDataList($fname){
$file = @fopen($fname,'r') or exit('????????????');
echo "<table class=\"box\">\n<tr>\n";
$data=fgetcsv_reg($file);//???????????
$dataNum = 1;
echo "<th>?</th>\n";
echo "<th class='box'>Check</th>\n";
$n = count($data);//????????????????
for($i=0; $i<$n; $i++){
echo "<th class='box'>" . $data[$i] ."</th>\n";
}
echo "</tr>\n";
$x = 1;
while(!feof($file)){
$data = fgetcsv_reg($file);//???????????
echo "<tr>\n";
echo "<td class='box'>" .$dataNum . "</td>\n";//????????
echo "<td class='box'><input type='checkbox' value='" .$dataNum. "' name=\"option1[$x]\"></td>\n";
$x++;

for($i=0; $i<$n; $i++){
echo "<td class='box'>" .$data[$i]. "</td>\n";
}
echo "</tr>\n";
$dataNum++;
}
echo "</table>\n";
}
?>

<?php
//?????????????????????????????
function delData($fname,$delNum){
echo "??????<br>";//???????
echo "?????????????";print_r($delNum);//????????

$n=count($delNum);//????
echo "<br>????????????$n ???<br>";//

$file = @fopen($fname,'r') or exit('????????????');
$file2 = fopen("temp",'w');//???????

//??????????????????????????????
$data = fgetcsv_reg($file);//
fputs($file2,$data[0].",".$data[1].",".$data[2].",".$data[3].",".$data[4]);

$i = 1;//$delNum[$i]??????
$count = 1;//$count???????????

//???????????
while(!feof($file)){
$data = fgetcsv_reg($file);//???????????
echo "?????$count";//??????????
if($delNum[$i] == $count){
echo "????????$delNum[$i] ?<br>";
$i++;
$count++;

}
else{
//fputs($file2,implode(',',$data)."\n");
//?????????????????????put
fputs($file2,"\n".$data[0].",".$data[1].",".$data[2].",".$data[3].",".$data[4]);

echo "??????(??)?$count ?<br>";
$i++;
$count++;
}

}

fclose($file);
fclose($file2);
unlink($fname);//?????????
rename("temp",$fname);//rename(????????,????????)
}
?>

<?php
//?????????
//??????????
function DataSea($fname){

//??????????
$f_in = $_POST['f_in'];
$city = $f_in;
echo "?" .$city. "??????";

//??????

$count = 0;
$fname ='flight_time02.csv';
$data1 = @fopen($fname,'r') or exit('???????????????');
echo "<table border=\"1\" cellpadding=\"5\">\n";
echo "<tr><th>???</th><th>???</th><th>????</th><th>????</th><th>????</th></tr>\n";

while (!feof($data1)){//eof?????????
$string = fgetcsv_reg($data1);//???????????????????
$tmp = strtok($city,'&');//&??????????
while($tmp){
//echo "<h1>" .$tmp. "</h1>";//??
if($string[1] == $tmp){
//$count=$count+1;//??
echo "<tr>\n";

foreach($string as $dt){//$dt??????????
echo "<td>" .$dt. "</td>\n";
}

echo "</tr>\n";
$count++;
}

$tmp = strtok('&');
}

}

echo "</table>\n";
echo "????" .$count. "???";
fclose($data1);
}

?>