I created a Guestbook using PHP & MySQL on my website fdiengdoh.com from scratch but after about a few months my site got lots of useless spam post. So, first I manually deleted the post. This process become tiresome so I googled for spam checker and stumbled upon reCAPTCHA, its a free service, so I implemented that. I got quite a reduced numbers of spam after that.

But nowadays, even after implementing reCAPTCHA also I still get lots of spam. It seem now people are spending time online to just post useless stuff on other site. Then I changed my Guestbook into a moderated Guestbook, so every post is moderated before they appear online. Its better, but I still get like 100 spam post per week.

Is there a way where I can check if the post contain 2 or more url link, then I should reject it right away. can someone show me a way to do that.

A: don't call it guestbook

B: Why the hell do you have a "guestbook" they died out in 1995!!!!

Ah I remember the days of guestbooks... haven't seen one of those in YEARS!

Originally Posted by chrishirst

B: Why the hell do you have a "guestbook" they died out in 1995!!!!

This made me lol.

The quick and dirty way would be to just count the number of instances of the string 'http://' and 'https://' (or you could just count ://)

http://php.net/manual/en/function.substr-count.php


Now that that is settled, can someone tell me how to setup a hit counter on my geocities page? Also, I'm trying to find a dancing Jesus gif but alta vista seems to be down.

I've got a rotating 'e' in a delightful shade of blue that I no longer need,

Genuine mileage, one careful owner.

B: Why the hell do you have a "guestbook" they died out in 1995!!!!

Yea, that's coz its the first PHP program that I wrote from scratch just after learning PHP, so kinda attached to me. I do have a different site with comments System created by me from scratch.

Well since underneath they (Gbook/comment) are still the same, i.e. I took the input from form and then populate the database and display those data in form of comments/guestbook. Well both suffer the same spam problems.

The quick and dirty way would be to just count the number of instances of the string 'http://' and 'https://' (or you could just count ://)

Thanks for the link, I'm not so expert in PHP, I've learned many things but still lots to be learned.