Databases
StackOverflow2013
Postsdbo
PObuild select list based on current date php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PObuild select list based on current date php
    primarykey
    data
    text
    <p>Ive created a drop select list that generates a list of dates based on the current date,</p> <p>4 days back and 7 days forward, Ive tried several shorter scripts but they all fail, ive been using the following but it has some limitiations... Thanks!</p> <pre><code>&lt;option value=""&gt; select &lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-4),date("Y")));?&gt;" style="color:red;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-4),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-3),date("Y")));?&gt;" style="color:red;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-3),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-2),date("Y")));?&gt;" style="color:red;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-2),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-1),date("Y")));?&gt;" style="color:red;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")-1),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ('m/d/Y');?&gt;"&gt;&lt;?php echo date ('m/d/Y');?&gt; TODAY &lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+1),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+1),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+2),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+2),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+3),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+3),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+4),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+4),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+5),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+5),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+6),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+6),date("Y")));?&gt;&lt;/option&gt; &lt;option value="&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+7),date("Y")));?&gt;" style="color:green;font-weight:bold;"&gt;&lt;?php echo date ("m/d/Y", mktime (0,0,0,date("m"),(date("d")+7),date("Y")));?&gt;&lt;/option&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAsad Saeeduddin
    1. USIchimonban
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PObuild select list based on current date php
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCould you narrow your code sample down to the relevant part (maybe use an ellipsis to denote repetition)? Also, what limitations does this have?
      singulars
      1. PObuild select list based on current date php
      1. USAsad Saeeduddin
    2. COWhat are the limitations you're finding? You haven't really asked a question here...
      singulars
      1. PObuild select list based on current date php
      1. USEmmyS
    3. COplease forgive my brevity, It's rather cumbersome, and I am attempting to compair it to a value in the database, in addition the form I have to place it into is very small and it's just a lot of repetitive code to type in if I mess up, and I've been attempting to try some examples Ive found around but keep getting something wrong
      singulars
      1. PObuild select list based on current date php
      1. USIchimonban
 

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