Jeff MadsenSUBQUERY to find waiting period after multiple occurancesOh, dear! What a title! Let me explain the situation up front, so you can see what this is about (and understand why it was so hard to…Dec 20, 2021Dec 20, 2021
Jeff MadsenENUM and ORDER BY FIELD — customized sorting in mysql“…and we’d like the jobs sorted by Started, Pending, Finished, please.”Dec 20, 2021Dec 20, 2021
Jeff MadsenSql puzzle: Returning CustomersIt’s the end of the month, and your store manager comes to you with a request. The store ran a special promotion in the third week of…Dec 20, 2021Dec 20, 2021
Jeff Madsencodebyjeff — Single Table Inheritence in Laravel: No more If’sRecently I watched Misko Hevery’s talk “The Clean Code Talks — Inheritance, Polymorphism, & Testing” and was particulary struck by his…Dec 20, 2021Dec 20, 2021
Jeff Madsencodebyjeff — Laravel Quick Tip: orderByRaw() with ORDER BY FIELDJust a quick tip that really extends an old post from here about MySQL’s ORDER BY FIELD ( ENUM and ORDER BY FIELD — customized sorting in…Dec 20, 2021Dec 20, 2021
Jeff Madsencodebyjeff — Eloquent Create, Update, New…the Untold StoryTag: Laravel 5.1+, EloquentDec 20, 2021Dec 20, 2021
Jeff MadsenTime left strings with Carbon and Laravel string helperTag: Laravel 5.0+Dec 20, 2021Dec 20, 2021
Jeff MadsenHello, Mr. asdfgh qweefg! Welcome to kgjhjgjh!Tag: Laravel 5.0+, FakerDec 20, 2021Dec 20, 2021
Jeff Madsencodebyjeff — Getting into an Eloquent State of MindTag: Laravel v5.0+Dec 20, 2021Dec 20, 2021
Jeff Madsencodebyjeff — The Mahana Bitfield Library for Settings SanityTag: PHP v5.0+Dec 20, 2021Dec 20, 2021