Jump to content


Photo

Add Images to SQL table (while uploading them to your server from remote URL)


  • Please log in to reply
5 replies to this topic

#1 rksprst

rksprst
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 26 October 2006 - 04:29 AM

I am using the shopping cart software, CubeCart.

I am wondering what code I would need to access teh database and then to search for a product via its product_ID. Then to copy over the appropriate image from a remote server to my own server, and change a field in the database to reflect the new image for the product.

If anyone can give me hints as to how to do this...

Thanks :)

#2 gmwebs

gmwebs
  • Members
  • PipPipPip
  • Advanced Member
  • 174 posts
  • LocationLondon

Posted 26 October 2006 - 09:07 AM

mmmm... get a good lawyer methinks...

#3 rksprst

rksprst
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 26 October 2006 - 04:58 PM

If you're referring to me copying the image files from a remote server, this is allowed. As I'm copying the files from a distributor with whom I have a contract with.

Oh, and I forgot to add. This will all be gotten from a CSV file that has the product_ID and the corrosponding image URL in it.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 October 2006 - 05:49 PM

I can't guess how your DB is set up... but you have to pull the row, store it in PHP, make a new insert, and put it back.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 rksprst

rksprst
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 26 October 2006 - 05:56 PM

Hm, ok well I've been looking at some tutorials for php and mysql. And I just don't feel like learning a brand new language. So, I'd be willing to pay for someone to do this for me. PM me or post here if you're interested.

#6 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 October 2006 - 03:49 PM

We have a freelancing forum for just such a request.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users