Image Uploading Scenario

[Nixon]

Hey all,

I want to upload images to an external sever for my website. The images will be user uploadable through my website then I need to transfer them to another web server, to save bandwidth costs. How would I go about doing this? This is my current image script:

<?php

include("includes/connectdb.php");

if ($error==NULL) 

{

$timestart=time();

mysql_query("	insert into classifieds

(				status, title, guitar, price, timestart, timeend, condition, tremlo, yearmade, serialno, 
				countryorigin, originalparts, necktype, description, postageprice, postageservice, 
				postalinsurance, collection, userid, link1, link2, link3, link4) 

			values 

			('1','$title', '$guitar', '$price', '$timestart', '$duration', '$condition', '$tremlo'
			, '$yearmade', '$serialno', '$countryorigin', '$originalparts', '$necktype', 
			'$description', '$postageprice', '$postageservice', '$postalinsurance', 
			'$collection', '$userid', '$linkarray[1]', '$linkarray[2]', '$linkarray[3]', '$linkarray[4]') ") 

			or print ( mysql_error() );

if ($empty!="Y") {

$info=mysql_query("select * from classifieds where title='$title' and price='$price' and description='$description'");

while ($row=mysql_fetch_array($info))

{

$classid=$row[id];

}

$i=0;

$imagepath="C:/phpdev/www/templatesite/ftpupload/$classid/";

while ($i<=$numphotos)

{

if ($i==0 ) { mkdir("$imagepath", 077 ); }

move_uploaded_file( $array[$i] , "C:/phpdev/www/templatesite/ftpupload/$classid/$i.jpg");

$i++;

}

$photo="insert into classphotos (id, numphotos";

$i=1;

while ($i<=$numphotos)

{

$photo .= ",photo";
$photo .= $i;

$i++;

}

$photo .= ") values ('";
$photo .= $classid;
$photo .="','";
$photo .= $numphotos;
$photo .="'";

$i=1;

while ($i<=$numphotos)

{

$photo .= ",'";
$photo .= $imagepath;
$photo .= $i;
$photo .= ".jpg";
$photo .= "'";

$i++;

}

$photo .= ")";

mysql_query("$photo") or die (mysql_error() ); 

}

}

else { print "<script> location.href='listguitar.php?error=$error' </script>"; die("$error"); }

?>

Also any code critique would be helpful too!!!

Thanks in advance.

Jack

[Nixon]

Hi guys,

I have sorted the first part of the problem which is uploading to the server. Now I have to transfer files from the server to the ftp. I want to transfer a WHOLE directory and all directories inside it to go with it. Any ideas? Here is my ftp script it connects fine but I need to use a different function to ftp_put to transfer ALL my files.

<?php

$ftp_server			=	"ftp.villagephotos.com";
$ftp_user_name		=	"guitarseller";
$ftp_user_pass		=	"mitchell";
$destination_file	=	"/";
$source_file		=	"/home/swimming/public_html/guitar/ftpupload/";

// set up basic connection
$conn_id = ftp_connect($ftp_server); 

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass); 

// check connection
if ((!$conn_id) || (!$login_result)) { 
       echo "FTP connection has failed!";
       echo "Attempted to connect to $ftp_server for user $ftp_user_name"; 
       exit; 
   } else {
       echo "Connected to $ftp_server, for user $ftp_user_name";
   }

// upload the file
$upload = ftp_put($conn_id, $destination_file, $source_file, FTP_BINARY); 

// check upload status
if (!$upload) { 
       echo "FTP upload has failed!";
   } else {
       echo "Uploaded $source_file to $ftp_server as $destination_file";
   }

// close the FTP stream 
ftp_close($conn_id); 

?>

Thanks in advance!!!

Oh yeah error message when I run the above script:

Connected to ftp.villagephotos.com, for user guitarseller
Warning: ftp_put(): PORT command successful in /home/swimming/public_html/guitar/includes/ftpcron.php on line 25
FTP upload has failed!

[Nixon]

Alright, with passive turned on I get the error:

Connected to ftp.villagephotos.com, for user guitarseller
Warning: ftp_put(): type set in /home/swimming/public_html/guitar/includes/ftpcron.php on line 29
FTP upload has failed!

With passive turned off I get the error:

Connected to ftp.villagephotos.com, for user guitarseller
Warning: ftp_put(): PORT command successful in /home/swimming/public_html/guitar/includes/ftpcron.php on line 29
FTP upload has failed!

And my changed code is:

<?php

$ftp_server			=	"ftp.villagephotos.com";
$ftp_user_name		=	"guitarseller";
$ftp_user_pass		=	"mitchell";
$destination_file	=	"/";
$source_file		=	"/home/swimming/public_html/guitar/ftpupload/6/1.jpg";

// set up basic connection
$conn_id = ftp_connect($ftp_server); 

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass); 

// Turn passive mode on
ftp_pasv($conn_id, false);

// check connection
if ((!$conn_id) || (!$login_result)) { 
       echo "FTP connection has failed!";
       echo "Attempted to connect to $ftp_server for user $ftp_user_name"; 
       exit; 
   } else {
       echo "Connected to $ftp_server, for user $ftp_user_name";
   }

// upload the file

$upload = ftp_put($conn_id, $destination_file, $source_file, FTP_BINARY);

// check upload status
if (!$upload) { 
       echo "FTP upload has failed!";
   } else {
       echo "Uploaded $source_file to $ftp_server as $destination_file";
   }

// close the FTP stream 
ftp_close($conn_id); 

?>

[Nixon]

Right!!! I got it to work with 1 file. Now i'm still stuck with the fact that I need to upload a whole directory?

Please has anybody any ideas?!