project web scrapper

<?php include('header.php'); ?>


<?php

$the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : '';
?>
<div class="hero-unit">
<form method="post">
  Enter URL(http://):<br />
  <input type="text" name="url" size="30" value="<?php echo $the_url;  ?>"/>
  <br />
    <input type="submit" value="Parse Emails" />

</form>

<?php
if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) {
  // fetch data from specified url
  $text = file_get_contents($_REQUEST['url']);
}
elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) {
  // get text from text area
  $text = $_REQUEST['text'];
}

// parse emails
if (!empty($text)) {
  $res = preg_match_all(
    "/[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}/i",
    $text,
    $matches
  );

  if ($res) {
    foreach(array_unique($matches[0]) as $email) {
      echo $email . "<br />";
      $dbhost='localhost';
$dbuser='mashpy_sanjida';
$dbpass='Mashpy#2134';
$conn= mysql_connect($dbhost,$dbuser,$dbpass);
if(!conn)
{
die('could not connect'.mysql_error());
}
$sql="insert into crawler(metatag,links) values ('url','$email')";
  
  mysql_select_db(mashpy_sanjida);
  $retravail=mysql_query($sql,$conn);
  if(!$retravail)
  {
  die('could not connect data'.mysql_error());
  }
  echo "";
  
   mysql_close($conn);
    }
  }
  else {
    echo "No emails found.";
  }
}


  

?></div>
<?php include('footer.php'); ?>