Software Engineer

curiouswebster

<div>
I guess localtime is not what I want. I want to explicitly ask for EST or, more correctly, EDT.
</div>


Developer & Coffee Roaster

Scott Fell

<div>
Does this call:<br>date_default_timezone_set("America/New_York");<br><br>also set the page, when I use DateTime objects?
</div>


<div>
This code crashes my page:<br><br>$date&nbsp;=&nbsp;new&nbsp;DateTime(null,&nbsp;new&nbsp;DateTimeZone('America/New_York'));<br>echo $date-&gt;format('Y-m-d H:i:s') . "\n"<br><br><br>$date&nbsp;=&nbsp;new&nbsp;DateTime('2000-01-01'); // WORKS<br>echo&nbsp;$date-&gt;format('Y-m-d H:i:sP')&nbsp;.&nbsp;"\n";<br><br>$date = new DateTime(null, new DateTimeZone('America/New_York')); // FAILS<br>echo&nbsp;$date-&gt;format('Y-m-d H:i:s')&nbsp;.&nbsp;"\n"<br><br>What am I missing?
</div>


<div>
You know what, Scott? After reading your post. I probably should use UTC for all data INSERT and UPDATE calls, and use local time for the UI. So, I presume I would set the config.php to be UTC. Then, when displaying the current time (if I ever needed to) I would display localtime.<br><br>Make sense?
</div>


<div>
<div class="content wysiwyg-content fr-view">
In this Prepared Statement, I have trouble getting localtime.<br><br>Previously, I saw a PHP function that let me insert 'localtime'<br><br>$smt-&gt;bindValue(':create_date', date("Y-m-d h:i:s"), SQLITE3_TEXT);<br><br>Suggestions?<br><br>Thanks
</div>
</div>



In this Prepared Statement, I have trouble getting localtime.
Previously, I saw a PHP function that let me insert 'localtime'
$smt->bindValue(':create_date', date("Y-m-d h:i:s"), SQLITE3_TEXT);
Suggestions?
Thanks

PHP: getting local time

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.