Ragazzi devo far inserire agli utenti l'ora e la data, per evitare errore ho deciso di creare 2 select un per la data e un per l'ora, ma adesso che campo devo usare per inserire la data e l'ora?
ecco il mio codice:
ORA RECUPERO I DATI:Codice PHP:
Data Promozione:
<select name="giorno" autocomplete="off">
<option value="-1">Giorno:</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="mese">
<option value="-1">Mese:</option>
<option value="1/">gennaio</option>
<option value="2/">febbraio</option>
<option value="3/">marzo</option>
<option value="4/">aprile</option>
<option value="5/">maggio</option>
<option value="6/">giugno</option>
<option value="7/">luglio</option>
<option value="8/">agosto</option>
<option value="9/">settembre</option>
<option value="10/">ottobre</option>
<option value="11/">novembre</option>
<option value="12/">dicembre</option>
</select>
<select name="anno" autocomplete="off"><option value="-1">Anno:</option>
<option value="2012/">2012</option>
<option value="2011/">2011</option>
<option value="2010/">2010</option>
</select>
Ora Fine Promozione:
<select name="ora" autocomplete="off">
<option value="-1">Giorno:</option>
<option value="00:00">00:00</option>
<option value="01:00">01:00</option>
<option value="02:00">02:00</option>
<option value="03:00">03:00</option>
<option value="04:00">04:00</option>
<option value="05:00">05:00</option>
<option value="06:00">06:00</option>
<option value="07:00">07:00</option>
<option value="08:00">08:00</option>
<option value="10:00">10:00</option>
<option value="11:00">11:00</option>
<option value="12:00">12:00</option>
<option value="13:00">13:00</option>
<option value="14:00">14:00</option>
<option value="15:00">15:00</option>
<option value="16:00">16:00</option>
<option value="17:00">17:00</option>
<option value="18:00">18:00</option>
<option value="19:00">19:00</option>
<option value="20:00">20:00</option>
<option value="21:00">21:00</option>
<option value="22:00">22:00</option>
<option value="23:00">23:00</option>
</select>
$g=$_POST['giorno'];
$m=$_POST['mese'];
$a=$_POST['anno'];
$time=$_POST['ora'];
$ora = $a.$m.$g.$time;
è giusto cosi? e che campo devo utilizzare? datetime?