I was needing a way that my customers could securely update their credit card information, so I created a simple php form, using an include for the connection (that I put in the cgi-bin, so it couldn't be seen), that would post their new info into a database. Now what I am wanting is a way to know when someone has posted to the database, so that I can hurry up and get the information out before it is potentiall hacked into. Is there a way to either have the same form that is posting to the database, email me a notification, or a way that the database can alert me, which I don't see how that would be possible. I have included the code for the page that the form posts to.
Code: Select all
$sqlquery = "INSERT INTO creditcards
$results = mysql_query($sqlquery);
print "Thank you for updating the credit card information for $domain.";