I have a DB (MySQL) with some tables. I have a relation ManyToMany but when I try to delete a field, i receive the error: #1451 – Cannot delete or update a parent row: a foreign key constraint fails (`users_courses_premium`, CONSTRAINT `FK_USCO_COID` FOREIGN KEY (`COURSE_ID`) REFERENCES `courses` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE) My ..
Category : phpmyadmin
How to get the data as represented in this image using sql query.please help. Source: ..
I’m using Android Studio App to submit data, sometimes when I submit there will be duplicate entry. The submission time is the same as well. I have checked my Android studio code and it seem fine. The following is my query: <?php if ($_SERVER[‘REQUEST_METHOD’] == ‘POST’){ $area = $_POST[‘area’]; $date = $_POST[‘date’]; $batch = $_POST[‘batch’]; ..
I have a table full of city names and I need to find all the citys that contain the letter "a" at least five times. So far I got: SELECT stadt.Name FROM stadt WHERE stadt.Name LIKE ‘%a% But this shows me all the citys with an "a". I need to have a code where I ..
How to get the user id of the currently logged in user from inside a function in php? I know how to get it in a index.php (by getting $_SESSION[‘userid’]) but I cant get it from inside a functions folder function createJob($conn, $jobname, $joblocation, $jobdate, $jobsalary, $jobdescription) { $userid; $sql = "SELECT * FROM users;" ..
this is probably a very rookie mistake (I`m totally new to SQL), but I hope you can help me. I have written some SQL code in Sublime Text. When trying to paste it into PHPMyadmin (web) I get som error messages. I think the code is right, so it seems like something happened to the ..
I create Docker container for MariaDB database and phpMyAdmin. When i run the container use Docker Compose i cannot access the phpMyAdmin web on http://localhost:8080 Here is my docker-compose.yml version: ‘3.8’ services: database: container_name: database image: mariadb:10.5.8-focal restart: always ports: – 3307:3306 environment: MYSQL_ROOT_PASSWORD: secret volumes: – ./data:/var/lib/mysql – ./entrypoint:/docker-entrypoint-initdb.d networks: – db-network phpmyadmin: container_name: ..
I’m trying to use SMTP for my forgot password. I’m found success in receiving the code via Email. I used a tempmail for testing. However, when I check my database – the id does not increment, the code shows but only the first 4 digits and email is none. This is how the query looks ..
I have this table in phpmyadmin table and I already have the connection and the value is stored here $row["Risco"] and I have this table that are squares squares .tabela-botoes-extincao{ width: 100%; height: 90px; padding-top: 30px; padding-bottom: 20px; font-weight: bold; } .espaco-botoes-extincao{ width: 14.28%; height: 90px; background-color: #cfcfcf; font-size: 19px; font-family: sans-serif; } .extincao-ativo{ background-color: ..
I am new to database in general. I am currently running a MYSQL database in ubuntu server using vmware. I have managed to install PHPmyadmin, apache2 and php7 in the server. In PHPMyAdmin, I tried to create a database called "testing" and a table called "test" with 2 columns "username" and "password" However, when I ..