Date/Time and Checkbox

Posted on 16th Feb 2014 07:03 pm by admin

Hi Everyone,

I am trying to figure out how to insert the current date and time into the database.
Scenario:
1) user enter my site and fills up the forum
2) hits the submit button
3) Regardless of the user location I want the time to be stored in the database in PST.

Question:

Do I need to get an input from the user for time? or can I just use some server time etc?

Right now I'm asking them to manually insert the date and time in the textbox which is not that effective


Also I have a checkbox in my forums but I always get 0 in the value field when I check the database. I have it setup as (tinyint(1)) in the database using mysql. I think I am doing wrong.


Is there a way to require the user to check the button before they hit the "Submit" button?

Thank you in advance

Your Answer:

Login to answer

Other forums

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in

Call db table from any PHP file
Hi,

I want to be able to call a database table that will be setup in another file called init

Cannot Connect to Database
I am writing an application to do annual reviews. I cannot get my script to work. Whenever it runs I

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma