PHP & MySQL Inserting multiple entires from range.

Acrylic · 10-01-2008, 03:24 PM

First off let me explain whats going on, I have a site that people use to share and manage picture url's. The biggest complaint I get is that they can only add one picture url at a time and they would like to start doing them in large batches of like 200. I want to use a method where if they submit a URL with a pattern something like:

http://www.userwebsite.com/pictures/Cleveland[1-100].jpg

It will automatically add the 100 different URL's into the MySQL database. How would I do this? I have been looking around but its driving me crazy! Thanks!!!

jcorradino · 10-01-2008, 11:26 PM

I would think it would be easier to do it this way

the links would be something like:

(URL)Cleveland#.jpg

and you would have a separate field that tells the range (100 in this case)

your php would look like this:

PHP Code:


			
$srcImage = cleanData($_POST['link']);//always clean user data
$range = cleanData($_POST['range']);
$link = @mysql_connect ('server','user','pass')

for ($i=1;$i<=$range;$i++) {
  $image = str_replace('#',$i,$srcImage);
  $sql = 'INSERT INTO `yourdb`.`table` VALUES (null, "$image");';
  @mysql_query($sql,$link); //assuming you already made a connection
}
@mysql_close($link);

This should do what you were looking for, hope this helps.

Edit: How the hell did you get it to display the link, I keep getting Userwebsite.com - personal website Resources and Information. This website is for sale![1-100].jpg <-that

Acrylic · 10-02-2008, 02:05 AM

Quote:

Originally Posted by jcorradino

Edit: How the hell did you get it to display the link, I keep getting Userwebsite.com - personal website Resources and Information. This website is for sale![1-100].jpg <-that

Awesome thanks, I knew it would be something easy!

Also, if you uncheck the "Automatically parse links in text" in the Additional Options area it wont parse the links :D

jcorradino · 10-02-2008, 02:27 AM

thanks, that can be helpful in the future, I did not even notice the additional options box, lol