SQL Front End and form quotas - Post...

User 416466 Photo


Registered User
23 posts

Hi,
I wonder if someone might be able to help me please.

A client wants forms to go to a MySQL database and for the number of forms received in a day to be restricted. They want to receive an email when a form is submitted but this is simply to inform them of that fact. They don't want any of the form content to be sent over email.

Questions:
    How do I set up a front end for the database, for the client to access the information, probably from within WordPress? I am familiar with WordPress but my knowledge of databases and php is extremely limited.
    I know quotas can be set on a form, via the database, but is it possible to set that limit over several forms, so that when, say, 5 of one, 2 of another and 3 of yet another have been completed, all forms display a message like "quota reached for today"?
    With input going to MySQL, can an email go out to purely advise that a form has been submitted?

I know this is more of a question about MySQL than Web Form Builder but I thought someone may have had the need to set up something similar.

There are some very knowledgeable people on this forum and any assistance would be much appreciated.

Many thanks,
Joy
User 187934 Photo


Senior Advisor
20,271 posts
Online Now

Hi JR,
How much data is there to display?
Give this a try.

calendar-table.zip
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.