Questions tagged as 'mysql'

Tagged questions
0
answers

Save array in BD with laravel 5.5

I have a create for the registration of users where there is a MULTIPLE SELECT to assign several entities to the user. And he throws an array for each option I frame. So I have the multiple select: <label for="entity_id"&g...
asked by 02.11.2018 / 15:34
0
answers

PHP MySQL Multiples Querys

I have the following code where I run 3 Updates, the strange thing is that when executing it does not appear any error, that is to say that it executes everything well, but when consulting the BD it did not make any change, and if I remove 2 Que...
asked by 02.11.2018 / 14:36
0
answers

I do not register in the database but in the window it says "Data was saved correctly". Is there a possibility of an error here?

I attach the images of the html and php codes     
asked by 02.11.2018 / 03:30
0
answers

Fatal error: Uncaught Error: Call to undefined function mysql_connect ()

I would like you to help me solve this problem, the following error appears on a page I am designing Fatal error: Uncaught Error: Call to undefined function mysql_connect () in G: \ Pagina \ comentarios.php: 11 Stack trace: # 0 G: \ Pagina \...
asked by 04.11.2018 / 09:27
2
answers

I need to put together a phpmyadmin SQL to list a table with the companies and contracts that I have to pay in the current month and that if I do not already pay the list

SELECT a.cod_contrato, a.cod_anunciante, a.presupuesto, b.cod, b.mcuota, date_format(b.mesdpago,'%d-%m-%Y') AS mesdpago, c.cod, c.nom, c.cor1, c.tel1 FROM espacios_publicitarios.anunciantes AS c INNER JOIN espacios_publicitarios.contratos AS a O...
asked by 01.11.2018 / 11:51
1
answer

When a date type field is saved in the database, it is saved with a date from a previous day

I am programming an application with the following technologies: Java, Spring, Hibernate, Maven, Msql. The IDE that I am using is Eclipse. The problem that I am having is that when an entity persists, one of its properties is of Date t...
asked by 04.11.2018 / 02:22
1
answer

Laravel- Trying to get property 'name' of non-object

I am developing a product catalog system with Administration Panel in Laravel 5.5. I've finished it and everything works, except that I can not filter my products. When I do the function: dd($products); to verify if it does filtering,...
asked by 01.11.2018 / 22:28
1
answer

dates greater less than

Buneas, someone knows in mysql in a query to bring you a date given in the future and put this but it also brings me 2018-10-20 and 2018-09-25 SELECT idval_val AS id, val_fecha_registro AS fecha_registro, val_nom_contacto AS contacto_nombre,...
asked by 02.11.2018 / 00:07
1
answer

Save several records from a range of dates [closed]

I have 2 datepicker (Start date and End date), If the Start date is different from the final date placed in the datepicker's, as I do to create in the database a record for each day within the range of selected dates     
asked by 07.11.2018 / 13:31
1
answer

Update the value of a column of a BBDD

My problem is that I have to update the TOTAL_IMPORT field in the Customers table with the sum of the delivery notes (that match the client code, from the Customers table, that the user puts in) that are found in the Lines table. The client code...
asked by 31.10.2018 / 12:34