Uploading to a db and ftp?

danielhalawi

Is there a way of uploading text data to a database, and in the same form uploading images to my server using ftp?

If I do decide to do this what can I do with the images I have in the database already stored as binary data?

danielhalawi

Can anyone help?

theeper

Sure, you can have a simple script to insert text in to a DB, then have it make an FTP connection and load your images to the filesystem.

As far as getting images from the DB, I have never done it, but you should be able to write the binary data back to the disk.

danielhalawi

Could direct me in the right direction to do it?

Help is appreicated

theeper

Look at www.php.net/manual/en all this stuff is in there.

First, read on how to connect to the DB server and do a
simple update query.

Then read about making an FTP connection and loading files.
You can load up your files using HTTP unless there is a real reason you need to do FTP.

Depending on your setup, it may be easier to do this with a DOS batch file.

danielhalawi

I'm sorry this is all going over my head.

I have posted in this forum because I am a "Newbie" to PHP and MySQL.

So can u give me some help in leaimans terms.
Sorry

theeper

You need to read the manual and learn how to do a simple update query using an UPDATE statement in your SQL query.

This will allow you to update the text. I am not going to explain how to do this as this is very very simple and you can pick it up from the manual. Info for the mysql() functions can be found here...
http://www.php.net/manual/en/ref.mysql.php

Loading your files can be done in at least two ways. First with FTP. PHP has built in FTP functions that allow you to connect to and load/download files, traverse the directory structure, rename files etc. Info on PHP's FTP functions can be found at ...
http://www.php.net/manual/en/ref.ftp.php

The other way to load your files is via HTTP, or through an HTML form. This way, you do not have to create an FTP script. Either way is not difficult. For this method to work, you will need to make sure the proper permissions are set on the directories you are loading to. Info on loading files via HTTP can be found here...
http://www.php.net/manual/en/features.file-upload.php

Get started on your script and post what you come up with along with information about what you are trying to do with a particular piece of code and myself or someone else will gladly help you. I am not going to write it for you though.