Images gallery with links

Dev Shed Forums Sponsor:

February 4th, 2012, 09:37 PM

DaAvatar

Registered User

Join Date: Feb 2012

Posts: 2

Time spent in forums: 11 m 51 sec
Reputation Power: 0

Images gallery with links

Hello,
I'd really need some help.
I created a gallery with links on each thumbnail.
All my links are written down in a .txt file like this

Code:

<div class="gallery">
 <a href="http://www.website.com">
  <img src="http://tc16.easythumbhost.com/image.jpg" onerror="ImgError(this)"/>
 </a>
</div>
#enddiv

Then, my pages are separated with a php script to get links from the txt

PHP Code:


		
			
<?php

 $links = "links/links.txt";

 $fd = fopen ($links, "r");

 $content = fread ($fd,filesize ($links));

 fclose ($fd);

 $delimiter = "#enddiv";

 $splitcontent = explode($delimiter, $content);

 $output = array_slice($splitcontent, 0, 160);

?>



<?php

 foreach ( $output as $divs )

{

 echo "$divs";

}

?>

My script works very well, but I got another problem : dead links.
After days of searches, work and some help, I got a php script which deletes all the div section of a broken link. But php has to rewrite the whole file each time, so when I got many broken links from the same file, it corrupts because It doesnt have time to rewrite file many times in a few seconds.

I never tried SQL and someone told me to go with it, cause it would be easier to manage the dead links. I don't have any idea how to use it and I'm so tired of all these days of work for nothing.
Would need some help so I could work with Database.
Thanks.

February 5th, 2012, 06:08 AM

SimonJM

Contributing User

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Mar 2006

Posts: 1,914

Time spent in forums: 1 Month 5 Days 11 h 34 sec
Reputation Power: 1297

mySQL has no9 facility to 'handle' dead link in and of itself. However, your scripts (page build and link checking) could make use of data from a database, and the updating of the underlying rows in the table of your database would be better suited to the process than 'hacking' at a file.
The order in which the data came from the database would not be guaranteed (unlike the linear form of the file) unless you sorted the returned rows.

__________________
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc

February 5th, 2012, 06:21 AM

DaAvatar

Registered User

Join Date: Feb 2012

Posts: 2

Time spent in forums: 11 m 51 sec
Reputation Power: 0

There's no problem with the returned rows. I was wondering if it would be possible to remove the dead links from database with the "onerror" of the img without having to rewrite the whole file for each dead link.
I'm currently using it with php but it rewrites completely the file multiple times in few seconds so memory doesn't take it all.

February 5th, 2012, 08:54 AM

SimonJM

Contributing User

Join Date: Mar 2006

Posts: 1,914

Time spent in forums: 1 Month 5 Days 11 h 34 sec
Reputation Power: 1297

If you have a way to uniquely identify the link in question, from within the onerror code, within the database then the simple answer is 'yes'