Questions tagged as 'mysql'

2
answers

SELECT pii2 FROM 'surveys_egresados' WHERE pii2 = 'Very good' BETWEEN date = '2017-01-01' AND '2017-01-01'; [closed]

I have a syntax error in the following statement SELECT pii2 FROM 'encuestas_egresados' WHERE pii2='Muy buena' BETWEEN fecha ='2017-01-01' AND '2017-01-01' ;     
asked by 21.12.2017 / 00:10
2
answers

Get current hour and minute mysql

I would like to know how to get only the time and minute current in Mysql since I have tried several options The first one shows me hour, minute and second, the others do not work for me. select time (NOW()) as hora select DATE_FORMA...
asked by 10.05.2017 / 19:29
1
answer

SQLSTATE [23000]: Integrity constraint violation: 1062 Duplicate

It turns out that I have two tables: Label and Priority the fields in the tag table: id priority_tag_id name image the fields in the priority table: id name and so are my tables: And then I execute the follow...
asked by 11.05.2017 / 04:36
2
answers

Query in MySQL from PHP

I am adding a record in MySQL from PHP , but I get the following error message.    "Notice: Undefined index: id in ..." "Notice: Undefined index: name   in ... "" Notice: Undefined index: sex in ... " This is the code snippet. $identi...
asked by 07.05.2017 / 03:31
2
answers

Load a csv file to full MySQL

I'm trying to upload .csv files to MySQL, but when uploading the file does not load the complete records, for example from a file that contains 100 records only uploads 85. I would like to know if this error is some configuration on the server o...
asked by 20.04.2017 / 19:46
2
answers

Error generating excel with PHPExcel

I have a generic method that is responsible for generating the excel I need, what I send to the method is the resource of a query, the method is responsible for tracing the result to generate the excel with culumnas and corresponding rows. As...
asked by 26.04.2017 / 22:07
1
answer

Upload multiple images with id from another table? [closed]

I am trying to upload multiple images when creating a new product and save those images in a table called galeria next to id of the product created. The error I have is that the id and the date are saved in the galeria...
asked by 28.04.2017 / 10:19
2
answers

How to give value to a data taken from a serializaArray and send it by AJAX?

I have a tabla called 'individuos' , it has basic data like (id, no.identificacion, nombre completo, depen_serial(INTEGER)) among others ... (to avoid any 'wrong' comment, this is how it is stipulated :: ..) depen_ser...
asked by 07.03.2017 / 16:06
3
answers

How to change my icon by clicking jquery DATATABLES?

I have a table which I have put an image as an icon (+) <--"abrir" , which when you click there throws me a child.rows showing more information, what I want is that by clicking automatically I change the image or icon for (-)...
asked by 01.03.2017 / 15:00
1
answer

Get ajax checkbox values

the following happens to me I am driving a system which has 2 checkboxes <div class="form-group"> <input id="admin" type="checkbox" class="material_checkbox" name="admin"> <label for="admin">Administrador</...
asked by 10.02.2017 / 02:30