Databases
StackOverflow2013
Postsdbo
POCustom php function dropdown list from mysql table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCustom php function dropdown list from mysql table
    primarykey
    data
    text
    <p>PHP noob with a challenge.</p> <p>I have a custom php function:</p> <pre><code>function country_dropDown(){ $dropDown = mysql_query("SELECT * FROM countries"); while ($record = mysql_fetch_array($dropDown)) { echo '&lt;option value="' . $record['id'] . '"&gt;' . $record['name'] . '&lt;/option&gt;'; } } </code></pre> <p>'countries' table has 2 fields = id, name.</p> <p>There are over 200 rows in this 'countries' table.</p> <p><em>I can call this function in a html form that requires user input to select from the list of available countries from the list like this.</em></p> <pre><code>&lt;select name="classID"&gt;&lt;?php country_dropDown() ?&gt;&lt;/select&gt; </code></pre> <p><strong>I have some questions I hope someone can help me with.</strong></p> <ol> <li><p>When I call this function inside a html form and look at the source code I can see all 249 countries as "select options". <strong>Is there a best practice or efficient method so it does not list all countries in the source code?</strong></p></li> <li><p>The drop down list always displays, "Afganistan" which is the first row in the 'countries' table. <strong>How can I modify my custom function so it does not show any value or display the text, "Select Country"?</strong></p></li> <li><p>I have another table called 'student' with 2 fields: studentName, countriesID. I have a html form that lets me edit a student's record. It populates the default value of the student's name into the input text field but <strong>how do I make the dropdown function 'selected' the student's 'countryID' from the row?</strong> It always shows, "Afganistan".</p></li> <li><p><strong>Is there a best practice method or more efficient way to approach this countries dropdown select rather than my custom function?</strong></p></li> </ol> <p>I'm grateful for any assistance.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USPeter Reginald
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCustom php function dropdown list from mysql table
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POCustom php function dropdown list from mysql table
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhat have you tried yourself? 1: No (or via JavaScript but that doesn't change anything) 2: add an empty option before your while loop. 3: add a 'selectedid' or something to your function and check for it in the while loop. 4: Symfony custom form fields?
      singulars
      1. POCustom php function dropdown list from mysql table
      1. USputvande
    2. COHi @putvande thanks for replying. I tried some code that now seems so so far out from correct syntax and I tried a few things after googling for answers and then I left this task for over a week. Next time I will post what I tried when I ask the question.
      singulars
      1. POCustom php function dropdown list from mysql table
      1. USPeter Reginald
 

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