2 problems: grab and search

online

Hello all!
I have 2 questions:
1) I have a search (a form like google..press search... index.php?q=the word)
What i must to do to add into a database the words tha have been searched?
For ex.: I search mama, house, net ... and i want to add this word in to the database. Also i want a page to display the last 20 searches.

2) I want to have a file grab.html... and to display the information from a site.
I want to grab the info from the site2.com(starting tag 1 and finishinf to tag2) and to replace some words...

10x

bpat1434

Searching
You would need to set up a table and use PHP to connect to mySQL (research it yourself on www.php.net). Then, you would do something like this:

<?php

$q = $_GET['q'];

$query = "INSERT INTO `table_name` (column_name) VALUES ('$q')";
$result = @mysql_query($query);
if(!$result){
    echo 'mySQL Query Error!! '.mysql_errno().'<br>'.mysql_error();
}

// Do whatever else you want with the search here

Now, displaying it would be best done in a different file, and calling it remotely. The file that lists the last 20 would look like:

<?php
// Gets last 20 searches

// Do database connection junk

// Select all values from the last 20 searches, ordered recent to distant
$query = "SELECT * FROM `table_name` ORDER BY id DESC LIMIT 20";
$result = @mysql_query($query);
if(!$result){
    echo 'The last 20 results can't be attained at this time.  Sorry.';
}
else
{
    while($row = mysql_fetch_array($result)){
        echo $row['search_term_column_name'].'<br>';
    }
}

?>

~Brett

online

10x 🙂

online

How do i display 9using php) the last 20 words that have been add into database?

bpat1434

Basically, like this:

index.php

<html>
  <head>
    <title>My Search Page</title>
  </head>

  <body>
    <!-- Search Function Here -->
    <!-- Below We'll show last 20 words -->
    <?php
    include('showsearch.php');
    echo showLast(20);
    ?>
  </body>
</html>

showsearch.php

<?php

function showLast($num){
    $display = ''; // Empty the display string
    $query = "SELECT * FROM `table_name` ORDER BY id DESC LIMIT $num";
    $result = @mysql_query($query);
    if(!$result){
        $display = "The last 20 results can't be attained at this time.  Sorry.";
    }
    else
    {
        while($row = mysql_fetch_array($result)){
            $display .= $row['search_term_column_name'].'<br>';
        }
    }

return $display; // Send the $display varaiable back
// to the other page.
}

?>

online

Not workink.

Al the time is diplaying: The last 20 results can't be attained at this time. Sorry.

bpat1434

Did you modify the query so that "table_name" is the tables name?

If you have, and it still doesn't work, use the following code:

<?php

function showLast($num){
    $display = ''; // Empty the display string
    $query = "SELECT * FROM `table_name` ORDER BY id DESC LIMIT $num";
    $result = @mysql_query($query);
    if(!$result){
        $display = "The last 20 results can't be attained at this time.  Sorry.<br>".mysql_error();
    }
    else
    {
        while($row = mysql_fetch_array($result)){
            $display .= $row['search_term_column_name'].'<br>';
        }
    }

return $display; // Send the $display varaiable back
// to the other page.
}

?>

~Brett

online

Yes, i modify.
Now, this is the error:
Unknown column 'id' in 'order clause'

This is my table:

CREATE TABLE
search_dir (
word varchar(85) binary NOT NULL default ''
) TYPE=MyISAM;

So... 🙂

10x again for the help 😃

bpat1434

So add an ID column that is an integer(11) with auto_increment and unique ID. Then empty the table.

~Brett

online

It works

bpat1434

Don't forget to mark it resolved

 |
 |
 |
 |
\|/
 v