Questions tagged as 'phpmyadmin'

Tagged questions
0
answers

Can not add or update to child row: a foreign key constraint fails

When I try to execute a SQL function within PHP this error occurs:    Can not add or update a child row: a foreign key constraint fails   ( db_inventory . vendedor , CONSTRAINT idCiudadVendedor FOREIGN KEY   ( id_ciudad_...
asked by 21.08.2018 / 19:11
1
answer

I do not get the exact value of a session variable in php

I am working on an online course system (class project) and I need to make a form where a user adds the necessary lessons for each course, but at the moment of clicking the aggLeccion button, he sends me data with the variable of another record....
asked by 31.07.2018 / 04:05
0
answers

Modifications in table [closed]

-- phpMyAdmin SQL Dump -- version 4.7.9 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost:3306 -- Tiempo de generación: 20-07-2018 a las 10:11:28 -- Versión del servidor: 10.2.16-MariaDB -- Versión de PHP: 7.1.17 SET SQL_MODE = "NO_AUTO_...
asked by 20.07.2018 / 12:21
2
answers

Why do you throw the following error when clicking on the table of my jFrame?

Basically schedule a view in which I could enter data, modify, elminate, so that if I clicked on the table it would let me modify the data that I want, the problem is that it throws me an error that I do not understand and this does not let me m...
asked by 19.07.2018 / 11:17
0
answers

What is the error in my PHP? [closed]

<?php extract($_POST); if ($action == "upload") { //cargamos el archivo al servidor con el mismo nombre //solo le agregue el sufijo bak_ $archivo = $_FILES['excel']['name']; $tipo = $_FILES['excel']['t...
asked by 13.07.2018 / 01:57
0
answers

Button to debug table phpmyadmin

I make a form and what I need to do is make a button that debug my table calculations this so that it empties my table so that new data are inserted , I do not know how to do it by means of a button instead if I do it directly in SQL which is...
asked by 08.07.2018 / 01:06
1
answer

I have a problem with my edit button

I already have everything, I just need the edit button but it is not edited, I pass the HTML and the php. <?php include('php/registrar.php'); if (isset($_GET['edit'])) { $id=$_GET['edit']; $editar_estado=true; $r...
asked by 04.07.2018 / 22:02
1
answer

Error # 1005 when exporting DB

Hello, I'm exporting a workbench database to phpmyadmin and I get this error # 1005: #1005 - No puedo crear tabla 'medico'.'citas' (Error: 150 "Foreign key constraint is incorrectly formed") CREATE TABLE IF NOT EXISTS 'Medico'.'citas'...
asked by 27.05.2018 / 17:52
1
answer

Error in Trigger "AFTER INSERT ON ..." from MySql

I'm having problems with creating a trigger in mysql, but I do not know why it's causing me an error. The table in which I want to insert once the trigger is activated is the following: CREATE TABLE 'reportes' ( 'id' int(11) NOT NULL, 'tip...
asked by 26.05.2018 / 07:50
2
answers

Where are the phpmyadmin BLOB files stored?

I'm doing a program where I send images from any device to my computer's database on phpmyadmin, and it shows me the images in the browser. I am using the type longblob for the images and the images are saved in .bin format....
asked by 22.05.2017 / 05:04