Hongtting

include "./configdbc.php";  // 디비연결

$filename = "/home/filename.txt";
 $fp = fopen($filename, "r") or die("파일열기에 실패하였습니다");

 while(!feof($fp))
 {
 
 $fpt = fgets($fp);
 
 $str = explode(",",$fpt);
 $count_ea = count($str);

 for($i = 0; $i <= $count_ea; $i++)
 {
 
  $value_trim = trim($str[$i]);

  $__QUE002    = "select * from tablename where 컬럼이름='$value_trim' ";
  $__RES002     = mysql_query($__QUE002);
  $__ROW002     = mysql_fetch_array($__RES002);
  
  // echo "$__QUE002 <br>";
  
  if( $i == 0 )
  {
   $textview = "";
  }
  else
  {
   $textview = ",";
  }

  if( $__ROW002[요청컬럼] ) { $studentgubunidx = $textview.$__ROW002[요청컬럼] ;  } else { $studentgubunidx = $textview.$value_trim ; }
   
   $arryidx .= $studentgubunidx  ;
   
   // $str[$i]
 }

 $arryidx_cut = substr( $arryidx ,0, -1 ) ;

// $buffer .= $fpt." / " . $arryidx . "<br>";
 $buffer .= $arryidx_cut . "<br>";
 $arryidx = "";

 }
 echo $buffer;
 
 fclose($fp);