Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Chris
ioannes wrote: This is too advanced for me and having spent several hours reading I am no wiser. Given that I understand cURL and uploading files is possible - http://us3.php.net/features.file-upload - it should be just a matter of referencing a .jpg using a URL into a variable and uploading i

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread ioannes
This is too advanced for me and having spent several hours reading I am no wiser. Given that I understand cURL and uploading files is possible - http://us3.php.net/features.file-upload - it should be just a matter of referencing a .jpg using a URL into a variable and uploading it to the target

Re: [PHP-DB] Efficient way to access MS SQL server

2008-02-04 Thread Frank M. Kromann
Using the mssql extension based on Microsofts library (ntwdblib.dll) will have limitations like column length 30 bytes and character columns has a max length of 255 bytes. If you use the same extension based on the FreeTDS version of the dblib library these limitations goes away. Even on Windows p

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Chris
Aleksandar Vojnovic wrote: How about sending the file via SCP? (it would be a much more safer to transfer files) SFTP will work nicely though I don't know if there's a native SCP type function in php. I know there is the pecl library but that's not going to be available in most places (but ag

RE: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Mr Webber
Note the rsync option: --include-from=FILE This option is related to the --include option, but it specifies a FILE that contains include patterns (one per line). Blank lines in the file and lines starting with ';' or '#' are ignored. If FILE is -, the list will be read from s

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread ioannes
Initially I could not find much on SCP and rsynch is about synchronising folders, but that is only part of the problem. I don't want files in the target location that are not referenced from the target database. I hold references like this img[]=pic1.jpg&img[]=pic2.jpg then I parse it out i

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Daniel Brown
On Feb 4, 2008 11:03 AM, Daniel Brown <[EMAIL PROTECTED]> wrote: > On Feb 3, 2008 11:03 PM, Chris <[EMAIL PROTECTED]> wrote: > > FTP. > > > > There's no way fopen is going to be able to write to a remote url, > > that'd just be such a huge security issue it's not funny. > > I must've missed whe

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Daniel Brown
On Feb 3, 2008 11:03 PM, Chris <[EMAIL PROTECTED]> wrote: > FTP. > > There's no way fopen is going to be able to write to a remote url, > that'd just be such a huge security issue it's not funny. I must've missed when the W3C and IETF forced a disable on POST. ;-P -- Daniel P. Brown Senio

Re: [PHP-DB] Copying an image from one server to another

2008-02-04 Thread Aleksandar Vojnovic
How about sending the file via SCP? (it would be a much more safer to transfer files) -Aleksander Chris wrote: ioannes wrote: I am trying to: - check whether an image file exists on a server, - check whether it does not exist on another server, and if not exists - to copy from the first loca