Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>$str = file_get_contents($page_data["url"]);</p> <pre><code>if(strpos($str, $find) == true) { echo $page_data["referer_url"]. ' - gevonden'; $keywords = $_POST['keywords']; if($page_data["header"]){ echo "&lt;table border='1' &gt;"; echo "&lt;tr&gt;&lt;td width='300'&gt;Status:&lt;/td&gt;&lt;td width='500'&gt; ".strtok($page_data["header"], "\n")."&lt;/td&gt;&lt;/tr&gt;";} else "&lt;table border='1' &gt;"; // PRINT EERSTE LIJN echo "&lt;tr&gt;&lt;td&gt;Page requested:&lt;/td&gt;&lt;td&gt; ".$page_data["url"]."&lt;/td&gt;&lt;/tr&gt;"; // PRINT STATUS WEBSITE // PRINT WEBPAGINA echo "&lt;tr&gt;&lt;td&gt;Referer-page:&lt;/td&gt;&lt;td&gt; ".$page_data["referer_url"]."&lt;/td&gt;&lt;/tr&gt;"; // CONTENT ONTVANGEN? if ($page_data["received"]==true) echo "&lt;tr&gt;&lt;td&gt;Content received: &lt;/td&gt;&lt;td&gt;".$page_data["bytes_received"] / 8 . " Kbytes&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"; else { echo "&lt;tr&gt;&lt;td&gt;Content:&lt;/td&gt;&lt;td&gt;Not received&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"; } $domain = $_POST['domain']; $link = mysql_connect('localhost', 'crawler', 'password'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db("crawler"); if(empty($page_data["referer_url"])) $page_data["referer_url"] = $page_data["url"]; strip_tags($str, '&lt;p&gt;&lt;b&gt;'); mysql_query("INSERT INTO crawler (id, domain, url, keywords, data) VALUES ('', '".$page_data["referer_url"]."', '".$page_data["url"]."', '".$keywords."', '".mysql_real_escape_string($str) . "' )"); echo "&lt;br&gt;&lt;br&gt;"; echo str_pad(" ", 5000); // "Force flush", workaround flush(); } </code></pre> <p>As you can see I already got the keywords finded, now i need the part around it. Somebody told me i have to read the page in a treestructure and after I can use the part around my founded keyword (div, p, etc.)</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload