Questions tagged as 'mysql'

Tagged questions
1
answer

How to make a relationship with dependence of two tables in mysql?

Good morning, I have the doubt of how to make a relationship of two tables where: the column n_employed of the table entry_register can not be filled without that same data (number of identical worker) existing previously in the record table. th...
asked by 30.05.2016 / 04:56
3
answers

Error validating existing user in the DB with PHP

What a good day, when trying to validate a user in PHP I execute the var_dump () function and it returns bool (false) which is incorrect since I am entering a user that does exist in the database so which should show me true, it took several day...
asked by 10.05.2016 / 21:00
2
answers

NetBeans, Connect to a Database [closed]

Hello, I am developing a basic program that consists of connecting netbeans to a database via mysql, the problem is that I do not know what to do, it is assumed that this database should not only be on one machine but on several machines. should...
asked by 31.07.2016 / 06:53
1
answer

mysql query does not work

The query does not work for me. What am I doing wrong? update users set hasCredit = 1 where users.id = (select users.id from users inner join creditRequest on (users.id = creditRequest.user_id))     
asked by 02.09.2016 / 17:42
2
answers

Passing rows to columns in mysql

Does anyone know how I can pass the rows of a MySql query to columns? I have been searching and I find that SUM or GROUP_CONCAT can be used but I do not fully understand the examples, thank you in advance. I managed to solve that problem with...
asked by 30.08.2016 / 23:40
1
answer

Show image stored on server in php

I'm trying to make a photo gallery to learn a bit about programming in php, but I've been stuck when it comes to wanting to show the images. The images are stored on the server and the path in the database. The problem is that all the div tha...
asked by 31.08.2016 / 22:30
1
answer

Problem when extracting data from a weak entity with a foreign key in MySQL

I have a small problem when trying to extract all the data of a weak entity that I have created between a table called Doctor and another patient. When I do the query, I extract the data correctly but in triplicate, that is, instead of returning...
asked by 26.12.2018 / 14:39
1
answer

Error creating a Trigger

I'm trying to create the following trigger: DELIMITER // CREATE TRIGGER 'smdraux_after_insert' AFTER INSERT ON 'smdraux' FOR EACH ROW BEGIN IF(LENGTH(NEW.llamante) = (4) AND NEW.nombreinterlocutor1 NOT LIKE 'VM Channel%' AND NEW.nombreint...
asked by 02.01.2019 / 17:58
1
answer

Error with PHP "Notice: Undefined index:" and does not connect to DB

Good I am trying to save comments in BD but it returns me the error that appears in the title of this question. I have the following FORM in an index.html <html> <head> </head> <body> <form id="form" action="g...
asked by 02.01.2019 / 20:00
1
answer

Problems with PHP: password_verify ()

I have a problem with password_verify() , apparently it is not comparing the password and the hash, no matter what I do it always results in error, my code is as follows: try{ $base = new PDO("mysql:host=localhost; dbname=usuarios","...
asked by 25.09.2016 / 20:40