form data to database

Issues related to forms.
Post Reply
bennywww
 
 
Posts: 7
Joined: Tue Mar 05, 2019 1:29 pm

form data to database

Post by bennywww » Sun May 10, 2020 8:39 pm

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

User avatar
Pablo
 
Posts: 20479
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: form data to database

Post by Pablo » Mon May 11, 2020 6:16 am

Does your database table have a 'datestamp' field?

bennywww
 
 
Posts: 7
Joined: Tue Mar 05, 2019 1:29 pm

Re: form data to database

Post by bennywww » Mon May 11, 2020 8:02 am

No
Benny

User avatar
Pablo
 
Posts: 20479
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: form data to database

Post by Pablo » Mon May 11, 2020 8:56 am

This is a require field.

See also this related topic:
https://www.wysiwygwebbuilder.com/forum ... =5&t=88407

bennywww
 
 
Posts: 7
Joined: Tue Mar 05, 2019 1:29 pm

Re: form data to database

Post by bennywww » Mon May 11, 2020 3:26 pm

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

MGD4me
 
 
Posts: 161
Joined: Tue May 02, 2017 11:56 pm
Location: Canada

Re: form data to database

Post by MGD4me » Mon May 11, 2020 3:45 pm

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

bennywww
 
 
Posts: 7
Joined: Tue Mar 05, 2019 1:29 pm

Re: form data to database

Post by bennywww » Mon May 11, 2020 4:44 pm

Hi
thank you for this information
now works without errors
but (DATE) table is empty in database
friendly Benny

Post Reply