Uploading Binary data: issues

Z3R0

I hope this is the right forum for this, I am definitly a php noob.

SO I found this script, on this site even, then I found a version that worked with php4 (yay). Changed the configuration so it worked on my database, and then tried to upload something. It goes through the motions, but nothing gets added to the database. I have used the same setup (i.e. db settings) to upload in other cases, just not with binary data. So the question is, is there a setting in the php.ini file that might be causing this problem? If it needs a temp directory to store things this could be the issue as there is no value set for this by my host.

Sorry for the long post, any and all help is appreciated.

Z3R0

mdixon

Z3r0: I think we will need a bit more detail to advise you on this one. What script is it you are attempting to run? (please provide a link to the original code you were working from) Can you paste in the code as modified by you (or if it is long give us a link to a copy of it somewhere).

It would also be a good idea to tell us what Operating System (eg. RedHat Linux 7.2, Win2000), Web-server and version (eg. IIS, or Apache2), PHP version.release.modlevel you are running the script on, and what database you are using (eg. MySQL 4.0.5a).

Z3R0

thanks for the reply. I've actually given up on this for the tiem being. I was trying to store image data in the db which I have since learned is a bad thing. The only reason I was trying this is because my host has no temporary directory specified in the php.ini so I couldn't find any way to upload images to a directory on the webserver. I think I'll just set up php and mySQL on my own machine as I have a break from school coming up.

Again thanks for the reply.

mdixon

Originally posted by Z3R0
.... I've actually given up on this for the tiem being. I was trying to store image data in the db which I have since learned is a bad thing. ...

I guess your back-end database is mySQL? FYI: IBM's DB2 UDB is designed to deal with graphic elements. So, if that is available to you at some time in the future you might want to reconsider.

Z3R0

yeah its mySQL, if this was a money making venture I'd consider IBM's DB2 UDB, however this is just a student project, and really, when it comes to databases and programming php I'm far to knew at this to try and learn yet another product. Setting up mySQL and php on my system is pretty easy and then I'll be able to simply upload to a directory, which is all I really need.

mdixon

Originally posted by Z3R0
yeah its mySQL, if this was a money making venture I'd consider IBM's DB2 UDB, however this is just a student project, ...

PHP programming is quite similar for mySQL, Oracle, DB2 and SQLserver. Having the commercial/proprietary products on your resume is likely to look even better than just having mySQL (even though we all know that mySQL performs up there with the best of them). If your university or college is part of the IBM Scholars Program then you can probably use DB2 UDB, and possibly Oracle too, with PHP4 on a mainframe based Linux server, for free if it is for a class project. Ask your lecturer.

Z3R0

Sadly my school doesn't delve into the programming side of web development much. This was the first quarter they even offered php.