Getting Keyword

[joefox]

I have a few questions.

I have a script that searches the database for a zip code and displays the matching results of names etc.

Is there a way i can track what zipcodes are being entered in another database? Also, what other information can i get? How do i get the URL, etc.

On a side note.

I use google adwords to get traffic to my sites, is there a way to get the keyword that was used to get to my site?
Maybe put some type of code in the index.html file?

Thanks for all your help.

[dclamp]

From your previous script we were working with i added some stuff to store the searches:

<form action="#" method="POST">
    <input type="text" name="zipcode">
    <input type="submit" name="Search">
</form>
<br><br><br>
<?php
if(isset($_POST['zipcode'])){
    require_once ('connect.php');
    require_once ('opendb.php');
    
    $zipcode = $_POST['zipcode'];
    $ip = $_SERVER['REMOTE_ADDR'];
    
    $query = "INSERT INTO `searched_zips` SET `zip`='$zipcode', `ip`='$ip'";
    $result = mysql_query($query);
    
    $query = "SELECT * FROM search_data WHERE zipcode='$zipcode'";
    $result = mysql_query ($query);
    $count = mysql_num_rows($result); //number of results
    
    if ($count == 0){
        echo "Nothing";
    } else if($count == 1){
        echo "REDIRECT";
    } else{
        echo "Located $count result(s).<br /><br />\n";
        while($row = mysql_fetch_array($result)){
            echo "<p>" . $row['zipcode'] . '<br>' . $row['company_name'] . '<br>' . $row['redirect_url'] . '<br>' . $row['notes_1'] . '</p>';
        } 
    }
} else {
    echo "Please Use Search Form Above!";
}
?>

[dclamp]

As for your side note:

Most search engines use the GET method for their searches, so it would be something like:

http://www.google.com/search?q=MY+SEARCH

Thats Google's url.

To determine how the user got to your site you need the url they came from:

$url = $_SERVER['HTTP_REFERER']; 

I am not quite sure how to explode it to get the base URL or the query.

[joefox]

From your previous script we were working with i added some stuff to store the searches:

<form action="#" method="POST">
    <input type="text" name="zipcode">
    <input type="submit" name="Search">
</form>
<br><br><br>
<?php
if(isset($_POST['zipcode'])){
    require_once ('connect.php');
    require_once ('opendb.php');
    
    $zipcode = $_POST['zipcode'];
    $ip = $_SERVER['REMOTE_ADDR'];
    
    $query = "INSERT INTO `searched_zips` SET `zip`='$zipcode', `ip`='$ip'";
    $result = mysql_query($query);
    
    $query = "SELECT * FROM search_data WHERE zipcode='$zipcode'";
    $result = mysql_query ($query);
    $count = mysql_num_rows($result); //number of results
    
    if ($count == 0){
        echo "Nothing";
    } else if($count == 1){
        echo "REDIRECT";
    } else{
        echo "Located $count result(s).<br /><br />\n";
        while($row = mysql_fetch_array($result)){
            echo "<p>" . $row['zipcode'] . '<br>' . $row['company_name'] . '<br>' . $row['redirect_url'] . '<br>' . $row['notes_1'] . '</p>';
        } 
    }
} else {
    echo "Please Use Search Form Above!";
}
?>

How do i enter the time and date at the same time as the searched zip is being entered into the database?

[dclamp]

date(); 

[kows]

$query = "INSERT INTO `searched_zips` SET `zip`='$zipcode', `ip`='$ip'"; 

that's wrong. an insert query does not have the same syntax as an update query.

INSERT INTO table (field1, field2, field3) VALUES('value1', 'value2', 'value3');

to insert a date, just save the date and insert it as well. I don't understand the question, unless you just don't know how to make a date. look up the date() function, if so.

[dclamp]

@kows:

I have been using that syntax for my code, and it works fine for me

[kows]

hm, I guess it does. wonder when that happened; as far as I know, it didn't work a few years ago. either way.

also, use parse_url() if you're wanting to break down an HTTP referrer into different segments.

[dclamp]

how would you use parse_url()?. I will check php.net as well

[RudiVisser]

parse_url returns an associative array of the url's details.

print_r(parse_url('http://www.google.com/search?q=MY+SEARCH')); 

Array
(
    [scheme] => http
    [host] => www.google.com
    [path] => /search
    [query] => q=MY+SEARCH
)

[dclamp]

ah! that seems simple thanks