Insert data to table in php/mysql & automated insert date
964
user table:
User_ID
Username
Password
campus table:
Campus_ID
Campus_name
Campus_Addres
Campus_DateCreate
edit campus table
Edit_ID
Campus_DateEdit
User_ID
Campus_ID
I have 3 tables, when i edit data using form, I want in table edit campus, automated insertedUser_ID
, andCampus_ID
, and the date automated inserted from current date. how do I do this with PHP syntax?
Answer
Solution:
in php use
for datetime fields