Dealing with godaddy mySQL timestamps on a shared server. As of this posting, although Arizona is in the Mountain time zone, it does not participate in the Daylight Savings party. Issue is that godaddy timstamps are “readable” but are in US/Arizona timezone. If the server is on a shared host, the default timezone can NOT be changed.

Here is my solution to the problem of querying a godaddy sql server timestamp:

1. In your PHP script include the line (add your desired time zone as needed):
   date_default_timezone_set(‘America/New_York’);
   
2. In the $sql “SELECT….” statement, use the following:
   UNIX_TIMESTAMP(timestamp);
   
3. To display the time in a readable format use “date(‘format’,timestamp)” formula:
   echo date(‘D, M j – g:ia’,timestamp);
   

This will create a Post using PHP.

<?php
/*
     Code SOURCE: https://www.youtube.com/watch?v=bVImxRBKBuc
     Reference: 
      
wp_insert_post()
	
*/
//set timezone
	date_default_timezone_set('America/New_York');
//require native WordPress function
	require_once("wp-load.php");
// Post variables
	$userID = get_current_user_id();
	$leadTitle='Operation Test Post'
	$leadContent='Hello there.  this is the post!';
      
     //ID# automatically assigned to categories.  For multiple
     // categories, separate with a comma
      $categoryID='28';
	
//Time variables - Sets time for now so post can be published without delay
	$timeStamp = date_create();
	$postdate = date("Y-m-d H:i:s", $timeStamp);	
//wordpress Array and Variables for posting
						
	$new_post = array(
		'guid'=>$postID,
		'post_title'=>$leadTitle,
		'post_content'=>$leadContent,
		'post_status'=>'publish',
		'post_date'=>$postdate,
		'post_author'=>$userID,
		'post_type'=>'post',
		'post_category'=>array($categoryID),
		'comment_status'=>'open',
		);
//THIS submits the array data to creat the new post
	$post_id = wp_insert_post($new_post);
//Error Checking
     if ($post_id){
          echo "SUCCESS!";
     } else {
          echo 'OOPS!  something failed, please try again!';
     }
?>

This is the receiving page for the simple form submit.

This is the code

<?php	
	if (isset($_POST['firstname']) && $_POST['firstname']){
		$first_name='"'.$_POST['firstname'].'"'; 
		$last_name='"'.$_POST['lastname'].'"'; 

		echo "<p>First Name: $first_name </p>";
		echo "<p>Last Name: $last_name </p>";
	} else {
	
		echo "<p> Error: some or all of the fields were not completed.</p>";
		
	}
?>			

Quick code that checks to see if current user is logged in. Anything other than “0” is logged in.

//Grab the current user details from WordPress
	$current_user = wp_get_current_user();	
	if ( 0 == $current_user->ID ) {
    	echo 'Sorry.  You need to be logged in to see this information....';
		die();
		}