Consider the following scenario: There are couple of entities in my Laravel application like the following: Post Page Image Video All the above entities can have CustomFieldValues, which is another entity. The structure of the custom_field_values table is as follows:…
I have a table with 2M records and everything works fine until few hours ago. suddenly it throw error on a query that previously works fine for more than 1 year. The problem is that inserting a correct dateTime like…
I have tried my best to google this issue and I think maybe I am just doing something wrong that I don't understand? I have a small PHP page that generates some JSON for me from a database for use…
I have a csv file which it has a Polish characters too. The content of this is here: ID_WORKER;FNAME;LNAME;WORKERS_GROUP;POSITION; 1;Paweł;ĄąĆćĘꣳŃńÓ󌜏źŻż;IT;IT Specialist; 6;Dawid;ĄąĆćĘꣳŃńÓ󌜏źŻż;Technologists;Technologists; 8;Maciej;ĄąĆćĘꣳŃńÓ󌜏źŻż;Storekeepers;Storekeeper; As you see it has these characters like "Ąą Ćć Ęę Łł Ńń Óó Śś Źź Żż".…
MySQL was working fine and then for no reason I start getting this error whenever I open http://localhost/phpmyadmin/ I spent hours here trying to find solutions but all what I've tried did not work. can someone please help me? I…
I'm showing MySQL table results on my page and I'm trying to highlight the rows where the Next review date is earlier than today's date, these rows should be colored red (later I would want another coloring as well, today+10…
I have a clean new mysql database on my localhost, and also I have a project built on codeigniter PHP framework and have a copy of that project database. However, when I import the database into my clean new database…
I have a table "rota" where volunteers submit the shifts they are available. They can submit more than 6 shifts, but 6 is the minimum required. I want to see how many volunteers have selected each of the shifts, but…
Attendance Portal in PHP I am facing problem at Final Attendance Report Generation I'm stuck at the final stage of the Project: I have a Table- attendance, If a student is Present I mark it as 1 if absent 0.…
With Laravel/Lumen eloquent I can get count relations like this: User::withCount('views')->get(); this will use SQL select `users`.*, (select count(*) from `views` where `users`.`id` = `views`.`user_id`) as `views_count` from `users` and return all models with views_count attribute, great. But I need…