php insert date into mysql – How to insert date in MySQL using PHP?

php insert date into mysql – Convert the date using date format. Insert the date in the database using a Insert MySQL query.

php insert date into mysql – PHP code for inserting data into database from form using mysqli

Lets get started to: (php insert date into mysql)

Step 1: Create a table:

Make a DB table named shops into your Database (MySQL) as follows
[php]
CREATE TABLE `shops` (
`id` int(11) NOT NULL,
`name` varchar(191) NOT NULL,
`created_date` DATE NOT NULL
);
[/php]

Step 2: Create a PHP file

index.php
simply copy and paste the below html form design source code:
[php]

[/php]

Step 3: Create a code.php file

code.php
simply copy paste the below source code to insert date value in mysql database in php.
[php]

[/php]