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

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

Reading Most Recent CSV File in Directory
I thought I had wrapped this project up, but found out that the program I use to FTP a csv file to m

How can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

quotes changing
hi all

in my content

opening quotes " changes to “

close qu

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

php mysql script to find record
Hi,

Currently I have a simple table with 4 columns. A, B, C, D

If I want to find all

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the