Page 1 of 1
form data to database
Posted: Sun May 10, 2020 8:39 pm
by bennywww
Hi
unfortunately i need some help
form data into database
gives this error: Failed to insert data into table!
Unknown column 'DATESTAMP' in 'field list'
in phpmyadmin
my form tables are created and FORMID
but there is no primary key
greeting benny
Re: form data to database
Posted: Mon May 11, 2020 6:16 am
by Pablo
Does your database table have a 'datestamp' field?
Re: form data to database
Posted: Mon May 11, 2020 8:02 am
by bennywww
No
Benny
Re: form data to database
Posted: Mon May 11, 2020 8:56 am
by Pablo
This is a require field.
See also this related topic:
https://www.wysiwygwebbuilder.com/forum ... =5&t=88407
Re: form data to database
Posted: Mon May 11, 2020 3:26 pm
by bennywww
Hi Pablo
thanks for your prompt reply
i have read the php file
manually created tables
now something is working
all my form dates are written to the database ok
DATE TAMP OK - TIME OK - IP OFF - BROWSER - OK
PROBLEMS WITH DATE
Warning: date (): It is not safe to rely on the system's timezone settings
Hope you have a solution
friendly benny
Re: form data to database
Posted: Mon May 11, 2020 3:45 pm
by MGD4me
Warning: date (): It is not safe to rely on the system's timezone settings
In your php code, it is good practice to declare the time zone, such as:
date_default_timezone_set('America/Vancouver');
... just change the 'America/Vancouver' part to reflect the zone for your region. A list of time zones is available here:
https://www.php.net/manual/en/timezones.php
Re: form data to database
Posted: Mon May 11, 2020 4:44 pm
by bennywww
Hi
thank you for this information
now works without errors
but (DATE) table is empty in database
friendly Benny