[RESOLVED] More ftp issues

[fnp]

So I had this working, but when I went to add a little criteria to the code it started lagging. In other words when you run the script for it to use the ftp it wood take upwards of 40 minutes to complete the transfer, but the webpage never finishes. I am certain it is probably something simple but need a little help finding it.

Here is the code:
FPN is the URL to the image.

for($i=0; $i<$rstSEL->num_rows; $i++){
				$rowSEL=$rstSEL->fetch_row();
				$NewImgID[$i]=$rowSEL[1];
				$qryIMG='SELECT ImageID, FPN FROM tblImages WHERE ImageID='.$rowSEL[1];
				$rstIMG=$conDIMG->query($qryIMG);
				$rowIMG=$rstIMG->fetch_assoc();
				$FPN=fdbp_url($rowIMG['FPN']);
				$ImgFil=explode('/',stripslashes($rowIMG['FPN']));
				$rstIMG->free();
				$ImgFil=$ImgFil[(sizeof($ImgFil)-1)];
				if(strpos($FPN,'NAME')>0){
					$NewFPN[$i]=mysql_escape_string('http://www.NAME.com/auci/'.$ImgFil);
				}
				if(strpos($FPN,'incoming')>0){
					$NewFPN[$i]=mysql_escape_string('http://www.NAME.com/auci/'.$ImgFil);
					$fp = fopen('../auci/incoming/'.$ImgFil, 'r');
					$conn_id = ftp_connect($ftp_server);
					//if($conn_id){
						//echo "Conn is Good!";
					//}
					$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
					//if($login_result){
						//echo "Login is good!";
					//}
					ftp_pasv($conn_id, true);
					if (ftp_fput($conn_id, $ImgFil, $fp, FTP_ASCII)) {
    						$UploadMessage="Successfully Uploaded Images!!!";
						$current_dir='../auci/incoming/';
						unlink($current_dir.$ImgFil);
					} 
					else{
    						$UploadMessage="There was a problem while uploading images.";
					}
					fclose($fp);
					ftp_close($conn_id);
				}
				else{
					$NewFPN[$i]=mysql_escape_string('http://www.DIFFERENTNAME.com/auci/'.$ImgFil);
				}

		}			

Any help is appreciated.
FNP

[fnp]

Ok so I have tried several different things with the ftp part of it to no avail. Like I said earlier the ftp part worked before I added the if statements. I think it is in continuous loop with the if and else statements, but I can't seem to find the problem.

Any help is appreciated.
FNP

[fnp]

This is what worked before. This is without any of the if or else statements.

		for($i=0; $i<$rstSEL->num_rows; $i++){
				$rowSEL=$rstSEL->fetch_row();
				$NewImgID[$i]=$rowSEL[1];
				$qryIMG='SELECT ImageID, FPN FROM tblImages WHERE ImageID='.$rowSEL[1];
				$rstIMG=$conDIMG->query($qryIMG);
				$rowIMG=$rstIMG->fetch_assoc();
				$ImgFil=explode('/',stripslashes($rowIMG['FPN']));
				$rstIMG->free();
				$ImgFil=$ImgFil[(sizeof($ImgFil)-1)];
				$fp = fopen('../auci/incoming/'.$ImgFil, 'r');
               			$conn_id = ftp_connect($ftp_server);
                		//if($conn_id){
                    			//echo "Conn is Good!";
                		//}
                		$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
                		//if($login_result){
                   			//echo "Login is good!";
                		//}
                		if (ftp_fput($conn_id, $ImgFil, $fp, FTP_ASCII)) {
                        		$UploadMessage="Successfully Uploaded Images!!!";
                		}
               			else{
                        		$UploadMessage="There was a problem while uploading images.";
                		}
                		ftp_close($conn_id);
                		fclose($fp);

		}

[fnp]

So after a little bit more testing I managed to get it to tell me some errors. It will transfer about half the files (about 5) then I get an ftp_login error. I wonder if since I am transferring multiple files at a time if maybe I should make a constant connection to the destination server until all files have been transferred. I will try it and get back.

Any help is appreciated.
FNP

[fnp]

So I think I got it. The previous statement was asking server1 to connect to server2 multiply times in execution of the script. Because this script is designed to transfer multiple files at once. I figured out that server2 was rejecting the login attempt of server1 after a couple of transfers. So I moved the 'ftp_connect', 'ftp_login', and 'ftp_pasv' above the 'for' statement, that way it will establish one connection and use it until it finishes transferring all the files.

Here is the end result.

$conn_id = ftp_connect($ftp_server) or exit("conn_id");
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass) or exit("ftp_login");
ftp_pasv($conn_id, true);
for($i=0; $i<$rstSEL->num_rows; $i++){
	$rowSEL=$rstSEL->fetch_row();
	$NewImgID[$i]=$rowSEL[1];
	$qryIMG='SELECT ImageID, FPN FROM tblImages WHERE ImageID='.$rowSEL[1];
	$rstIMG=$conDIMG->query($qryIMG);
	$rowIMG=$rstIMG->fetch_assoc();
	$FPN=fdbp_url($rowIMG['FPN']);
	$ImgFil=explode('/',stripslashes($rowIMG['FPN']));
	$rstIMG->free();
	$ImgFil=$ImgFil[(sizeof($ImgFil)-1)];
	if(strpos($FPN,'NAME')>0){
			$NewFPN[$i]=mysql_escape_string('http://www.SERVER1.com/auci/'.$ImgFil);
	}
	elseif(strpos($FPN,'incoming')>0){
			$NewFPN[$i]=mysql_escape_string('http://www.SERVER1.com/auci/'.$ImgFil);
			$fp = fopen('../auci/incoming/'.$ImgFil, 'r') or exit("fopen");
			if (ftp_fput($conn_id, $ImgFil, $fp, FTP_ASCII) or exit("ftp_fput ($ImgFil)")) {
					$UploadMessage="Successfully Uploaded Images!!!";
					$current_dir='../auci/incoming/';
					unlink($current_dir.$ImgFil) or exit("unlink ($ImgFil)");
			} 
			else{
					$UploadMessage="There was a problem while uploading images.";
			}
			fclose($fp);
	}
	else{
			$NewFPN[$i]=mysql_escape_string('http://www.SERVER2.com/auci/'.$ImgFil);
	}
}			
ftp_close($conn_id);

Thanks
FNP