Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2011
    Posts
    310
    Thanks
    23
    Thanked 0 Times in 0 Posts

    Report or flagging system

    I want to know, how to make a report or flagging system for spam comments?

    Suppose I have a table which is displayed from my database. In the table there are 3 columns, the first for name, the second for comment and the third is a button where a people can click to report as spam. I want to know how I can get the notification in MySQL? I mean how to proceed or what ways I can do it?

  • #2
    Regular Coder Redcoder's Avatar
    Join Date
    May 2012
    Location
    /dev/null
    Posts
    332
    Thanks
    2
    Thanked 47 Times in 46 Posts
    MySQL does not have a spam filter engine if that is what you were asking. But here's what you can do to combat spam combats

    You can make your own spam filter to flag comments containing any of the following WORDS. That's what many spam filters use.

    Or you can just make it that each comment has to be moderated by you. That means you have to code such functionality and a moderating admin panel for that. A lot of large, small and medium sites use this

    If you are using CMS' like Wordpress, Drupal e.t.c, there are a lot of plugins for that.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •