Databases
StackOverflow2013
Postsdbo
POCannot return the values of forms
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCannot return the values of forms
    primarykey
    data
    text
    <p>I am new to php and web programming.</p> <p>I am programming a website that collects essays. In the submission form, I want the date to be entered by 3 select dropdown forms (day-month-year). I used to add them in a text field and save them as strings in database. I added already hundreds of essays so I am not changing the type of data.</p> <p>I did the following: 1- I made a dynamic dropdown using php:</p> <pre><code>function get_dropdown_options( $name, array $options, $selected=null ) { $dropdown = '&lt;select name="'.$name.'" id="'.$name.'"&gt;'."\n"; $selected = $selected; foreach( $options as $key=&gt;$option ) { $select = $selected==$key ? ' selected' : null; $dropdown .= '&lt;option value="'.$key.'"'.$select.'&gt;'.$option.'&lt;/option&gt;'."\n"; } $dropdown .= '&lt;/select&gt;'."\n"; return $dropdown; } </code></pre> <p>2- then I made a function to show three dropdown menus for days, months and years.</p> <pre><code>function show_date_dropdown_row($name, $label, $option1, $option2, $option3, $value = "") { echo "&lt;tr class=\"".get_row_bg()."\" valign='top'&gt;\n&lt;td&gt;&lt;p class=\"rowtitle\"&gt;".$label."&lt;/p&gt;&lt;/td&gt;\n"; echo "&lt;td&gt;&lt;p&gt;\n"; echo get_dropdown_options($name1, $option1, $value1).get_dropdown_options($name2, $option2, $value2).get_dropdown_options($name3, $option3, $value3); return $name = $name1." - ".$name2." - ".$name3; } </code></pre> <p>3- in the submission form page, I put the following code:</p> <pre><code>show_date_dropdown_row("release_date", "Release Date", $days_list, $months_list, $years_list, ""); </code></pre> <p>4- the name "release_date" is then added to the database.</p> <p>The page shows the three dropdown lists perfectly. But the problem is that the "release_date" in database don't store any value.</p> <p>I tried the function in step1 and it works perfectly. I know that the problem is in step two, but don't know where.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSelwin
    1. USSelwin
    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. POCannot return the values of forms
      1. This table or related slice is empty.
      1. VTUpMod
    1. COwhere are you defining $name1, $name2 and $name3? also there are better ways in terms of UX to display a date input, I suggest you look for a datepicker plugin
      singulars
      1. POCannot return the values of forms
      1. USkoala_dev
    2. COI didn't define them. Do i have to?
      singulars
      1. POCannot return the values of forms
      1. USSelwin
    3. COfor the datepicker plugin, its not useful for me because I add essays date back to 80's and 90's so it'll be time consuming.
      singulars
      1. POCannot return the values of forms
      1. USSelwin
 

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