Databases
StackOverflow2013
Postsdbo
POCreating a dynamic text field that changes content depending on select list choice?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating a dynamic text field that changes content depending on select list choice?
    primarykey
    data
    text
    <p>Me and my colleague are in the process of starting up our own company that handles exam results and school data. I am currently in the process of setting up the webpage (I am completely new with PHP and Dreamweaver CC) where the end-user can access and edit the database in the extent that they need to.</p> <p>But I shall get to the point of my problem. At the moment I am trying to build a data edit page where all relevant data is shown once the user has logged in (In this case it's an admin-kind of person, so he/she needs to see which teacher teaches which classes). On this page I want to build a drop-down list of all the possible Classes (done this with the recordset, sorted alphabetically and working) and linking to that, a dynamic text field that changes value depending on the option picked in the select list.</p> <p>Example:</p> <p>There are four classes, and four corresponding teachers as followed:</p> <h2>Class - Teacher</h2> <p>English - Bob</p> <p>Spanish - Juan</p> <p>Math - Jenny</p> <p>Geography - William</p> <p>What I'm basically after is that if you choose the Class 'English' in the drop-down select list, the text field should display 'Bob' (and similarly for all the other classes). So far I've not managed to work out how to do that in Dreamweaver CC.</p> <p>EDIT: I forgot to mention that both the class names and the corresponding teachers are a result from the query I've set up in a recordset - so instead of having to make the link myself I have to display that link (it does so for the very first school name in the dropdown list, but I think that's because of the nature of the query)</p> <p>Help is much appreciated!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSean Limpens
    1. USSean Limpens
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating a dynamic text field that changes content depending on select list choice?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThere's several ways to do this, but I'd have an event handler attached to the menu item, which updates the correct DOM element with the new name. Whilst you could use AJAX (i.e. a background fetch) it seems that the amount of data you have here would make it amenable to rendering your names table in a JavaScript array, and using it as a lookup table when the event triggers. You will need to learn some JavaScript (and maybe a library like jQuery to make it easier).
      singulars
      1. POCreating a dynamic text field that changes content depending on select list choice?
      1. UShalfer
    2. CO(This question, as interesting as it is, is rather too broad for here. It would be best to give it a go, and to ask more directed questions if you get stuck).
      singulars
      1. POCreating a dynamic text field that changes content depending on select list choice?
      1. UShalfer
    3. COUse jquery with ajax to get the data from database using php - http://www.bennadel.com/resources/presentations/jquery/demo21/
      singulars
      1. POCreating a dynamic text field that changes content depending on select list choice?
      1. USSaranya Sadhasivam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload