Today I upgraded from Homestead 4.0.0 to 5.0.1 so I could test my sites in PHP 7. That was a major upgrade and a number of things changed, so I decided that I needed to back up my databases before I did the upgrade. I’d only ever dumped specific databases before, but TIL how to dump them all at once. Here is how to do that in Laravel Homestead.
At Praxis we use Restrict Content Pro as the membership system for our curriculum portal. We decided that all grads get access for life, not just during the program. So, I needed a way to clear over 200 member expiration dates. Here is how I accomplished that task with SQL.
Today I learned about Many-to-Many relationships in relational data models
TIL how to concatenate columns and convert time in Excel and some more SQL functions.
TIL how to make aliases for tables in SQL and how to sort tables with jQuery
TIL how to hide my TIL posts from the front page of my site, the Unless tag, and inserting mysql with PHP.
TIL the basics of connecting to a MySQL database and creating tables in PHP.