I have a nice dynamic webpage I am happy with that takes the information from the database and places it to the webpage depending on the selected name.
There are a few things I am having issues with that I would love some guides or advice on how to implement.
First, I would like to access the dynamic webpage through a search with the ability to autocomplete in the drop down, if that makes sense.
For example, if someone inputs a word, then the possible matches are shown below in a drop down.
Like if someone puts in
Then in a drop down below, it may show:
And they can input the whole name, or select one of the names suggested
If that is not possible, its fine to do without, but I would still need to have it so a name could be typed in, then the correct information is displayed for the name
Second, I would like to possibly have information linked to other names able to be displayed on the dynamic page
For example, say you have emergency contact information for staff, and you have the name of the person, and on the database it lists the name of the person to contact.
However, the contact information for that person is under that persons name.
So if you want the contact information for 'Delilah Dooalot's parents on her page, but her parents phonenumbers are under her parents name in the database, is there a way to have the webpage lookup the name of the parent, then find their phonenumber under number?
Or another example, say you have an animal in the Zoo, and the animal has both parents in a column under its name, but you want to show the grandparents of the animal.
However, the grandparents are not in the animals section, but as parents of the animals parents.
Sorry if this is complicated, but how would I do this?
There are great guides to adding information to the database from a webpage, but what about editing information from the webpage, like if a phonenumber has changed, and you want staff to be able to change the information from a webpage, rather than go into the database,
Or if a user wants to update or change profile information or the like.
What if I want to calculate something then show the result on the webpage? Like working out and displaying the average expenditure someone makes, or even using data from other users like finding the average amount of attempts or submissions of users?
Sorry if this is complicated or I am not explaining it well or asking too much, I am working on a project for myself, and am struggling with figuring out how to get the results I want.