Questions tagged as 'mysql'

Tagged questions
1
answer

Error registering the data in a mySQL database with PHP

I'm new to PHP and mySQL. The problem is, that error appears when I want to enter data from a form to a database, I do not get syntax errors but here is the code, I hope you can help me. <?php $conexion = mysqli_connect("localhost", "root"...
asked by 22.05.2018 / 03:20
1
answer

Fail to Reconnect Mysql in NodeJS

Good morning I have the following service to manage connections to mysql var mysqlService = require( 'mysql' ); import { config } from '../../config'; var connection; function handleDisconnect() { connection = mysqlService.create...
asked by 11.04.2018 / 11:00
3
answers

Concatenate values from the same field

I have a query that brings me this data, as you can see it brings me the same tasks because it has 2 users that handle it, I want you to help me concatenate it So that it is like this other and so reduce me the records that do not need...
asked by 10.04.2018 / 18:51
1
answer

how to rename an image when saving in a database

I want to save an image in the database but at the time of saving, if 2 have the same name one replaces the other, as I check that if there is one with that name, I will change the name to the other one. at the moment like this I have the cod...
asked by 11.04.2018 / 19:18
1
answer

Convert clause "In" sql to laravel 5.6

I need to be able to pass the following query Sql containing the clause "In" to eloquent in laravel 5.6 and that I could not perform. SELECT sum('monto_facturado') FROM 'peticiones' WHERE 'id_presupuesto' IN ( SELECT id...
asked by 07.05.2018 / 22:11
1
answer

Edit and delete mysql records from datatable

I have adapted an example of datatable with a datepicker. Now I want to add the functions to edit and delete records. I have another example with which I can edit and delete rows from the database, but I am not able to adapt it to make it work i...
asked by 22.04.2018 / 19:25
1
answer

Problem with sql query in only_full_group_by mode

I have the following problem. A table tb_cs of which I give a theoretical example: id idcontrato idproducto cant 1 C1 IDP1 2 2 C1 IDP2 3 3 C1 IDP1 2 4 C1 IDP3 1 The problem i...
asked by 23.04.2018 / 21:16
1
answer

How to validate the duplication of records called from BD with PHP and Ajax

I have a table where the information I send from my BD is shown through a field called DN, the detail is that I need to validate that when calling twice or more the same DN does not appear on my information table if not once. listing.html...
asked by 25.05.2018 / 18:42
1
answer

Add in total MYSQL

I have these two tables: REPORTEBETEITIVA _______________________________________________________ | idReporteBeteitiva | HorasTrabajo |Trabajador | ------------------------------------------------------- | 1...
asked by 25.05.2018 / 23:35
2
answers

perform query and condition update

Specifically, I tried a lot of things and it did not work out or I got messed up trying so hard. I have 2 tables Summary and Detail What I'm trying to do is get all records for a DNI in the DETAIL table, on the result check the values...
asked by 04.04.2018 / 04:47