Advnced PHP script for a waiting list

Leon · February 26, 2021, 11:11pm

I hope i post this on the right place, or else i hope the admin will be helpfull to put it in the right section. Thanks

I am in the process of creating a waiting list that I want to work automatically. When a new member registers for membership, the member must be on a waiting list for a while before the member gets permanent membership. When the membership is active, I want this to work so that I can delete the person who is number 1 in the list, and number 2 will be number 1. the remaining numbers in the list will automatically move a number up, such as at no. 5 will be No. 4, etc. Only the name will be displayed in the member list, but the form that the new member submits will have several fields. There are 12 fields to be filled in in the MySQL database, but only the name and surname to be displayed in the list. The position number in the waiting list must be set automatically in front of the name. Is there somebody in here on PHP Help who can help me with this script me the whole PHP script or help me on the way.

phdr · February 26, 2021, 11:56pm

The whole point of programing help forums are to help those attempting to program. We are not here however to do your work for you. What have you tried and where are you stuck, i.e. we can only help if you have specific questions, specific problems, or specific errors. Just posting the requirements of your assignment is a good start for a Request For Quote (RFQ) to pay someone to do this, but not for asking for programming help.

Leon · February 27, 2021, 1:26am

My knowledge in programming is limited in most cases to what is basic. I do not want anyone to work for me, but rather help me with what he / she can do to get me started with this. Whether there is a person who can sit down one place in the world to put the same entire membership list is up to each individual of course. But then it would also have been nice if that person could take the trouble to explain to me what one yeast and what the other does etc. So what I ask for is just a cry for help. I’m completely stuck. So sorry if I stepped on someone’s toes or seemed rude. It was not meant to be seemed like that, if anyone perceived me that way.

I have not done much before it locked up. I was also so annoyed, bored and abandoned after sitting for three days and could not get any further. So in all the frustration, I erased all the crap to start over. haah … again with what. Would not go further than I was before anyway. That’s why I’m standing on bare ground with blank sheets.

So all I ask is HELP. Everything extra I take as a bonus. Gonna put together some of what I had done and post it here. It probably may not happen tonight (is night here in Norway now - 02:22)

whispers · February 27, 2021, 1:43am

Seems like will be a multi-part project

front end form (data/membership application)
database (maybe 2)
an admin form to control who has been approved/accepted… and who is still on the wait list.

Lets starts with the initial membership form (12 fields)

Update:

This really shouldnt take that long… (I already whipped up an example)

3 fields… (but some back-end columns for the table)

What I’m not clear about is… what happens after a user submits their membership application… (goes on the ‘wait-list’)… and then?

You load up a different app/form… that lists all the current applicants on the not-active/wait list…and?

You want to be able to select a user form this list… and 'activate; their account (taking them off the wait list) - is this correct?

phdr · February 27, 2021, 3:00am

@Leon, I/we are not trying to give you a hard time. However, seeing the steps needed and repoducing what you have seen, but with your data, is not programming. It’s pattern matching. This doesn’t teach the fundamentals, so it takes a very long time to accomplish anything, do anything different, and when something doesn’t work, you cannot find what’s causing the problem.

Instead, you need to learn the fundamental skills that you can then use to produce code/query(ies) that do what you want. Are you able to write and execute SELECT and INSERT queries? Can you loop over data from a SELECT query and produce html markup that includes a post method form that will submit a specific user id value? Can you detect if a post method form has been submitted, then validate the form data and use it securely in an INSERT query? These are the fundamental skills that would be needed to create this application.

Programming involves breaking a problem down into the individual steps needed to accomplish a task, then defining the Inputs, Processing, and Output/result (IPO) for each step. Once you have done this, you can design, write, test, and debug the code/query(ies) needed for each step.

In one of the other php help forums, you have been given suggestions for displaying the (numbered) waiting list and for the database tables and general processing. Did you attempt to use any of that information? Do you have questions about any of the points that were made?

whispers · February 27, 2021, 7:56pm

guess it must be all sorted out then.

good luck!

Leon · February 16, 2022, 2:07pm

The reason I am so humble and careful when I ask is because I have received so much “pepper” and “lemon” and angry feedback when I have asked for help. In many cases, many have been directly rude to me. On many of the pages, they have even stopped answering me. Whether this is my own fault or not I do not know. Maybe people just get sorry for me, and that my questions are too advanced for someone at my level, and for others for that matter to be able to give an answer. I do not know. At least I did not go down without explaining myself first. I could have mentioned several by name both by name on the web pages and the people, but my intention is not to put anyone to the wall or put in a bad light. I’m moving on. It would make me as bad a person as deog throwing out names and URLs.

So basically I’m of the same opinion as you are, that these websites and the people behind them and the guests there are there to help, but gradually it has made me more and more aware that there are always rotten apples in the basket you fill up, and in the end the basket is so full of rotten apples that you just move on. That’s why I’m so humble and careful when I ask. For I have great respect for you who are on a completely different planet when it comes to programming "and who really do their best to teach to us who are not so lucky to have the harbor on the same floor as you who have already learned about programming. So, thanks for the membership here at PHP Help I hope I can be so good that I can also help someone with answers to your questions in SQL (mysql) and PHP. CSS and HTML are really quite well engraved inside the cerebral cortex.