엑셀파일 업로드후 db에 바로 저장시키는 작업중인데요..
이런 오류가 발생하네요...
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOAD DATA INFILE '/tmp/phpH1q6d8' INTO TABLE sajen fields termi
무슨 오류인가요..??
네이버에 검색해보니깐 문법오류라는데.. 전혀 몰르겠습니다...
아래 소스 올릴께요~
<?
include("./inc/db_conn.php");
if($file){
chmod($_FILES['file']['tmp_name'], 0644);
$qs=$_FILES['file']['tmp_name'];
//chmod($_FILES['file'][$file], 0644);
//$qs=$_FILES['file'][$file];
/* mysql_query("LOAD DATA INFILE '$qs' INTO TABLE bookdb2 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'");
echo("파일업로드 저장이 완료 되었습니다.");
*/
$query="update sajen set
memo = '$memo',
file = '$qs',
regdate = '".time()."'
where
no = '$no'
"."LOAD DATA INFILE '$qs' INTO TABLE s fields terminated by '.' lines terminated by '\r\n'";
mysql_query($query,$conn)or die(mysql_error());
}
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
alert("정상 등록 되었습니다.");
//-->
</SCRIPT>
<meta http-equiv='Refresh' content='0; URL=./sajen_list.php'>
|