Moderation by Captcha Primer Tutorial

Moderation by Captcha Primer Tutorial

Moderation by Captcha Primer Tutorial

In our “onions of the 4th dimension” world we have an onion layer of thought today regarding “moderation”.

Let me just quietly ask? Are you a robot? Mr Turing posed this very fundamental question some time back. But the fact is, a lot of visitors to just about everybody’s website are robots (shock! … horror!), else how else would Search Engines get updated information, but to “crawl” your website (as I say this, forgot to say how blogs like WordPress ping Search Engines), man person.

And just to get in (really) early (with the way modern technology is shaping) … “Not that there’s anything wrong with being a robot” (if only Seinfeld had watched Humans … Jerry?! George?!).

So let’s talk about CAPTCHA, which we have not capitalized in the blog title, because we hate shouting too much here. It is a way to try to verify the web application is dealing with a real human being, as we intimated above. As such, you may want to consider it a replacement for “moderation”, but this is not advisable, because, alas, not all the nasty stuff on the net can be attributed to robots … far from it. But it is a good idea up to a point. My personal objection to its use revolves around the disturbance of usage for some disabled users, though am sure there are really sophisticated CAPTCHA plugins for all the scenarios out there.

Today’s work places a CAPTCHA layer on top of all four previously talked about modes of “moderation”, as per …

  • no moderation … even this needs a server side language, in our eyes, because you will be changing a server side webpage for all users
  • email (or sms or voicemail or any direct communication method) moderation … ask for an admin user of the website to change things after having emailed them … this is the one we showed three days back … and please feel free to try your own entries
  • moderate via a (web server) database with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted” … this is the one we showed yesterday … and, yet again, please feel free to try your own entries
  • moderate via a system of (web server) files with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted” … this is the one we showed two days back … and, again, please feel free to try your own entries
  • only moderate to either of the four above after having gone through a CAPTCHA test that the user is not a robot … this is the one we show today

To get the PHP CAPTCHA functionality going we thank this very useful link from “The Art of Web” website. Its precise and clever advice creates the imagery required to present a CAPTCHA image to the user that contains five digits for the user to enter to verify to the web application that they are human. The web application CAPTCHA logic is applied to all the method=POST forms used (and a new form was encased around the “private moderation” (ie. no moderation) case) via the HTML form’s …

... onsubmit="return checkForm(this);" ...

… validation method.

So, for the last time, today, we pose the idea that the “Things That We Have in Common” far outweigh the things that divide us, and present some ideas here. We offer, and encourage you to email us your ideas on the topic or use the file moderation method, and we’ll moderate them within 24 hours. With today’s file moderation method you are given the opportunity to login and “moderate” your own work but as you will recall from yesterday with …

CAPTCHA does not affect user roles going forward. In all these scenarios we present, where we don’t ask anything of you (ie. no registration), except an email address, presumably, you can be thought of as a …

  • “guest” user … though in strict terms the word “guest” usually implies that there is a user registration involved … which we do not do here today … but to read a bit about this you could read PHP Membership Website Primer Tutorial … as distinct from …
  • the emailee of the “guest” user will be an “admin” user … one who can offer the means to moderate the uploaded data, and, as approved, write that data to a place where it will be picked up and included in the contents of the webpage(s) involved … hence the term “Content Management System”

… you, as a “guest” user will not succeed with this “admin” user login to “moderate”, but the mechanism is there for real “admin” users, as is a “get” parameter method like our “?admin=y” idea, with most blogs and CMS websites.

Here is the downloadable PHP code you could call moderation_captcha.php with its live run and changed from yesterday’s work this way.

Here is the login PHP code for the admin section you could call login.php with its admin user useful live run, unchanged from yesterday.

Here is the PHP code login(.php) uses to connect to the MySql database you could call db_connect.php unchanged from yesterday.

Here is the member PHP code that follows the login(.php) page you could call member.php that handles, so far, the “business logic” for file moderation as of yesterday and the admin user follow up to reading the email and approving the email moderation, of two days back, as well as today’s extended MySql database functionality, is not needing to change from yesterday’s work regarding CAPTCHA.


Previous relevant Moderation by MySql Database Primer Tutorial is shown below.

Moderation by MySql Database Primer Tutorial

Moderation by MySql Database Primer Tutorial

Today’s the day we tackle some database “moderation” ideas. You will recall from yesterday’s Moderation by File Primer Tutorial as shown below, that “moderation” is associated with blogs and Content Management Systems and social media as a means by which uploaded content can be vetted, or not, during a “moderation phase” for a posting of some sort.

This can involve, in our eyes, quite a few options, none of which would not involve a server-side solution of some sort …

  • no moderation … even this needs a server side language, in our eyes, because you will be changing a server side webpage for all users
  • email (or sms or voicemail or any direct communication method) moderation … ask for an admin user of the website to change things after having emailed them … this is the one we showed two days back … and please feel free to try your own entries
  • moderate via a (web server) database with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted” … this is the one we show today … and, yet again, please feel free to try your own entries
  • moderate via a system of (web server) files with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted” … this is the one we showed yesterday … and, again, please feel free to try your own entries
  • only moderate to either of the four above after having gone through a CAPTCHA test that the user is not a robot

So today we are still here posing the idea that the “Things That We Have in Common” far outweigh the things that divide us, and present some ideas here. We offer, and encourage you to email us your ideas on the topic or use the file moderation method, and we’ll moderate them within 24 hours. With today’s file moderation method you are given the opportunity to login and “moderate” your own work but as you will recall from yesterday with …

The major lesson today, for us, is to show you the brilliance of phpMyAdmin as the administrator back-end to a MySql database. Some of the great features of phpMyAdmin we used to get to this point are …

  • phpMyAdmin’s great ability to export (to SQL, most usefully) the structure, in terms of “CREATE TABLE” type SQL and/or data of existant database tables as a useful way to help design your own new database tables
  • phpMyAdmin’s ease of use of the usual DML SQL functionality
  • phpMyAdmin’s ease of use of the usual DDL SQL functionality for the creation of users and the granting or denial of user priviledges, and drop and truncate functionalities

We still have the two basic web user roles going today. In this scenario, where we don’t ask anything of you (ie. no registration), except an email address, presumably, you can be thought of as a …

  • “guest” user … though in strict terms the word “guest” usually implies that there is a user registration involved … which we do not do here today … but to read a bit about this you could read PHP Membership Website Primer Tutorial … as distinct from …
  • the emailee of the “guest” user will be an “admin” user … one who can offer the means to moderate the uploaded data, and, as approved, write that data to a place where it will be picked up and included in the contents of the webpage(s) involved … hence the term “Content Management System”

… you, as a “guest” user will not succeed with this “admin” user login to “moderate”, but the mechanism is there for real “admin” users, as is a “get” parameter method like our “?admin=y” idea, with most blogs and CMS websites.

You will recall yesterday that ideas from PHP Membership Website Primer Tutorial came into play with the use of web server files and today its functionality is even more important with some MySql database work to follow up on phpMyAdmin database setup preparation. It screens “admin” users from the rest, ensuring you can write your fully functional database PHP free in the knowledge that the user is logged in as an “admin” user.

Here is the downloadable PHP code you could call moderation.php with its live run and changed from yesterday’s work this way.

Here is the login PHP code for the admin section you could call login.php with its admin user useful live run, unchanged from yesterday.

Here is the PHP code login(.php) uses to connect to the MySql database you could call db_connect.php unchanged from yesterday.

Here is the member PHP code that follows the login(.php) page you could call member.php that handles, so far, the “business logic” for file moderation as of yesterday and the admin user follow up to reading the email and approving the email moderation, of two days back, as well as today’s extended MySql database functionality, is changed from yesterday’s work this way.


Previous relevant Moderation by File Primer Tutorial is shown below.

Moderation by File Primer Tutorial

Moderation by File Primer Tutorial

We continue on with “moderation” ideas today, as with WordPress 4.1.1’s Moderation by File Primer Tutorial. You will recall from yesterday’s Moderation by Email Primer Tutorial as shown below, that “moderation” is associated with blogs and Content Management Systems and social media as a means by which uploaded content can be vetted, or not, during a “moderation phase” for a posting of some sort.

This can involve, in our eyes, quite a few options, none of which would not involve a server-side solution of some sort …

  • no moderation … even this needs a server side language, in our eyes, because you will be changing a server side webpage for all users
  • email (or sms or voicemail or any direct communication method) moderation … ask for an admin user of the website to change things after having emailed them … this is the one we showed yesterday … and please feel free to try your own entries
  • moderate via a (web server) database with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted”
  • moderate via a system of (web server) files with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted” … this is the one we show today … and, again, please feel free to try your own entries
  • only moderate to either of the four above after having gone through a CAPTCHA test that the user is not a robot

So today we continue to pose the idea that the “Things That We Have in Common” far outweigh the things that divide us, and present some ideas here. We offer, and encourage you to email us your ideas on the topic or use the file moderation method, and we’ll moderate them within 24 hours. With today’s file moderation method you are given the opportunity to login and “moderate” your own work but as you will recall from yesterday with …

This brings up the topic of web user roles. In this scenario, where we don’t ask anything of you, except an email address, presumably, you can be thought of as a …

  • “guest” user … though in strict terms the word “guest” usually implies that there is a user registration involved … which we do not do here today … but to read a bit about this you could read PHP Membership Website Primer Tutorial … as distinct from …
  • the emailee of the “guest” user will be an “admin” user … one who can offer the means to moderate the uploaded data, and, as approved, write that data to a place where it will be picked up and included in the contents of the webpage(s) involved … hence the term “Content Management System”

… you, as a “guest” user will not succeed with this “admin” user login to “moderate”, but the mechanism is there for real “admin” users, as is a “get” parameter method like our “?admin=y” idea, with most blogs and CMS websites.

The reason we didn’t need these PHP Membership Website Primer Tutorial ideas yesterday was that no web server files had to be written at that stage, but today they do, and we can’t let any “guest” user do it, so we find that MySql database work via the wonderful and enormously stupendous phpMyAdmin comes into play, and we’ll talk more about this tomorrow, when databases are used for all aspects of our final “moderation” via database discussion.

Here is the downloadable PHP code you could call moderation.php with its live run and changed from yesterday’s work this way.

Here is the login PHP code for the admin section you could call login.php with its admin user useful live run.

Here is the PHP code login(.php) uses to connect to the MySql database you could call db_connect.php

Here is the member PHP code that follows the login(.php) page you could call member.php that handles, so far, the “business logic” for file moderation and the admin user follow up to reading the email and approving the email moderation, of yesterday.


Previous relevant Moderation by Email Primer Tutorial is shown below.

Moderation by Email Primer Tutorial

Moderation by Email Primer Tutorial

The term “moderation” is associated with blogs and Content Management Systems and social media as a means by which uploaded content can be vetted, or not, during a “moderation phase” for a posting of some sort.

This can involve, in our eyes, quite a few options, none of which would not involve a server-side solution of some sort. We’ll think on this further (maybe Ajax?!), but some of the ideas for moderation would be …

  • no moderation … even this needs a server side language, in our eyes, because you will be changing a server side webpage for all users
  • email (or sms or voicemail or any direct communication method) moderation … ask for an admin user of the website to change things after having emailed them … this is the one we show today … and please feel free to try your own entries
  • moderate via a (web server) database with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted”
  • moderate via a system of (web server) files with posting statuses such as “Awaiting Moderation”, “Published”, “To Be Deleted”
  • only moderate to either of the four above after having gone through a CAPTCHA test that the user is not a robot

So today we pose the idea that the “Things That We Have in Common” far outweigh the things that divide us, and present some ideas here. We offer, and encourage you to email us your ideas on the topic, and we’ll moderate them within 24 hours. The mechanism, today, is via you, the user, sending us here, at RJM Programming, an email.

This brings up the topic of web user roles. In this scenario, where we don’t ask anything of you, except an email address, presumably, you can be thought of as a …

  • “guest” user … though in strict terms the word “guest” usually implies that there is a user registration involved … which we do not do here today … but to read a bit about this you could read PHP Membership Website Primer Tutorial … as distinct from …
  • the emailee of the “guest” user will be an “admin” user … one who can offer the means to moderate the uploaded data, and, as approved, write that data to a place where it will be picked up and included in the contents of the webpage(s) involved … hence the term “Content Management System”

… and so, in the scenario of “no moderation” “guest” users circumvent the moderation part of the “admin” user role and, in some automated (programming) way, with a language like PHP and a database like MySql, be able to get their uploaded content straight onto the webpage(s) of interest. So, sometimes you see “no moderation” but a CAPTCHA (robot) check, as the scenario of use.

Of interest, too, is the nature of the uploaded data. Is it “just text” or “can it contain images” or “can it contain videos” etcetera. Today, we are just allowing text.

Here is the downloadable PHP code you could call moderation.php with its live run.

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

This entry was posted in Database, eLearning, Event-Driven Programming, Networking, Tutorials and tagged , , , , , , , , , , , , , , , . Bookmark the permalink.

41 Responses to Moderation by Captcha Primer Tutorial

  1. Simply wanna say that this is invaluable , Thanks for taking your time to write this.

  2. Max says:

    Cześć, ciekawy wpis. Dawno nie słuchałem tak interesującego pisarstwa.

  3. excellent issues altogether, you just won a logo new reader. What may you suggest about your put up that you made a few days in the past? Any positive?

  4. Car Interior says:

    Thanks for every other informative website. Where else may just I get that kind of info written in such an ideal way? I have a undertaking that I’m just now operating on, and I’ve been on the glance out for such info.

  5. It is hard to uncover knowledgeable men and women on this topic even so you sound like you know what you are talking about! Thanks

  6. interested says:

    Absolutely indited subject material, thanks for entropy. “No human thing is of serious importance.” by Plato.

  7. I simply wanted to thank you so much once more. I am not sure the things I could possibly have handled in the absence of those tips and hints discussed by you directly on that theme. Previously it was a very hard problem for me, but understanding the very professional tactic you solved it took me to weep over delight. Extremely grateful for your service and even believe you comprehend what an amazing job that you are providing instructing others through your site. I am certain you have never come across all of us.

  8. Education says:

    I¡¦ve recently started a website, the information you offer on this website has helped me tremendously. Thank you for all of your time & work.

  9. Healthy Life says:

    I have recently started a web site, the information you provide on this web site has helped me tremendously. Thanks for all of your time & work.

  10. Insurance says:

    hello!,I love your writing very much! percentage we keep in touch more about your article on AOL? I require an expert on this space to resolve my problem. Maybe that’s you! Taking a look ahead to look you.

  11. I concur, this internet site is really interesting and we obtained a suggestion of this certain topic. I never thought that I could possibly locate this internet site. I would like to use this in my life. Many thanks for this as well as wish you will create more like this one.

  12. Carpet Tiles says:

    I simply wanted to post a brief message to be able to express gratitude to you for these wonderful suggestions you are giving at this site. My incredibly long internet search has at the end been recognized with extremely good facts and strategies to talk about with my two friends. I would say that most of us website visitors are unquestionably blessed to be in a magnificent community with so many outstanding individuals with insightful things. I feel pretty privileged to have come across the website and look forward to tons of more excellent times reading here. Thank you once again for everything.

  13. Stockmarket says:

    Wow! Thank you! I continually needed to write on my website something like that. Can I include a fragment of your post to my website?

  14. Garden Ideas says:

    Usually I don’t learn post on blogs, however I wish to say that this write-up very pressured me to try and do it! Your writing taste has been surprised me. Thank you, quite nice post.

  15. Will says:

    It’s the best time to make some plans for the long run and
    it’s time to be happy. I’ve learn this submit and if I may I want to counsel you some fascinating things or advice.
    Perhaps you can write next articles relating to this article.

    I desire to read more things approximately it!

  16. When I saw this page was like wow. Thanks for putting your effort in publishing this write-up.

  17. car gadgets says:

    Awsome article and right to the point. I am not sure if this is truly the best place to ask but do you guys have any thoughts on where to hire some professional writers? Thx :)

  18. Hello my loved one! I wish to say that this post is awesome, great written and come with almost all vital infos. I¡¦d like to look more posts like this .

  19. I simply wished to appreciate you once again. I do not know the things that I might have achieved without the tricks contributed by you directly on my situation. It seemed to be a real alarming setting in my position, nevertheless considering a new specialized form you managed it forced me to cry over happiness. Now i am grateful for this work and have high hopes you recognize what an amazing job you’re doing educating many people via your web page. Most likely you’ve never encountered all of us.

  20. perfect says:

    Wonderful views you’ve got here.. Isn’t it good when you find an excellent article? Love the post you delivered.. certainly, research is paying off.

  21. Love the admission you made available.. certainly, study is having to pay off. Supporting the contribution.. thanks a lot Liking the write-up.. thanks a bunch

  22. Ray Doshi says:

    I’ve recently started a web site, the info you offer on this website has helped me greatly. Thanks for all of your time & work. “The achievements of an organization are the results of the combined effort of each individual.” by Vince Lombardi.

  23. sex novinha says:

    Thank your for share. I hope you are going to share once again.

  24. Oh my goodness! a fantastic post dude. Thank you Even so I will probably be experiencing problem with ur rss . Don’t know why Can not subscribe to it. Will there be any person getting identical rss dilemma? Anybody who knows kindly respond. Thnkx

  25. right says:

    I wanted to construct a small comment in order to appreciate you for those marvelous guides you are showing at this website. My incredibly long internet search has now been paid with useful strategies to exchange with my family. I ‘d repeat that many of us visitors actually are undoubtedly fortunate to live in a remarkable community with so many marvellous people with valuable strategies. I feel rather lucky to have come across your web page and look forward to some more amazing times reading here. Thanks a lot once more for all the details.

  26. growing says:

    Wow! Thank you! I continually needed to write on my site something like that. Can I implement a fragment of your post to my blog?

  27. loving says:

    Wonderful thought processes you might have here.. yes, research is having to pay off. Supporting the weblog.. thanks a lot My personal web surfing seem total.. thanks.

  28. Glowing says:

    I appreciate you writing your perspective.. Incredibly practical standpoint, appreciate your sharing.. sure, study is having to pay off. I value you revealing your point of view..

  29. เสือ says:

    amazing post, extremely informative. I wonder why the other experts of this sector do not notice this. You should continue your writing. I’m sure, you’ve a terrific readers’ base already!

  30. satisfied says:

    Truly appreciate the posting you furnished.. Extremely interesting outlook, appreciate your expression.. My personal web browsings seem total.. thanks. I appreciate you posting your point of view..

  31. camera says:

    whoah this blog is fantastic i love studying your articles. Keep up the good work! You understand, many individuals are hunting around for this information, you can help them greatly.

  32. my website says:

    Hi there, i just thought i would publish and now let you know your sites style is truly smudged within the K-Melon browser. Anyhow sustain within the extremely very good function.

  33. Healthy Life says:

    Well I sincerely liked studying it. This article provided by you is very practical for correct planning.

  34. Healthy Life says:

    excellent points altogether, you simply received a new reader. What could you recommend in regards to your submit that you just made some days ago? Any certain?

  35. An outstanding share! I’ve just forwarded this onto a coworker who was conducting a little homework on this. And he actually ordered me dinner simply because I found it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanks for spending the time to talk about this matter here on your blog.|

  36. Thanks for another fantastic post. Where else could anyone get that type of info in such a perfect means of writing? I’ve a presentation subsequent week, and I’m on the search for such information.

  37. Phyllis Ripa says:

    Very interesting points you have noted , thankyou for putting up. “Above all be true to yourself, and if you can not put your heart in it, take yourself out of it.” by Hardy D. Jackson.

  38. I was examining some of your content on this website and I think this internet site is really informative ! Retain posting .

  39. Ozell says:

    Simply put, just how do i look for blog sites that fit what I want to review? Does anyone understand just how to BROWSE through blogs by subject or whatever on blog writer?.

  40. I will begin a blog site. Together with many other hopeful’s, I intend to at some point generate income off it. I observed a lot of websites do not allow you to make money of google advertisement feeling and also things like that. What are some sites I can start my blog site on that particular will enable this given that it appears to be the most rewarding means to generate income off a blog site?.

  41. Kaye says:

    How come Firefox displays a weird character when it should show a word?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>