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>  </t> <select id="process" name="process"> <option value="analysis">analysis</option> <option value="support">support</option> </select>           <label for="so_number"><font color=default>so_number</label> <input type="text" id="so_number" name="so_number" value ="so_" required/>           <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:
in these cases can use now() function of mysql.
insert tablename(received) values(now())
with structure use mysql server date , time
Comments
Post a Comment