Populate a form

[CarterLangley]

Hi guys,

OK, here is what I have in mind. I have to be able to edit membership information, so I propose populating a form with the relevant information. But, I would like to populate the form depending on what member is chosen using a select box. Now, the form will be empty and only once the member has been selected via the select box will the form be populated. I don't want to have to navigate to another page. The select box will ideally be within the form itself. Also, will it be possible to cycle through the member information using the same form, ie. next record, previous record, etc.?

[phorce]

e same

Do you want someone to do the code for you? You could atleast attempt it. I don't get what question you're actually asking.

[CarterLangley]

Don't want somebody to do the code for me at all. I will always attempt the code myself. Basically, I want a form to behave as if it were a form in Microsoft Access, ie. without refreshing you can cycle through records. Asking if this is at all possible using PHP.

[Squidge]

@CarterLangley
You would need Java/JQuery to auto refresh the form on the change of the drop down.

Give your form an ID and call submit on it using something like:

$('#myform').submit();

where 'myform' is the id of your form

Or something like this

[phorce]

Hey, apologies.

You would need to use something like, jQuery/Ajax/Javascript in order to create this kind of functuanlity. You can use PHP to do the processing i.e. ("retriving / displaying data"). But the real-time, none-refreshing element would need to be done in a client-side language.

I guess it would be fairly easy to create it where you can show ("Next {#} Records") for example, as well as shifting through them.

[CarterLangley]

No worries @phorce.
Thought it might have had to be something other than PHP. So, back to the headscratching for me as I have never had any dealings with JQuery/Ajax/Javascripting. Think it might just be a bit easier for me to write something locally in Access that will front-end my mySql database on the webserver and use that to edit the data in the tables. This is not functionallity that is totally necessary on the website anyway, just would have been a nice to have. Can always carry my laptop with me on trips out and connect using my mobile phone for wireless.

Hey @Squidge, as above. I at this stage don't really feel up to JQuery, etc. Just getting my small brain around PHP is making an already grey head even greyer!

Guys, I think you both have just saved me a major headache!

[phorce]

op with me on trips out and connect using my mobile phone for wireless.

It's possible, I mean, don't give up! It's good to experiment with such things, and, once you start it'll all click into place. I mean, when do you need it by? Do you have a specification of how you want it to look like / function?

[CarterLangley]

Don't need it by any given time frame. And any specs are of my own making. Thumb sucking comes to mind? Will definitely give it a go but at a later date. If I can get something working for now to help me edit the data easily then I think that will be the way. The fancy things can come a bit later. Still lots to do PHP wise, so will concentrate on that first. This is a site for a charity I helped setup, so can take my time on the fancy, nice to haves.

[phorce]

Providing the specification is clear and consise, and, depending on the purposes I would be more than happy to help you! P/m me to talk more?