ober

So, just posting the fix here in case someone else stumbles on this. In the PHPActiveRecord Connection file, there is a date format with a T in it. No idea why they are completely overriding the built in PHP DateTime object and doing a bunch of stuff with dates, but changing that format seems to resolve my problems at least. I haven't fully tested the app but it got me past the major hurdle for now.

Thanks for the replies. There is no datepicker involved. I'm literally updating a 'last action' field on the user table by setting it to the current date and time. The more I thought about it the more I came to the conclusion that it's not the database doing it (as you all said). I am using phpactiverecord as an ORM so I guess it could be something in there that's translating it. I'll have to search through that library I guess. I really need to get away from that library since it's no longer supported but that will require a pretty extensive rewrite. I've been updating pieces of it myself to support PHP 8.1.

I am converting a site to MySQL 8 and PHP 8.1 (from MySQL 5.7 and PHP 7.4). I have a number of datetime fields in the database and when I try to update one of them, I am getting the error: The code I am using is this: $this->userobj->uaction = date("Y-m-d H:i:s"); If I output that code to the error log I get the date fully as expected. But for some reason, MySQL is getting it with the timezone attached. I'm about to pull my hair out because I cannot figure out how that's getting changed between me setting the value and MySQL processing it. Does anyone know why this might be happening? Some kind of automatic formatting in MySQL?

PHPDesigner 8 (http://mpsoftware.dk/) was just released. I've been using this IDE for years and I absolutely love it. I looked at PHPStorm and it seems like PHPDesigner can do all of that stuff. And it's cheaper.

I'm always looking for new tools so I gave this one a test drive. It is very cool and I like the idea of being able to browse the different cloud services in a very nice interface. However, no one doing any reasonable development would find this effective. Having to open a new interface to select a file to upload vs. having a split window where you can drag from a local location is not something to leave out of an FTP program. Fail. By the way, I don't personally use it but I've tried it: the IDE I use (PHPDesigner) has a built in FTP tool that will automatically upload the files when you save them. That might work for some but I like having more control over when things are uploaded.

http://emaxhosting.com was suggested as well.

All, Please keep in mind that this is NOT a self promotion area. This is about hosts you use or have used and their quality. Further self-promotion will result in action against your account, up to and including banning.

Alright... I thought I'd post an update here. Over the past few days I've had issues with SmartFTP so I decided to give FileZilla a better shot. I'm definately using Filezilla now but there are a few features I miss about SmartFTP (mainly the ability to connect to more than one site at a time).

Added surpasshosting.com

.... thanks for the definitions, but I think most of us knew that.

Thanks for the comments.  I tend to agree with you that people should be writing their own code when they start out.  It helps to understand the client/server interaction and helps tremendously in the debugging process! I'm going to copy your link into the opening post.

I think we're talking any kind of editor.... hell, TopStyle Lite is a stand-alone CSS editor.

If you have any additional suggestions, PM either one of us or any of the mods and we'll add to the list. I've added 1and1.

This is a new board with the intentions of reducing repeating questions. All of the topics in this board have been asked dozens if not hundreds or thousands of times. Some of the these topics are even covered in tutorials on the main website (http://www.phpfreaks.com/tutorials.php). If you know of any additional material that needs to be put in here, PM myself or steelmanronald06 and we will see that it gets added in one fashion or another. Thanks for reading and good luck in all your coding endeavors!