Hello there, I'm Mathieu and I'm a developer by day and a designer by night. I'm passionate about applications, games and websites.
Currently working fulltime with Laravel, React, Filament and Unreal Engine (C++ & Blueprints). Feel free to connect!
I was working with raw queries and selects in Laravel in combination with Laravel’s Cursor Pagination. This worked fine until I want to the next page.
If you encounter the following error in combination with selectRaw() or whereRaw() in Laravel, I hope this solution works for you.
SQLSTATE[HY093]: Invalid parameter number (Connection: mysql, SQL: ...)
I’m always drawn to dystopian style in movies, games and books. I think this love for (more cyberpunk) artform comes from my childhood game “The Longest Journey”. Especially the Stark version of the game. Fortunately for me, the world is filled with filled with this kind of worlds. Fiction and non-fiction.
Whenever you work with searching in MySQL you are quickly using fulltext in boolean mode. This is a powerful way to finetune a search but has it limitions with special characters, like the at-sign.