PHP MYSQLi datetime format insert into mysql

PHP MYSQLi datetime format insert into mysql

Today, We want to share with you PHP MYSQLi datetime format insert into mysql.
In this post we will show you php datetime format insert into mysql Example, hear for how to insert date and time into phpMyAdmin database we will give you demo and example for implement.
In this post, we will learn about php – Insert current date in datetime format mySQL with an example.

php datetime format insert into mysql

First of all, you can not need to generate a date in using PHP like this.
If you are using php old version (old PHP) and a database used MySQL,
so you may use to the SQL function of `now()` function to insert data into a SQL(MYSQL) timestamp field,
like this:

Example :


INSERT INTO project_master 
  (projectdata_id,project_latestname, project_last_updated,project_date_created)
  VALUES (5, 'alvin', now(), now());

I just tested this code with MYSQL and PHP, and it alredy works fine.
therefor i know all data insert in mysql to know log and check this data using timestamp.if all you must really needed to know was how to most populer a SQL or MYSQL timestamp field in a SQL or MYSQL INSERT query,
that’s Most probably the easiest way to go and get fast results.

Creating a PHP timestamp variable and store in MYSQL

so, if you get the date current and you want to do this all in PHP Like frameworks.(or need to, depending on what framework(Laravel,CI,MVC) you’re working with),
you may get the current time and date in the smoothly proper format using PHP, like this:

 
   $timestamp_var = date('Y-m-d G:i:s');
   
 

If you display print this out, your $timestamp_var field will now contain display content like this:

Example :

 
  2011-08-06 14:54:17
  

and then You may then use this formatted (date of string)timestamp string in a using PHP MySQL insert record.

PHP SQL Timestamp inserts

I hope these all example timestamp have been helpful or futured help this post.
As well as , As you’ve seen, you may regular just use the SQL function ‘NOW()’ function to insert date into a SQL date or timestamp field,
but if that does not work for some reason in syntax,
you may also make a timestamp or create_date field in the simple proper format using PHP and the date function used.

Insert current datetime format using mySQL

First way

	$result_success= mysql_query("INSERT INTO `yout_tablename_test` (`cr_date`) VALUES (now())");
	

Second way

$date = date(‘Y-m-d H:i:s’);
//using mySQL query
$result_success= mysql_query(“INSERT INTO `yout_tablename_test` (`cr_date`) VALUES (‘$date’)”);

CURDATE() Function using MySQL

Just used CURDATE() function returns the current date Like..

syntax :

CURDATE()
SELECT NOW(),CURDATE(),CURTIME()

1) NOW() = 2016-11-22 12:45:34
2) CURDATE()= 2016-11-22
3) CURTIME()= 12:45:34

Example

CREATE TABLE Orders_master
(
Order_Id int NOT NULL,
cr_Product_Name varchar(50) NOT NULL,
cr_Order_Date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (Order_Id)
)

Other way

First way using date format

just you can convert the date with function using strtotime();

//store date
$date_Today_var = date("d-m-Y");
//formating
$newDate = date("Y-m-d", strtotime($date_Today_var));
OUTPUT: 2012-12-27

And then you may just display and store data to your database using MYSQL.

When you have to recover the date using date function you can reverse this operation following like this:

//init date
$date_From_Database = "2016-01-27";
//formating date
$reverse_Date = date("d-m-Y", strtotime($date_From_Database));

OUTPUT: 27-01-2016

(onther way to corrected  format "Y-m-d" to "d-m-Y" in 2nd date call using PHP)

other Second way

$from_MYSQL = '2016-10-17 28:47:22';
echo date("m/d/Y", strtotime($from_MYSQL));

The date function second argument of date is a timestamp(in date function) and I think what is happening is PHP sees your string as a -1 timestamp… thus 12/31/1969.

So, to get a timestamp(date) from get the string version of the date, you use strtotime function using php

other Third way

Convert from MySQL date and datetime to another format using PHP ?

To convert a date retrieved in parameter store from MySQL into the default format requested (mm/dd/yy H:M (AM/PM)):

$time_var = strtotime($date_time_From_Mysql);
$myFormat_For_View = date("m/d/y g:i A", $time_var);

other fourth way

date format in php retrieved from mysql


On the using MySQL side you can use DATE_FORMAT function:

SELECT store_id, DATE_FORMAT(created_atdt, '%d-%m-%Y') FROM salesmanager;

other fifth way

Date Fetched From MySQL in PHP?

There are a lot of date functions in PHP for dealing with date function, timestamp or time and date.
For a Beginner it may be trouble to select the rights ones, therefore it is most easy. In this date php post,
I will especially problems with the situation and solution,
where you fetched a Date from MySQL table, and you need to display this date function in a separate format to using date function.

What Function will we use?

Noew date() function to use like.
date();

MySQL Dates are in YYYY-MM-DD, this is not really the need most universally accepted date format.

//all Fetch the record data from your table(mysql).
//include your date in a variable called $sql_date
$date_format = strtotime($sql_date);
//Execute this function
echo date("j F Y", $date_format); //In output will be 25 July 2016

We hope you get an idea about PHP MYSQLi datetime format insert into mysql
We would like to have feedback on my Information blog .
Your valuable any feedback, Good question, Inspirational Quotes, or Motivational comments about this article are always welcome.
If you liked this post, Please don’t forget to share this as Well as Like FaceBook Page.

We hope This Post can help you…….Good Luck!.

Leave a Comment