[SOLVED] how to find out system date & time?

[zgkhoo]

how to find out system date & time?

thanks

 

[corillo181]

echo date();

[Barand]

and provide a format string

<?php 
echo date('Y-m-d H:i:s');
?>

[zgkhoo]

wat is the format to save it in mysql DB?

DateJoin date, 

<---this?

is it any special format needed in mysql if date combine with time?

thanks ...

 

[Barand]

If you only need the date part

 

DateJoin DATE,

 

If you want time element also

 

DateJoin DATETIME,

 

Store them in the format I used in my previous post (omitting the H:i:s if DATE type)

[zgkhoo]

<?php
if(isset($_POST['create_feedback'])){
       echo"create feedbak";

		$sql = "CREATE TABLE feedback
		(
                         FID varchar(10), 
   			Topic varchar(50),	
		Message varchar(500),
	         DatePost datetime,
	        UserID varchar(10),
	         Primary Key(FID)		    
		)";
		mysql_query($sql,$con);


}
?>

 

   
<?php
   $datepost=date('Y-m-d H:i:s');  //finding the sys date
    
      
      $sql="INSERT INTO feedback (FID,UserID,Topic,Message,DatePost)
      VALUES ('$FID','1234','$_POST[topic]','$_POST[message]',$datepost)";
      mysql_query($sql,$con);
?>

 

still cant... :-\

 

 

[zgkhoo]

sorry, my mistake ,problem solved thanks

no increment to $FID 

[Barand]

If you want to write the current datetime when inserting you can use MySQL NOW() function.

 

To auto_inc the FID column, write NULL to it

 

 

$sql="INSERT INTO feedback (FID,UserID,Topic,Message,DatePost)

      VALUES (NULL, '1234', '$_POST', '$_POST[message]', NOW() )";