[SOLVED] Inserting values into mySQL on page load rather than submit button?

webmaster1 · November 27, 2008

Hi All,

(apologies for the fractional threads)

I have a page (invalid.php) that basically echoes an error message.

In the background I want to write the IP address and date to insert into a mySQL table every time the page loads rather than when a submit button is clicked.

How would I trigger this based on the below snippet of code:

$ipaddress = getenv('REMOTE_ADDR');

query = "INSERT INTO invalid VALUES ('','$ipaddress',NOW())";
mysql_query($query);

trq · November 27, 2008

Um, that snippet of code will do exactly what your asking for each time it is loaded.

Jahren · November 27, 2008

<?php

$ipaddress = getenv('REMOTE_ADDR');

query = "INSERT INTO invalid VALUES ('','$ipaddress',NOW())";
   mysql_query($query);

?>

<html>
etc...

webmaster1 · November 27, 2008

D'oh! :-[

Thanks guys.

I always make the assumption that "nah, it could never be that simple."

I geuess if theres no if condition and all the variables are attainable then it just does its thing.

Sign In

[SOLVED] Inserting values into mySQL on page load rather than submit button?

Recommended Posts

webmaster1

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

Jahren

Link to comment

Share on other sites

webmaster1

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information