I have a problem, I've spent a lot of time on. I have to display the pairs of items (Item1, Item2, How many) that appear on the invoices - and how many pairs have repeated. The table that connects invoices…
I am trying to create a text box and whenever a user enters a message and clicks on send, the ajax should be activated and what's on insertMessage.php should get triggered. However, whenever i click on send it doesn't work.…
I have 3 select option for searching the records in datatable with ajax jQuery php. I have write this code but select option data is not going to other page & not returning back from ajax request. PHP Code:- <form…
i have MySQL data which is imported from csv file and have multiple duplicate files on it, I picked all non duplicates using Distinct feature. Now i need to delete all duplicates using SQL command. Note i don't need any…
Deploying to Heroku and having trouble uploading an SQL export from phpMyAdmin SQL Export Settings: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; Create Table CREATE TABLE `posts` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `title`…
I find that mysql always try to auto-upgrade in the booting stage: sudo journalctl -b -l | grep mysql Feb 04 13:05:35 mydebian mysqld[713]: 2021-02-04 13:05:35 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 713 ... Feb 04 13:05:35 mydebian…
I have a trigger BEFORE INSERT that contains: set new.order_id = concat(new.account_id, '.', lpad(new.id, 4, '0')) Now when I try to insert some data with php like this: $insertorder = ' INSERT INTO orders ( producten ) VALUES ( "'.$conn->real_escape_string($encodedproductenarray).'"…
So i am trying to login to my site via steam api and this error pops up SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null. SQL: insert into `users` (`name`, `steamid`, `avatar`, `token`, `ip`) i use laravel php7.0…
I need to take value ecotax from table ps_product for id_product and update value ecotax on same id_product in table ps_product_shop. Make this command: UPDATE `ps_product_shop` SET `ecotax` = (SELECT `ecotax` FROM `ps_product` WHERE ps_product.`id_product` = ps_product_shop.`id_product`); but get: #1048…
I have Laravel running in Docker with 3 containers - Nginx, MySQL 8 And PHP 8. I have the following docker-compose.yaml version: '3.8' services: server: build: context: . dockerfile: dockerfiles/nginx.dockerfile ports: - '8000:80' volumes: - ./src:/var/www/html - ./nginx/nginx.conf:/etc/nginx/conf.d/default.conf:ro container_name: server…