CODEWITHSUNDEEP
phpmysql
Patrioticcow
Patrioticcow

Reputation: 27048

php, how to get the keywords out of an url?

the question might be a bit confusing, so here is what i have:

i insert in the database the previous link where a person came from like tihs:

$came_from = $_SERVER['HTTP_REFERER']; // get previous link

if the link is from google.com it will come like this:

http://www.google.com/#sclient=psy&hl=en&source=hp&q=this+is+a+test&pbx=1&oq=this+is+a+teat&aq=f&aqi=g-s1g-v1&aql=1&gs_sm=s&gs_upl=887l82702l3.10.3.1l17l0&bav=on.2,or.r_gc.r_pw.r_cp.&fp=c3d3303&biw=1920&bih=995

if we look inside we can find q=this+is+a+testas beeing the keywords that i search for.

my question is how can i create a query to return http://www.google.com/ | this+is+a+test ?

i know that the keywords have the + sign in between them.

so far i came up with this, but not exactly what i wanted:

SELECT SUBSTRING_INDEX (table, '+', 1), table FROM table.table WHERE table LIKE '%+%' LIMIT 20

any ideas?

thanks

edit: what happend is that sometimes i get some other url's that don't have q= but maybe seearch=, so i want to keep track of the + sign

Upvotes: 0

Views: 207

Answers (3)

NullUserException
NullUserException

Reputation: 85468

As it's been pointed out, you can't reliably get the keywords without supplying the parameters to look for. Here's what I would do:

$url = 'http://www.google.com/#sclient=psy&hl=en&source=hp&q=this+is+a+test&pbx=1&oq=this+is+a+teat&aq=f&aqi=g-s1g-v1&aql=1&gs_sm=s&gs_upl=887l82702l3.10.3.1l17l0&bav=on.2,or.r_gc.r_pw.r_cp.&fp=c3d3303&biw=1920&bih=995';

$possible = array('q', 'ssearch', 'oq');

$query_str = NULL;
foreach ($possible as $search) {
    if (isset($arr[$search])) {
        $query_str = $arr[$search];
        break;
    }
}

Basically all this does is parse the url using PHP's parse_str() and look for the parameter q. If it's not there, it uses ssearch, and then oq. You can add more of them if you need to. If by the end of it it's not found, $query_str will be NULL.

Unless you have a very compelling reason to do it with MySQL only, just process everything on the PHP side. Databases are made to store data, not process it. What I would do is have PHP figure out the search engine and the keywords used and insert those into the DB, as separate fields. ie, have a table like so:

search_engine | query_str
------------- | -----------
google        | test
yahoo         | something
...

Upvotes: 2

bfavaretto
bfavaretto

Reputation: 71918

As everyone is saying, you need to use the key value (in your example, q). In MySQL, you can do something like this:

SELECT SUBSTRING_INDEX(table, '?q=', -1), table FROM table.table WHERE table LIKE '?' LIMIT 20

I'd also suggest you rename your table column to something other than 'table'.

Upvotes: 0

Igoris
Igoris

Reputation: 1650

If you know that you need q=... then you can use regexp. I will update post if that's what you need.

Upvotes: 0

Related Questions