db 파일 복사 + php

<?php 
include "../define.php";		// root define
include "define.php";		// sub define
include_once $_system[path][common]."lib/common.php";

/* dbconn data */
$_dbconnData = sread($_system, $_system[path][common]."conf/dbconn.php");

$dbInfo = dbConnect($_dbconnData);

exit;
$tableName = "inner_D4000";

$query = "SELECT pic, files,files2 FROM ".$tableName." ORDER BY indexcode ASC";
$dbData = getDBData($dbInfo, $query);


for($i = 0; $i < count($dbData); $i++){
	
	if($dbData[$i]['pic'] != ""){
		$pic1 = $pic2 = "";
		
		$picInfo = data2fileArray($_system['data']['char']['char3'], $dbData[$i]['pic']);
		$nothumb = str_replace("thumnail_", "", $picInfo[0][0]);
		$pic1 = $_system['path']['pic'].$nothumb;
		$pic2 = $_system['path']['data']."temp_pic/".$nothumb;
			
		if(file_exists($pic1) && !file_exists($pic2)){
			copy($pic1, $pic2);
		}
		
	}
	
	/*
	if($dbData[$i]['files'] != ""){
		$fileInfo = data2fileArray($_system['data']['char']['char3'], $dbData[$i]['files']);
		
		
		for($j = 0; $j < count($fileInfo); $j++){
			
			$file1 = $file2 = "";
			$file1 = $_system['path']['files'].$fileInfo[$j][0];
			echo var_dump(file_exists($file1));
		
			echo $file1."<br>";
			$file2 = $_system['path']['data']."temp/".$fileInfo[$j][0];
			
			if(file_exists($file1) && !file_exists($file2)){
				copy($file1, $file2);
			}
			
		}
	}
	
	if($dbData[$i]['files2'] != ""){
		$fileInfo = data2fileArray($_system['data']['char']['char3'], $dbData[$i]['files2']);
		
		
		for($j = 0; $j < count($fileInfo); $j++){
			
			$file1 = $file2 = "";
			$file1 = $_system['path']['files'].$fileInfo[$j][0];
			echo var_dump(file_exists($file1));
		
			echo $file1."<br>";
			$file2 = $_system['path']['data']."temp/".$fileInfo[$j][0];
			
			if(file_exists($file1) && !file_exists($file2)){
				copy($file1, $file2);
			}
			
		}
	}
	*/
}

?>

 

db 옮기기

썸네일 사이즈 작아서 -> 큰걸로

소스 돌리고

 

 

복사 str_replace 해서 thumnail_ 삭제해주고 썸네일 원본파일 가져온 후

새로운 temp_pic 폴더로 복사

하고 썸네일 재등록

 

@_@