Doogle is a search engine and web crawler which can search indexed websites and images
Find a file
2022-04-27 12:10:40 +01:00
ajax Doogle Master 2022-04-27 09:30:51 +01:00
assets Doogle Master 2022-04-27 09:30:51 +01:00
classes Doogle Master 2022-04-27 09:30:51 +01:00
config.php Doogle Master 2022-04-27 09:30:51 +01:00
crawl-formSubmit.php Doogle Master 2022-04-27 09:30:51 +01:00
crawl-manual.php Doogle Master 2022-04-27 09:30:51 +01:00
doogle-tables-no-data.sql Doogle Master 2022-04-27 09:30:51 +01:00
index.php Doogle Master 2022-04-27 09:30:51 +01:00
LICENSE Initial commit 2022-04-18 13:44:05 +01:00
README.md Update README.md 2022-04-27 12:10:40 +01:00
search.php Doogle Master 2022-04-27 09:30:51 +01:00
SHA256SUMS Doogle Master 2022-04-27 09:30:51 +01:00

Doogle

Doogle is a search engine and web crawler which can search indexed websites and image, and then using keywords be searched later.

Written primarily in OOP style PHP with the intent of better understanding OOP and how web crawlers work.

DoogleHomepage-Preview

Features

  • Search sites
    • Displays title, URL and description
  • Search images
    • Hover over images to preview description (alt tag)
    • Masonary layout for searched images
    • Image preview using Fancybox
    • Image search page responds dynamically
  • Clean homepage
  • Filters broken image results
  • Organises search results by clicks/visits
  • Pagination system at the bottom of the search page
  • Shows 'results found' for search term

Table of Contents

Setup and Usage

Server Setup

Please refer to XAMPP for the web server, PHP server and MySQL server configuration. XAMPP is the simplest method as several servers are required to use Doogle.

MySQL Setup on XAMPP will use PHPMyAdmin as a GUI method of setting up the database.

Once logged into the database via PHPMyAdmin under the PHPMyAdmin > SQL tab, the content of 'doogle-tables-no-data.sql' can be pasted into the field

Image1-PHPMyAdmin

Connecting PHP to MySQL Server

In the file config.php the following must be entered correctly for your database configuration:

$dbname = "doogle";
$dbhost = "127.0.0.1";
$dbuser = "root";
$dbpass = "";

In the file 'doogle-tables-no-data.sql' the database will be created as 'doogle', but the remaining parameters must still be filled.

Crawling Websites to Populate Images and Sites tables

Form-based crawl

In your browser go to where the file is hosted http://127.0.0.1/crawl-formSubmit.php

Paste the URL into the input field and press the Crawl button.

Manual crawl

At the bottom of crawl-manual.php the variable $startUrl is where to paste the URL of the website to be crawled:

$startUrl = "https://thehackernews.com/";

Then in your browser go to where the file is hosted http://127.0.0.1/crawl-manual.php

Explination

The crawling process will take some time, it will completely depend on the size of the website being crawled. The page will continue to load (without output) until the crawl.php script finishes.

Check the tables 'images' and 'sites' in the database to ensure they are being populated.

Image2-PHPMyAdmin

Once the tables are populated visit the Doogle homepage and search! See preview images.

Programming Logic

Pagination

Logic of pagination system

Inside search.php, pagination is implemented

image demonstrating pagnigation

In the example above, currentPage=11. The number of pages to show is always 10.

Results Per Page

Site search will return 20 results per page and image search will return 30 results per page.

The results per page can be changed inside search.php on lines {83, 88} respectively. As indicated by the $pageSize variables:

Search-resultsPerPage

Handling an edge case

An edge case can occur when no more pages are available.

So, for 331 results, 17 pages will be available. However, without an edge case scenario consider, the UI for the pagination system will allow scrolling through pages which don't exist; which would return an empty result.

To handle an edge case the following logic is implemented in the while-loop:

if($currentPage + $pagesLeft > $numPages + 1)
    $currentPage = $numPages + 1 - $pagesLeft;

while($pagesLeft != 0 && $currentPage <= $numPages) 
{ ... }

Image Captions

To make image searches more informative, the 'alt' tag is part of the search term. As shown in ./classes/ImageResultsProvider.php line 34

ImageResultsProvider-query

Loading Images with JavaScript

In the 'images' table there is a row 'broken' which tracks images which return an error.

Because images are already loaded with a pure server-side solution, AJAX must be leveraged, loading images dynamically. Which is shown in ./assets/js/script.js

script js-loadImage-broken

Masonry

Image searches are using Masonry - Cascading grid layout library.

Masonry allows images a grid layout which is responsive due to jQuery. The image below shows an example layout:

Masonry-item-layout

Site Search - Trimming Results

As shown in the preview images, Doogle when performing a site search will return (title, URL and description) for each result.

However, to make some results easier to read, a trimming process is performed. Inside ./classes/SiteResultsProvider.php the function trimField() is called:

SiteResultsProvider-trim1 SiteResultsProvider-trim2

Title's are trimmed at 55 characters and description's are trimmed at 230 characters.

Telemetry

Both the 'images' and 'sites' tables in the database have a row containing 'clicks' for each column.

The 'clicks' field is increased each time a site is visited or image is previewed.

When performing a search, results returned are organised in decending order of clicks. This behaviour is shown by the $query inside ./classes/SiteResultsProvider.php function getResultsHtml(). See line 43.

SiteResultsProvider-getResultsHtml

User-Agent

Inside ./classes/DomDocumentParser.php the user-agent data used during crawling is located. As indicated on line 9:

DomDocumentParser-bot

Preview Images

Doogle Homepage

Image3-DoogleHomepage-Edge

Doogle Search - Sites

Image4-DoogleSearch-PoC

Doogle Search - Images

Image5-DoogleSearch-PoC-images

Image Preview

Image preview is done using Fancybox.

The title, image URL and site URL are available on the bottom left corner.

Image9-DoogleSearch-imagePreview

Pagination System

Naturally certain search terms may return many results like 'bbc'.

To which Doogle only displays 20 sites per page. At the bottom of the page, we can view the next 10 pages.

Results Shown

Image6-DoogleSearch-pagination-ResultsShown

Bottom of Page

Image7-DoogleSearch-pagination-Bottom

Bottom of Page 13

Image8-DoogleSearch-pagination-scrollingThrough

doogleBot Crawl Form

An HTML form to submit a URL for crawling

Image10-doogleBot-Crawler-formpng

Preview Video

Doogle Search demo - YouTube