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?

You have no idea how much I appreciate the additional info. Most people just say 'hey... use this!' and that's all you get. I guarantee I will check that stuff out. The only thing I worry about is adding it into my current setups or having to start over from scratch. When I use PHP these days, I have to be extremely efficient. I don't have the luxury of taking 3 full days of work to figure stuff out and implement it. That's time lost on extra income for me. I have another buddy of mine trying to convince me to abandon my research on Bootstrap and start using http://foundation.zurb.com/ I would kill to be using all of the latest stuff, but I can barely keep up and crank through my existing workload! I mean I know some of this stuff will eventually greatly enhance my efficiency so I should just invest the time but I haven't yet. But I will. Thanks for a gentle kick in the pants, sir.

I still sorta live in the PHP world. I build websites on the side for a few clients but I stay away from most of the libraries as far as PHP. I have a CMS-ish/framework-ish thing that I built on my own a few years ago that has held up well over time and I keep tweaking it. I just hate the 'locked in' feeling of most frameworks so I tend to go more custom. The main PHP libraries I use these days are for the DB (www.phpactiverecord.org). That plus several JS libraries (jquery, extjs, and datatables) which allows me to drop some PHP code in favor of some front-end awesomeness has allowed me to whip through some projects pretty quickly. I never really thought of PHP as 'dirty', but it's definitely less strict than Java (I would still do PHP full time if I can find the right gig at the right salary). Anyways, I might pop in from time to time. Good to see some of the old crew is still here.

Please disregard. I'm an idiot. I was viewing the data in phpmyadmin through my account, not the new account and I was viewing the old copy of the DB. I also had the website on the new account pointing to the old database as well, hence the new data not showing up. *sigh* I should stop working so late at night. Thanks everyone for your help.

Hey gizmola, good to be back. I live mostly in the Java world these days so I haven't had much reason to stop in here. I also posted this on another forum and they brought up an interesting theory. When this started to become a problem, I had just recently moved that website from my hosting account to a separate account under my reseller plan with my host. One of the other guys suggested that it might just be a permission problem, but I don't know how to solve it. Clearly the data is all there but I guess my user can't access some of the records for some reason.

No, I don't have root access. Why do you ask?

I have a table where users insert table via a form (this is done through a Joomla module). When I view that table in phpmyadmin, it only returns 73 rows. Yet when I view the data via the module itself (there is an output portion), there are 140 rows... which is what I am expecting. I even looked at the mysql schema tables and it only sees the 73 rows. Yet I even installed another module that pulls data based on SQL queries and THAT module also sees the 140 rows. Does anyone know why phpmyadmin or my own PHP script on another page would not see all of the records? I already tried repairing, flushing, and optimizing the table... all to no avail. I'm running out of ideas. HELP?

Nice, that cleans up some usability issues quite well. The navigation crumb trail is a perfect solution for the problem I mentioned.

If you're 98% ready to go, this feedback might be a little late, but whatever. It's very......... blue. I think a lot of readers/viewers will be turned off by such a stark/bold background. There is a reason a lot of sites use white behind content. Why aren't the thumbnails on the main page clickable? You should be giving your users every possible chance to get to the content easily. If you're worried about SD vs. HD, take them to SD initially and give them the choice to bump it up. I went into the first one and there is a 'back to learning' or whatever near the top. I expected to be taken back to where I was when I clicked that but I ended up in an entirely different screen with stuff that didn't really make sense to me. When I click into a video, I kind of expect it to play automatically. Making me click again is kind of annoying. I can understand if you're trying to save bandwidth but the extra click is not as user friendly. No guitar lessons/teacher? Seems like a popular choice to me.

It's alright. Not great. The background is hugely distracting. The content areas should stand out more and be better defined and I shouldn't have to scroll so damn far to get to the content. Your header area is freaking huge.

Anyone know of a good up-to-date jQuery cheat sheet? The most recent I can find is 1.4 and they're on 1.7. Edit: scratch that. Changing my google search turned one up: http://woorkup.com/2011/12/05/jquery-1-7-visual-cheat-sheet/

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.