Questions tagged as 'mysql'

Tagged questions
1
answer

Check if "tag" is available and show it in a SELECT

I realize a system that basically is a logs of loan equipment. What I intend you to do is that users who need a computer to loan make a record, which is necessary to validate if the equipment is available or not for its use, and only appear in...
asked by 27.06.2018 / 08:50
1
answer

Calculate the average consumption

I have a table in a database: consumo pk_consumo fk_ruta fk_vehiculo fecha kms litros litrosx100 ----------------------------------------------------------------------------- 1 1 1 2018-04-25 3...
asked by 26.04.2018 / 08:58
2
answers

MYSQL query from JAVA

Good I am trying to put data that are not of type String in my bd made in netbeans, I need a double and a int , but when putting them I get an error, things that do not happen if I do with a String , I leave here the fr...
asked by 25.05.2018 / 23:13
1
answer

Upload images and pdf files with php and mysql

Hi, I have this code that I have been able to assemble, I only upload the images, but when I select a pdf file, it is not saved in the indicated folder, they could tell me what my error would be, this is what I have function AgregarRecepcionCe...
asked by 19.04.2018 / 19:49
1
answer

Create a history table with trigger or html, mysql php

I have a table of people and I want to make a history of changes in a table only if I change the level or year that is inserted into a table called history, I do not want it to be inserted if I update its address. ONLY if I update your level...
asked by 13.04.2018 / 00:16
1
answer

Is there anything similar to full text searches in laravel?

I intend to show any row that contains at least one of the searched words, and in case of coinciding in several, that orders it from higher to lower number of coincidences. I have found information about the Like wildcard with laravel, but I...
asked by 01.04.2018 / 06:44
1
answer

Problems when trying to update with pdo

Trying to edit a 'Course' generates this error, SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens My form: <form action="vista%20normal.php?pagina=administrar_cursos" method="POST" enc...
asked by 12.04.2018 / 10:57
1
answer

HOW TO MAKE A VARIABLE REGEXP

SELECT CONCAT(per.apellido," ",per.nombre) AS alumno,per.dni as dni,car.descripcion,per.correo , jor.descripcion as nombrej FROM persona as per INNER JOIN inscripcion as ins on ins.id_persona=per.id_persona INNER JOIN jornada as jor ON jor.id_jo...
asked by 31.03.2018 / 23:48
2
answers

Compare input data with records in MySQL

I have an input in HTML with AJAX which enters a 4-digit code with a button to send to a database in MySQL, until now everything is perfectly inserted, and registered in the database. Now I have to compare that data that is entered in the inp...
asked by 02.04.2018 / 18:10
3
answers

Group By consultation with Order By do not work together

I have the following query: select * from tblreviews WHERE Estado=1 group by Website ORDER BY fchFecha DESC limit 5 In which only the part of the group by works for me but it does not order the result in the most recent date. Tha...
asked by 10.08.2018 / 18:30