Please Explain with example How do I insert the date into the table

[ifuturz]

Please Explain with example How do I insert the date into the table in PHP ?

[g1smd]

Let's see your code and someone can guide you where you're going wrong.

[topr8]

have you considered just using a timestamp field in the database, and let it automatically enter the date

[rocknbil]

Or a date type, or a datetime type.

For those, literal values must be quoted and in YYYY-MM-DD format. Date functions do not:

insert into tablename (my_date_only_field) values (curdate()); // date only

insert into tablename (my_date_and_time_field) values (now()); // date and time

insert into tablename (my_date_only_field) values ('2012-02-01'); // date only

insert into tablename (my_date_and_time_field) values ('2012-02-01 02:59:22'); // date and time

mySQL Date and Time [dev.mysql.com]