Hi I’m currently being asked by one of my clients if it’s possible to have a page where a member of there staff can fill out rota’s in a form and the information will send to an individual page depending on the employee selected in the drop down menu?
Any help guys?
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
have a page where a member of there staff can fill out rota’s in a form and the information will send to an individual page depending on the employee selected in the drop down menu?
Yes it is doable but you would need to write a form handler to gather the info and display it.
What is the ultimate aim? Unless you store the information somehow it will be lost when you leave the page.
If you can give us more info then we can help.
However the most likely scenario is that user 1 submits data to a database where it creates a record. Employee 1 visits his web page where the data is displayed from the database.
But more info will help us flesh it out. Also useful to know user ability level.
David
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Hi David, thanks for response.
The ultimate aim is for the hr team of the company to enter rota’s online and then employees can view online.
How would a form handler work, normally I am only working with the graphic side of things, not brilliant with code but have worked with a little before, nothing complex. The information of the rota needs to be saved unless new data is submitted (in other words the next set of rota’s)
If you need more info I’ll try my best to answer in more detail.
I have access to My SQL databases also.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
I have access to My SQL databases also.
That is where you need to be.
A page that writes info to a MySql database and a page that displays the info from the database.
Not so much a form handler as data input.
The next question I would be asking is - is there a requirement for restricted access to a particular employees rota, or can anyone see it?
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
I would like it to be restricted but I know there we are getting into quite complicated place so if necessary I would use password protected directories to protect the pages.
The only thing with doing this is it would need coding correct? Is there anyway of doing it without code? If not do you know if there is a place to get such a code? Or Action.
Jack
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
What you are describing is a program, which would need to be written. The thing about a database and password protection is that you can’t really use a password-protected folder scheme for this sort of thing, because everyone sees the same page, just with different data. For example:
rotas/index.php
rotas/rota.php?id=1234
rotas/rota.php?id=2345
Those are each “views” into a data set. As you can see, they are all in the same folder (rotas) and so you would have one password for the whole thing, even though the latter two are specific to a person or team, and wouldn’t necessarily be shared by all people who had the password for the folder.
To do this properly, you would have two database tables: people and rotas, and you would probably have a third “linking” table between them, something like people_rotas, which would allow you to designate who can see which rotas. Your admin users would be allowed (by virtue of a flag on their user account) to see the admin pages, where they could set up the schedules, and then they would also be able to assign individual regular users to their specific schedule. The regular users would log in, and would only see the things they were supposed to see by virtue of that lookup table. The rest of the list just wouldn’t appear to them.
Walter
On Aug 4, 2014, at 4:38 PM, Jack wrote:
I would like it to be restricted but I know there we are getting into quite complicated place so if necessary I would use password protected directories to protect the pages.
The only thing with doing this is it would need coding correct? Is there anyway of doing it without code? If not do you know if there is a place to get such a code? Or Action.
Jack
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
The thing about a database and password protection is that you can’t really use a password-protected folder scheme for this sort of thing, because everyone sees the same page, just with different data.
One way round this would be to hard-code each individual employees page so that it only requests that employees data. That way they could be in individual employee, password protected folders.
It is more work to do and to maintain but it is doable.
But no matter what you are going to have to write some code and set up a MySql database.
It is a job that wouldn’t take an experienced programmer much time and the cost of which you would build into your quote.
Your client doesn’t expect it for nothing - I hope.
If you want to have a go yourself then something like phpMyEdit can make it easier - http://www.phpmyedit.org/
D
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Thanks all for your replies I’ll look into this more and comment back with any more questions, David thanks and I hope they don’t want it for free too…
Thanks Walter that made someones quite clear and has given me some direction.
As I say I’ll look more into it and let you know.
Jack
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options