I have a table chatmessages that has a chatId, incomingId, outgoingId column, and I have another table chatmembers which has a chatId, usersId column. Also another table chat that contains only the chatId, and the usersId initializer of the chat…
Im Not Sure What the issue could be I am able to store the data from the form in variables display them the input does not throw an error but nothing is in the table. I am using Mamp. <?php…
I'm building a Django (ver. 3.0.5) app that uses mysqlclient (ver. 2.0.3) as the DB backend. Additionally, I've written a Django command that runs a bot written using the python-telegram-bot API, so the mission of this bot is to run…
I was trying to deploy multi containers docker into Elastic Beanstalk. But it doesn't work. I tried running on local by using the docker-compose it is working. Below is my Dockerrun.aws.json and docker-compose.yml docker-compose.yml version: '3' services: nginx: image: nginx:alphine…
I am working on a project where data about therapists is stored in a database, I have 5 dropdowns on my page and I want the data to be fetched based on the dropdown values selected by the user. <div…
I am quite new to Laravel, especially when it comes to retrieving things from a database. After reading their documentation about query builder, I found a section that shows example code to do exactly what I need: If you don't…
I have come accross a strange issue, I have deployed a django site to an Ubuntu 20.04 LTS server. The problem is my django app can not connect to the database because It is doesn't using the db connection credentials…
The Idea of the Query is to get all the entries where the seo_path_info has duplicates and the corresponding product is set to active. My Query is: SELECT `seo_path_info`,COUNT(`seo_path_info`) FROM `shopware`.`seo_url` seo GROUP BY `seo_path_info` HAVING COUNT(`seo_path_info`)>1 LEFT JOIN product…
I want to insert/update decimal number to mysql. But everytime I did. It return the round number or truncate dot number. I tried change the datatype of lv_pay and lv_dis either to decimal and double but still the result. MySQL…
I've recently upgraded MySQL to version 5.7.35 and PHP to version 7.4.21. This PHP script is failing to enter the data into 'my_table' $hoje = date("Y-m-d H:i:s"); $stmt = $db->prepare("INSERT INTO my_table(teste_id,data) VALUES (:ftesteid, :fdata)"); $stmt->bindParam(':ftesteid', $testeMaisRecente, PDO::PARAM_INT); $stmt->bindParam(':fdata', $hoje,…