text with date to db as datetime

  • Phanto
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0

Phanto created the topic: text with date to db as datetime

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
#220410
  • Posts: 747
  • Karma: 27
  • Thank you received: 92

marinkosevo replied the topic: text with date to db as datetime

Hello,
What kind of data is spieltagd in database? If you put it in varchar, it will display correctly I believe.

Best regards,
Marinko
#220415
  • Phanto
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0

Phanto replied the topic: text with date to db as datetime

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
#220442
  • Phanto
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0

Phanto replied the topic: text with date to db as datetime

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
#220443
  • Phanto
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0

Phanto replied the topic: text with date to db as datetime

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
#220444
  • Posts: 747
  • Karma: 27
  • Thank you received: 92

marinkosevo replied the topic: text with date to db as datetime

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
#220481
Moderators: ForumSupporttomeperica
Time to create page: 0.072 seconds

New Icon Packs Category!

Crosstec is now offering icon packs.

If you are a paying subscriber, icon packs are automatically added to your account.

Check out our icon packs page!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Summer Sale!

50% discount on all of our extension subscription plans, templates and icon packs!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

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!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here