PHP - Refined Search Via Google, Bing And Yahoo Search Engine Simultaneously

For a long time, I think I have been using heading tags wrong on websites.    They always show like this on Google.

Websitename
websitename.com/category?name=mystery
Posted by Night Flyer; 7 days ago; 5 views. « first; « prev; 1 of 1; next »; last ». Contact Us; @ 2014 websitename Inc. All Rights Reserved.

As you can see, Google takes all the heading tags on my page and puts them in the description of the search result.  So I have finally come to the conclusion that I should not be using heading tags for those things.  Am I correct on that?

I want to know how to display results from mysql database by filling in a form. but i have found a tutorial which shows typing in a text box which displays results. if i follow this tutorial will it help me to understand and create php coding to display results for my form?

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

Friends,

I want to extract the Search Keyword from the URL, a visitor came from. I am using a PHP CMS and want to show the Keyword on my Blog.

So if they search "abcd" from google, i want to extract "abcd" and echo on my blog.

Here is the coding i could got hold of, but its not working, not echoing anything

<?php

function pk_stt2_function_get_delimiter($ref) {
    $search_engines = array('google.com' => 'q',
'go.google.com' => 'q',
'images.google.com' => 'q',
'video.google.com' => 'q',
'news.google.com' => 'q',
'blogsearch.google.com' => 'q',
'maps.google.com' => 'q',
'local.google.com' => 'q',
'search.yahoo.com' => 'p',
'search.msn.com' => 'q',
'bing.com' => 'q',
'msxml.excite.com' => 'qkw',
'search.lycos.com' => 'query',
'alltheweb.com' => 'q',
'search.aol.com' => 'query',
'search.iwon.com' => 'searchfor',
'ask.com' => 'q',
'ask.co.uk' => 'ask',
'search.cometsystems.com' => 'qry',
'hotbot.com' => 'query',
'overture.com' => 'Keywords',
'metacrawler.com' => 'qkw',
'search.netscape.com' => 'query',
'looksmart.com' => 'key',
'dpxml.webcrawler.com' => 'qkw',
'search.earthlink.net' => 'q',
'search.viewpoint.com' => 'k',
'mamma.com' => 'query');
    $delim = false;
    if (isset($search_engines[$ref])) {
        $delim = $search_engines[$ref];
    } else {
        if (strpos('ref:'.$ref,'google'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.atomz.'))
            $delim = "sp-q";
elseif (strpos('ref:'.$ref,'search.msn.'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.yahoo.'))
            $delim = "p";
        elseif (preg_match('/home\.bellsouth\.net\/s\/s\.dll/i', $ref))
            $delim = "bellsouth";
    }
    return $delim;
}

/**
 * retrieve the search terms from search engine query
 * */ 
function pk_stt2_function_get_terms($d) {
    $terms       = null;
    $query_array = array();
    $query_terms = null;
    $query = explode($d.'=', $_SERVER['HTTP_REFERER']);
    $query = explode('&', $query[1]);
    $query = urldecode($query[0]);
    $query = str_replace("'", '', $query);
    $query = str_replace('"', '', $query);
    $query_array = preg_split('/[\s,\+\.]+/',$query);
    $query_terms = implode(' ', $query_array);
    $terms = htmlspecialchars(urldecode(trim($query_terms)));
    return $terms;
}

/**
 * get the referer
 * */ 
function pk_stt2_function_get_referer() {
    if (!isset($_SERVER['HTTP_REFERER']) || ($_SERVER['HTTP_REFERER'] == '')) return false;
    $referer_info = parse_url($_SERVER['HTTP_REFERER']);
    $referer = $referer_info['host'];
    if(substr($referer, 0, 4) == 'www.')
        $referer = substr($referer, 4);
    return $referer;
}



$referer = pk_stt2_function_get_referer();
if (!$referer) return false;
$delimiter = pk_stt2_function_get_delimiter($referer);
if( $delimiter ){
$term = pk_stt2_function_get_terms($delimiter);
}
echo $term;
?>


May someone help?

Natasha T

I have successfully used the Yahoo local search API and received results in XML format. I am trying to use PHPs Simple XML to parse the data into an array so I can loop through and print specific elements.

I cannot get to specific elements and I have read several threads online.

Below is some code and below that is the XML. I am trying to get to the elements like title, address, etc.

Code: [Select]
$url = 'http://local.yahooapis.com/LocalSearchService/V3/localSearch?appid=<my yahoo api key>&category=Casinos&query=blackjack&zip=95035&radius=20&results=10';

$xml = file_get_contents($url);

$phpobject = simplexml_load_string($xml);

foreach($phpobject->attributes() as $name=>$attr) {
   $res[$name]=$attr;   
}

Code: [Select]
<ResultSet xsi:schemaLocation="urn:yahoo:lcl http://local.yahooapis.com/LocalSearchService/V3/LocalSearchResponse.xsd" totalResultsAvailable="48" totalResultsReturned="10" firstResultPosition="1">
−
<ResultSetMapUrl>
http://maps.yahoo.com/broadband/?q1=Milpitas%2C+CA+95035&tt=poker&tp=1
</ResultSetMapUrl>
−
<Result id="34179399">
<Title>Bay Area Poker Chip</Title>
<Address>1274 Piper Dr</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.412359</Latitude>
<Longitude>-121.891794</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>1</TotalRatings>
<TotalReviews>1</TotalReviews>
<LastReviewDate>1198993183</LastReviewDate>
−
<LastReviewIntro>
I bought 100% real clay chips from here and obsolutely love it. I had a poker game that night and needed chips and a table. They had everything in stock and saved me time to look around. Great products and great service and I highly recommend this place to anybody
</LastReviewIntro>
</Rating>
<Distance>1.33</Distance>
−
<Url>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1274+Piper+Dr+Milpitas+CA&gid1=34179399
</MapUrl>
<BusinessUrl>http://bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928631">Graphic Design</Category>
</Categories>
</Result>
−
<Result id="44540748">
<Title>Bay Area Poker Chip</Title>
<Address>519 Montague Expy</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.409925</Latitude>
<Longitude>-121.89489</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>1.48</Distance>
−
<Url>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=519+Montague+Expy+Milpitas+CA&gid1=44540748
</MapUrl>
<BusinessUrl>http://www.bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://www.bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925976">Sporting Goods</Category>
<Category id="96935378">Games</Category>
</Categories>
</Result>
−
<Result id="67710717">
<Title>Poker Da Vinci</Title>
<Address>51 E Campbell Ave</Address>
<City>Campbell</City>
<State>CA</State>
<Phone>(408) 866-4446</Phone>
<Latitude>37.287157</Latitude>
<Longitude>-121.94942</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>10.40</Distance>
−
<Url>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=51+E+Campbell+Ave+Campbell+CA&gid1=67710717
</MapUrl>
<Categories/>
</Result>
−
<Result id="21599986">
<Title>Bay 101 Banquet Facilities</Title>
<Address>1801 Bering Dr</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 451-8888</Phone>
<Latitude>37.373044</Latitude>
<Longitude>-121.912125</Longitude>
−
<Rating>
<AverageRating>4</AverageRating>
<TotalRatings>2</TotalRatings>
<TotalReviews>2</TotalReviews>
<LastReviewDate>1200040214</LastReviewDate>
−
<LastReviewIntro>
If youre looking for high limit action Bay 101 is the place to go in San Jose. You can regularly find limit games up to $80-$160 in their spacious high ceiling room.
</LastReviewIntro>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1801+Bering+Dr+San+Jose+CA&gid1=21599986
</MapUrl>
<BusinessUrl>http://bay101.com/</BusinessUrl>
<BusinessClickUrl>http://bay101.com/</BusinessClickUrl>
−
<Categories>
<Category id="96929273">Casinos</Category>
</Categories>
</Result>
−
<Result id="21401964">
<Title>Thwart Poker Incorporated</Title>
<Address>525 Lincoln Ave</Address>
<City>Palo Alto</City>
<State>CA</State>
<Phone>(650) 329-9627</Phone>
<Latitude>37.444049</Latitude>
<Longitude>-122.151513</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>14.09</Distance>
−
<Url>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=525+Lincoln+Ave+Palo+Alto+CA&gid1=21401964
</MapUrl>
−
<Categories>
<Category id="96926908">Internet Access Providers</Category>
<Category id="96932773">Computer Business Solutions</Category>
</Categories>
</Result>
−
<Result id="21574436">
<Title>Blinky's Can't Say Lounge</Title>
<Address>1031 Monroe St</Address>
<City>Santa Clara</City>
<State>CA</State>
<Phone>(408) 985-7201</Phone>
<Latitude>37.348893</Latitude>
<Longitude>-121.94816</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>3</TotalRatings>
<TotalReviews>3</TotalReviews>
<LastReviewDate>1228667811</LastReviewDate>
−
<LastReviewIntro>
Good drinks good prices good people. Who could ask for more.....
</LastReviewIntro>
</Rating>
<Distance>6.39</Distance>
−
<Url>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1031+Monroe+St+Santa+Clara+CA&gid1=21574436
</MapUrl>
−
<Categories>
<Category id="96926057">All Bars, Pubs, & Clubs</Category>
<Category id="96926063">Bars & Pubs</Category>
</Categories>
</Result>
−
<Result id="21619987">
<Title>Barbara of Pauline's Cake Decorating Supplies</Title>
<Address>1093 Malone Rd</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 978-9740</Phone>
<Latitude>37.293702</Latitude>
<Longitude>-121.889876</Longitude>
−
<Rating>
<AverageRating>4.5</AverageRating>
<TotalRatings>8</TotalRatings>
<TotalReviews>8</TotalReviews>
<LastReviewDate>1268173462</LastReviewDate>
−
<LastReviewIntro>
I love this store. No matter what it is i am looking for weather it is some thing i remember from my child hood or some thing i saw in a magazine and i need it i know i can find it there. Yes they are a little rough around the edges but that is only because they are trying to get it across to you what will work and what will not. This is an old school store with people who know their stuff and are only trying to help you get the best end result possible. I am 46 years old and i took my class from Barbara when i first came out of high school and believe me she will not try to up sale you or tell you some thing is going to work if it will not. Go in expecting to be overwhelmed by stock and know you are going to get the best prices in town. Take the time to get to know the employees and the store and you will always go back to Paulines. I travel all the way from Livermore to get stuff i know i can only find there. Thanks for all your many years of being in business
</LastReviewIntro>
</Rating>
<Distance>9.52</Distance>
−
<Url>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1093+Malone+Rd+San+Jose+CA&gid1=21619987
</MapUrl>
−
<Categories>
<Category id="96928859">Wedding Supplies & Services</Category>
</Categories>
</Result>
−
<Result id="21602089">
<Title>Carey David Incorporated</Title>
<Address>1624 Remuda Ln</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 453-7843</Phone>
<Latitude>37.372385</Latitude>
<Longitude>-121.908305</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1624+Remuda+Ln+San+Jose+CA&gid1=21602089
</MapUrl>
<BusinessUrl>http://dc-enterprises.com/</BusinessUrl>
<BusinessClickUrl>http://dc-enterprises.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928508">Clothing Wholesalers</Category>
<Category id="96928509">Clothing Manufacturers</Category>
<Category id="96931030">Apparel Manufacturing</Category>
</Categories>
</Result>
−
<Result id="30246475">
<Title>Royal Casino Parties</Title>
<Address>943 Berryessa Rd, #6</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 213-0904</Phone>
<Latitude>37.363563</Latitude>
<Longitude>-121.886341</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.71</Distance>
−
<Url>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=943+Berryessa+Rd%2C+%236+San+Jose+CA&gid1=30246475
</MapUrl>
<BusinessUrl>http://www.royalcasinoparties.com/</BusinessUrl>
<BusinessClickUrl>http://www.royalcasinoparties.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96930362">Gambling</Category>
</Categories>
</Result>
−
<Result id="25247620">
<Title>Bay Casino Gaming, Casino Party Rentals</Title>
<Address/>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 747-1977</Phone>
<Latitude>37.338475</Latitude>
<Longitude>-121.885794</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>6.44</Distance>
−
<Url>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=+San+Jose+CA&gid1=25247620
</MapUrl>
<BusinessUrl>http://www.baycasinogaming.com/</BusinessUrl>
<BusinessClickUrl>http://www.baycasinogaming.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96925814">Party Rentals</Category>
</Categories>
</Result>
</ResultSet>