php - Timestamp in html -


i trying store timestamp in database. html code:

<form action="insert.php" method="post"/>  <style> p{     float:center; } </style>   <font color=red > <center>support or analysis tracker (soat) </center></font> </br> </br>  <p align="left"> <label for="process"><font color=default>analysis/support</label> &nbsp</t>  <select id="process" name="process"> <option value="analysis">analysis</option> <option value="support">support</option> </select>      &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp <label for="so_number"><font color=default>so_number</label>     <input type="text" id="so_number" name="so_number"  value ="so_" required/> &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp   <label for="person_incharge"><font color=default>person_incharge</label>   <input type="text" id="person_incharge" name="person_incharge" required/></br> </br></br> </br> </p> <p align="left">     <label for="description"><font color=default>description</label>     <input type="text" id="description" name="description" />  </p>  </br>     </br> <div style="text-align:center">  <button>     <img alt="ok" src=    "http://www.blueprintcss.org/blueprint/plugins/buttons/icons/tick.png" />   insert   </button> </fieldset> </form> 

after hitting insert button, need store current time , date in database. backend database structure following:

database structure

in these cases can use now() function of mysql.

insert tablename(received) values(now()) 

with structure use mysql server date , time


Comments

Popular posts from this blog

scala - 'wrong top statement declaration' when using slick in IntelliJ -

c# - DevExpress.Wpf.Grid.InfiniteGridSizeException was unhandled -

PySide and Qt Properties: Connecting signals from Python to QML -