Issue with Timestamp in MySQL Database

General discussions related to php

Moderators: macek, egami, gesf

Post Reply
User avatar
php-forum Active User
php-forum Active User
Posts: 290
Joined: Sat Mar 23, 2013 8:24 am

Re: Issue with Timestamp in MySQL Database

Post by Strider64 » Wed Jun 18, 2014 8:00 am

This is done in php

Code: Select all

date_default_timezone_set('America/Chicago'); // Set the Default Time Zone:
and this is my query that is done using PDO

Code: Select all

$query = 'INSERT INTO movieTrivia (confirm, question, answerA, answerB, answerC, answerD, correct, dateAdded ) VALUES (:confirm, :question, :answerA, :answerB, :answerC, :answerD, :correct, NOW())';

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests