TOPIC:

text with date to db as datetime 2 years 5 months ago #220410

  • Topic Author
  • Phanto
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 11
  • Thanks: 0
Hi,

i started to learn BF but I have an issue with the datetime.
I have form with a Textfield to enter a date that should finally stored into a DB.
All other fields working perfekt but the Date in the DB shows 0000-00-00 00:00:00

can you please give me a hind that the Text in the textfield can stored with the correct format to the db?

// retrieve the submitted values
$userid = JFactory::getUser()->get('id',0);
$auri = ff_getSubmit('auri', '');
$spg = ff_getSubmit('spg', '');
$spd= ff_getSubmit('spd', '');

ff_query(
"insert into `#__turnierserie` ".
"(`userid`, `venue`,`spieltag`, `spieltagd` ) ".
"values ('$userid', '$auri', '$spg', '$spieltagd')"
);

Many thanks in advance

Please Log in or Create an account to join the conversation.

text with date to db as datetime 2 years 5 months ago #220415

  • marinkosevo's Avatar
  • marinkosevo
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 747
  • Karma: 27
  • Thanks: 92
Hello,
What kind of data is spieltagd in database? If you put it in varchar, it will display correctly I believe.

Best regards,
Marinko

Please Log in or Create an account to join the conversation.

text with date to db as datetime 2 years 5 months ago #220442

  • Topic Author
  • Phanto
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 11
  • Thanks: 0
Sorry, correct should be
// retrieve the submitted values
$userid = JFactory::getUser()->get('id',0);
$auri = ff_getSubmit('auri', '');
$spg = ff_getSubmit('spg', '');
$spd= ff_getSubmit('spd', '');

ff_query(
"insert into `#__turnierserie` ".
"(`userid`, `venue`,`spieltag`, `spieltagd` ) ".
"values ('$userid', '$auri', '$spg', '$spd')"
);

It's stored as datetime because i want to use it later as date.

Regards

Please Log in or Create an account to join the conversation.

text with date to db as datetime 2 years 5 months ago #220443

  • Topic Author
  • Phanto
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 11
  • Thanks: 0
Sorry, the correct code should be
// retrieve the submitted values
$userid = JFactory::getUser()->get('id',0);
$auri = ff_getSubmit('auri', '');
$spg = ff_getSubmit('spg', '');
$spd= ff_getSubmit('spd', '');

ff_query(
"insert into `#__turnierserie` ".
"(`userid`, `venue`,`spieltag`, `spieltagd` ) ".
"values ('$userid', '$auri', '$spg', '$spd')"
);

The type is datetime because I want to use the date later.

Is there an option to change to format to datetime after submit the form?

Regards

Please Log in or Create an account to join the conversation.

text with date to db as datetime 2 years 5 months ago #220444

  • Topic Author
  • Phanto
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 11
  • Thanks: 0
Sorry, the correct code should
// retrieve the submitted values
$userid = JFactory::getUser()->get('id',0);
$auri = ff_getSubmit('auri', '');
$spg = ff_getSubmit('spg', '');
$spd= ff_getSubmit('spd', '');

ff_query(
"insert into `#__turnierserie` ".
"(`userid`, `venue`,`spieltag`, `spieltagd` ) ".
"values ('$userid', '$auri', '$spg', '$spd')"
);

the type in the DB is datetime because I want to use it later.

Regards

Please Log in or Create an account to join the conversation.

text with date to db as datetime 2 years 5 months ago #220481

  • marinkosevo's Avatar
  • marinkosevo
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 747
  • Karma: 27
  • Thanks: 92
The problem is that the textfield saves text as string and you need datetime. You need to adjust it to your format, first convert string to date:
$date = strtotime($spd);
Then do a date function
$datetime = date("Y-m-d H:i:s", $date);
Now in your variable $datetime you should have what you need.

Best regards,
Marinko

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Moderators: ForumSupport
Time to create page: 0.056 seconds

Summer Sale!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!