PDO::ERRMODE_WARNING, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); } catch(PDOException $e) { echo $e->getMessage(); } ?> Search Results

Full Text Keyword Search

This data is designed to give the developer a raw & unfiltered feed of real website search data.
A developer can then engineer the algorithm to manipulate high quality search results.

    prepare("SELECT count(*) as total FROM rt WHERE match(?)"); $sthc->execute(array($input_search)); $rowc = $sthc->fetch(PDO::FETCH_ASSOC); $count = $rowc['total']; $page = "1"; $limit = "20"; $sthc = $sphinx->prepare("SELECT * FROM rt WHERE match(?) "); $sthc->execute(array($input_search)); $out[] = array("section" => array("total_results" => $count, "current_page" => $page, "per_page" => $limit)); foreach ($sthc->fetchAll() as $sphinx_row){ $sthc = $dbh->prepare("SELECT domains.domain,meta_title.site_title,meta_description.description FROM domains LEFT JOIN rel_title ON rel_title.wid=domains.wid LEFT JOIN meta_title ON meta_title.id=rel_title.mid LEFT JOIN rel_description ON rel_description.wid=domains.wid LEFT JOIN meta_description ON meta_description.id=rel_description.mid WHERE domains.wid=?"); $sthc->execute(array($sphinx_row[id])); $row = $sthc->fetch(PDO::FETCH_ASSOC); $wid = $sphinx_row[id]; $domain = $row['domain']; $title = $row['site_title']; $description = $row['description']; $out[] = array( "result" => array( array( "wid" => "$wid", "domain" => "$domain", "page_title" => "$title", "page_description" => "$description" ) ) ); ?>


Results for

API Notes

Use the following code to access these search results programmatically

For more information visit the API docs

curl http://w3data.co/api/1000/search.php?search=

json data will be returned: