Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with variables Date in Spring Boot - Angular 6

When dealing with data of type Date I am having problems. On the server ( Spring Boot ) I am collecting a Date field from MySQL , and this information is correct in the Spring Boot Model when debugging. But if I see that call...
asked by 23.11.2018 / 20:13
0
answers

Query in the background? Download time

I have a code that has to show a list of options downloaded from the database through the element. The problem is that this query takes a long time to load (since I have to show more than 150000 records). The code I currently have is this:...
asked by 22.11.2018 / 17:10
0
answers

login with php and mysql

I'm giving my first steps in PHP and I'm working on a login, I try to compare the password that is in the database and the one that the user entered, but I can not get it to work, This is the code that I have: // data sent from form login.html...
asked by 24.11.2018 / 16:00
0
answers

Pass the value of a variable in php to an excel column with phpExcel

Generate reports with use of the phpExcel library, when generating the reports I do it by means of queries and I only send them to call with a variable within a while , the conflict is when you want to save values of a variable that...
asked by 23.11.2018 / 16:17
1
answer

How to delete a specific record? Php Mysql

I have two tables with the following structures: Table: photos, id_fot int (11) not null auto_increment (primary key) user varchar (200) varchar route (200) description varchar (200) Table: users, id int (11) not null au...
asked by 22.11.2018 / 15:40
0
answers

Inquiry With a Select Multiple PHP

In summary, I need the query to be made according to the number of options selected in the Select field. I do not know if I can explain myself clearly. Until now the code that I have is the following, however it only shows the result of a sel...
asked by 07.12.2018 / 19:18
1
answer

Datatable does not return the first row of the query, C #

I'm trying to print two columns of a MySQL query in the console using the following code: public void cargarHorario() { DataTable tabla1 = new DataTable(); maestro.NoMaestro = 23041; tabla1.Load(DAOMaestro.se...
asked by 22.11.2018 / 20:51
1
answer

Fill ChartJS with PHP

I want to fill a graph with an array that I generate in PHP with a query in MYSQL but I do not know how to use it in the JS of the graph. This PHP is where I generate the array: $nmes = $mes; $sumpt = 0; $nestedData=array(); $sqlven =...
asked by 12.12.2018 / 19:41
0
answers

Recover token with json web token and nodejs

Good I have an api made with express but I do not know how to save the token, any help? Controller code that creates the token which works correctly: function login(req, res) { const { name, pass } = req.bo...
asked by 21.11.2018 / 18:10
0
answers

I have several invoices that I made a json from SQL 2017, but I have a problem in the structure

I generate my JSON from SQL 2017 which generates this structure taken from a table. "detalle": [{ "numero": "1", "codigo": [{ "tipo": "04", "codigo": "593" }, { "tipo": "04",...
asked by 22.11.2018 / 23:31