I have this query and works fine: SELECT id_categoria, categorias.descricao_categoria, MAX(CASE WHEN month(data_compra) = 1 THEN valor ELSE NULL END) as Jan, MAX(CASE WHEN month(data_compra) = 2 THEN valor ELSE NULL END) as Fev, MAX(CASE WHEN month(data_compra) = 3 THEN…
I'm using this code to update my datatime field to NULL, php version 7.3.7 if($_POST['value']=='0000-00-00 00:00:00'){ $timestamp=NULL; }else { $dateTime = $_POST['value']; $timestamp = date('Y-m-d H:i', strtotime($_POST['value'])); } $query="update forms set $_POST[limitInputField]='$timestamp' where formid='$_POST[formId]'"; $result=$dbCnn->query($query)or die($dbCnn->error); it gives error when…
Okay, so. I have PDO connection on MySQL database on local server. This is the code for it <?php $servername = "localhost"; $username = "root"; $password = ""; try { $dbh = new PDO('localhost:host=$servername;dbname=test', $username, $password); $dbh = null; }…
Problem: some product sku look like this "67062-4D" or "MOD602-04-N". So task is to find sku by its digits when user uses search, e.g. "67062-4D" by "670624" and "MOD123-45-N" by "12345". Solution: I managed to solve this by repeting [^0-9]*1…
I made a Wordpress plugin that imports some products (few hundreds) from API to Woocommerce. The problem is that after about 10 minutes (max execution time is set to unlimited) I'm getting this error multiple times with option_name different (there…
I am trying to get the sum of particular field. I am getting the SUM wrong when I try to get the values together. I have this: reference: id_skill, user, level_paid More specifically the table reference as: id_skill user level_paid…
I have a table: Rank Title Genre 1 Guardians of the Galaxy Action,Adventure,Sci-Fi 2 Prometheus Adventure,Mystery,Sci-Fi 3 Split Horror,Thriller 4 Sing Animation,Comedy,Family 5 Suicide Squad Action,Adventure,Fantasy Is there any function that I can count how many distinct text contain in…
This is what I'm doing at the moment in my index I made this button <a class="btn btn-warning" href="map.php?id=<?php echo $fila['id']?> "> <i class="bi bi-geo-alt-fill"></i> </a> Then I made this in another file I got this php code <?php $conn…
I have three entity employee , info, and address , i want mapped employee entity with info and address entity by using onetoone mapping by using hibernate and jpa annotation. @Entity public class Employee { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private…
I am running into this issue when I try to run pip install mysqlclient. I have already installed all the libraries necessary with brew and/or pip. I tried reinstalling zlib but nothing seems to be working. I tried downloading on…