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
form data to database
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/forms.html
http://www.wysiwygwebbuilder.com/form_wizard.html
Frequently Asked Questions about Forms
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/forms.html
http://www.wysiwygwebbuilder.com/form_wizard.html
Frequently Asked Questions about Forms
Re: form data to database
Does your database table have a 'datestamp' field?
Re: form data to database
This is a require field.
See also this related topic:
https://www.wysiwygwebbuilder.com/forum ... =5&t=88407
See also this related topic:
https://www.wysiwygwebbuilder.com/forum ... =5&t=88407
Re: form data to database
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
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
In your php code, it is good practice to declare the time zone, such as:Warning: date (): It is not safe to rely on the system's timezone settings
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
Hi
thank you for this information
now works without errors
but (DATE) table is empty in database
friendly Benny
thank you for this information
now works without errors
but (DATE) table is empty in database
friendly Benny