Capturing input from a form

Sending input from a form to two different places

[ProductivePC]

I currently have a search form on my website. When you type something in, it redirects you to a page that displays the results. I would also like the users searches to get input into an access database at the same time.

How would I do this?

Thanks for any help.

Wayne

[WhosAWhata]

add something in the page that displays the results

[ProductivePC]

what?

I want to log what the user types into my website search box in an access database. I looked on PHP.net for a command that would do this hwoever could not find one. Does anyone know how I would accomplish this?

[mykel79]

The action="..." part of the form would have to point to your script. The script would input the search string into database, and then redirect to the search page.
As for databases, the most common combination with PHP i mySQL (also free licence).

[ProductivePC]

Thanks.... I wil give that a try.... I have never worked with MySql but there is never a time like the present to learn. :-)

[brucec]

Yes, you can do this in one PHP script. The script will display everything in an echo command and then connect to the MySQL database and do an UPDATE or INSERT command.

I do this now on our ecommerce web site to track hits everytime a customer view the product details.