Questions tagged as 'mysql'

Tagged questions
0
answers

"Select from (Select" Subquery a doctrine dql

I have made a query to the database to get the actual availability of the rooms of several hotels but when trying to make the query with doctrine in symfony 3.4, I get an error. This is the query: SELECT (CASE WHEN count(_days) > 0 THEN...
asked by 08.06.2018 / 08:39
2
answers

Unknown column in 'on clause' - SQL Error (1054)

First of all indicate that I have tried to find my answer here but I can not find any example that resembles mine. I want to get the data from an activity table with its corresponding documents, but the ACT table is apparently not visi...
asked by 08.06.2018 / 07:09
0
answers

Calculate time between date and time fields

Good day everyone, please if you can help me, I require the following: -I have 4 fields:  start_time, end_time (time)  start_date, end_date (date) There is a table that contains these records. It is required to calculate the time between t...
asked by 05.06.2018 / 13:44
1
answer

Dates driving datepicker

I'm doing an employee control system, my problem is with the dates since I do not keep them as I should, this code is the one I use to collect the data within a form <?php //conectar a la base de datos include "conexion.php"; //realizar c...
asked by 05.06.2018 / 14:34
1
answer

Storage procedures in Laravel does not return more than one table

I have a procedure stored in mysql that returns 3 tables, but when invoking it with laravel it only shows me the contents of the first table. route::get('/prueba/{id}','Emergencia\AsistenciaMedicaController@prueba');   ...
asked by 12.06.2018 / 04:40
0
answers

Invalid JSON response with jQuery Datatables

I have a problem that when loading data from a MySQL database with PHP, it does not show the data, which I send with a JSON according to documentation of Datatables loading data with Ajax then I present my files. Below I present my files....
asked by 12.06.2018 / 01:22
1
answer

Results in the form of url and not the name of the MySQL table

The problem is that when I do a search, I get a result but it is not visualized in the way I expect. When I make the query on the local server, it gives me the expected result: SELECT TABLE_NAME FROM 'INFORMATION_SCHEMA'.'TABLES' WHERE TABL...
asked by 12.06.2018 / 08:22
1
answer

remove product from product table that is related to sales note

Hi, I'm a newbie in web programming and I just finished my first website in my professional practice and the company was satisfied, only my question is for example I have my BD which has a table related to a table. sale, the doubt in particular...
asked by 31.05.2018 / 03:47
0
answers

Problem when updating an image path (Java - MySQL) - Skip the "\"

I am updating a record in a database, when loading the user I am placing the path of your photo in a hidden TextField, but when updating the record, you are saving the path but without the "\" (see image) ). For example, save the path like th...
asked by 31.05.2018 / 15:26
0
answers

Does not recover anything from the database if it does not refresh the context of the application

Very good, I hope you can help me. It turns out that I'm working on a web application, and I have the following problem (which I later found out about what happens with all the applications). I have a database of a computer store, and the fir...
asked by 02.06.2018 / 17:46