We want to create a view counter per post (https://my-domain.com/posts/post-title) and we want to store views per day to allow posts to be sorted by "Most popular in the last 7 days", "Most popular in the last 30 days", etc.…
The code below is for a project I'm working on. I'm having some issues with my PHP code and am in need of help. I have a button on my data table named "Export". When the button is clicked, I…
I am currently working on an script that will easily import an backup in 2 clicks, but i can't find any information on how to import and .gz file. and .sql file works great but if im going to decompress…
I am using CentOS 7.4.1708. Current environment have no internet access. So I installed docker (and docker-compose) from binaries. At first, I encounter below error, found that is related to selinux with docker. So I disable selinux. [root@DB1 mysql-docker]# docker-compose…
I had a laravel 7 app I developed on my local (MAMP). I now want to set it up on my website hosting account (apache2, php7.4, mysql server). I did a git pull to pull down all the files and…
I have a java web application which runs on tomcat. I am using Quartz 2.3.0 (Updated to 2.3.2, still not working) I am initializing quartz with Properties as follows: Properties properties = new Properties(); properties.put("org.quartz.scheduler.instanceName", hostname); properties.put("org.quartz.scheduler.instanceId", hostname); properties.put("org.quartz.threadPool.threadCount", "5");…
While designing the database for a laravel software using MYSQL, is assigning foreign keys relevant or does Laravel take care of that "Software side". In the migration we have something like Table Example: $table->unsignedBigInteger('user_id'); should i modify the example table…
There are 2 samples. In the first example, it gives faster results when using orderby. (according to phpmyadmin speed report) In the other example, I don't use order by, it gives slower results. (according to phpmyadmin speed report) Isn't it…
I have an java spring / hibernate application and I cant create a connection beween the mysql and java containers. When I start just the mysql Container and run the java application manualy in CMD it works fine. But once…
I have hosted my Laravel project on Shared hosting. Everything works fine on local but my main problem is in Phpmyadmin when i imported my sql file into it. In my local i every table has primary key, auto increment…