I have to write a program that will repeatedly extract links to a depth level of 3. i.e., after extracting links the first time i store the links in the mysql database. then i fetch these links and iterate the function over each link to extract more links.. so i have to do three times. I have stored and then fetched the links from the database i aint able to run the function on each link and store them back to the database. the code is shown previously. 
#!/usr/bin/perl
use LWP::UserAgent;
  use HTML::LinkExtor;
  use URI::URL;  $url =<>;;  # for instance
#my $depth = 0;
my @link =();
 my $ua = LWP::UserAgent->new;  # Set up a callback that collect links
my @a = ();
  sub callback {
my($tag, %attr) = @_;
    return if $tag ne 'a';
   push(@a,values %attr);
 } # Make the parser.Unfortunately, we don't know the base yet (it mig
+ht be
#diffent from $url)
my $p = HTML::LinkExtor->new(\&callback);
my $res = $ua->request(HTTP::Request->new(GET => $url),
sub {$p->parse($_[0])});  # Expand all image URLs to absolute ones
  my $base = $res->base;
  @a = map { $_ = url($_, $base)->abs; } @a;  # Print them out
  print join("\n", @a), "\n";

use strict;
use DBI();
my $dbh = DBI->connect("DBI:mysql:database=gatxp;host="","","");
#$dbh->do("CREATE TABLE newlinks  (md5 INTEGER(100) not null primary k
+ey, webpage VARCHAR(80) not null)");
$dbh->do("INSERT INTO newlinks VALUES ('MD5','0','$base','1')");
foreach $a(@a){
$dbh->do ("INSERT INTO newlinks VALUES ('','1','$a','0')");
}
my $sth = $dbh->prepare('SELECT  *  FROM newlinks')
                or die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute();
 while( my $ref = $sth->fetchrow_hashref()){
my $link=$ref->{'webpage'};
foreach $link(@link){
my $usa = LWP::UserAgent->new;
$p = HTML::LinkExtor->new(\&callback);
my $res = $usa->request(HTTP::Request->new(GET => $link),
sub {$p->parse($_[0])});
 $base = $res->base;
  @link = map { $_ = url($_, $base)->abs; } @link;  # Print them out
  print "$$link\n";

$sth->finish();
$dbh->disconnect();

[download]

In reply to Re^4: How to extract links from a webpage and store them in a mysql database by syedahmed.uos
in thread How to extract links from a webpage and store them in a mysql database by syedahmed.uos

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.