Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with select for PHP MYSQL JQuery price filter

I have a form which contains a select , to be able to filter by higher or lower price, when I select an option if it performs filtering, the problem is that the select never changes the option always stays in the first option. I...
asked by 07.07.2018 / 00:32
2
answers

Consult specific data of mysql omitting others in php?

I have a table with the following data id, name, price, category, description, but I want to make a query according to the category, for example, if I select the chairs category just print those rows that have that category in said column. I ho...
asked by 08.07.2018 / 17:25
1
answer

Download BD in several Excel

is that I have a site that downloads the bd in an excel file but the thing is that I arrive at so much data that the excel file arrives damaged, so it occurred to me that I could only upload, say, a thousand data and that when the thousand thous...
asked by 31.07.2018 / 00:01
1
answer

How to count records by date according to the requested query?

I am looking for the counting of these services according to the date, these types of services are stored in a column. index.php <!DOCTYPE html> <html lang = "es"> <head> <title>Consulta De Estadist...
asked by 05.07.2018 / 18:01
1
answer

Is a Mysql image strictly necessary in JHipster?

I have a project created with Jhipster and I'm about to turn it into production. The generator as such creates a container of the database, in this case Mysql. At the moment of generating the image with Docker and executing it obviously uses an...
asked by 05.07.2018 / 23:13
1
answer

How to make multiple sql statements from java? -closed

[! [] [1]] This code executes a single sql statement. public Connection getConnexion(String query){ Connection cnx = null; try{ Class.forName(driver); PreparedStatement ps= null; cnx = (Connection) DriverManager.getConnection(url,usuario,pa...
asked by 05.07.2018 / 03:33
1
answer

Clear input type text when clicking the button

Hello, I need that when I click to send the data I delete what I write but without using a reset button this is my code of my button THIS IS MY HTML AND JAVASCRIPT <div class="col-sm-4 form-group"> <label class="control-label">...
asked by 27.09.2018 / 18:47
1
answer

Validate token and email from a url in php

I'm doing a password recovery system. The issue is that when I get into the url that generates me, I think it does not validate the email and / or token and does not teach me the input to have it put in a condition if they change data from the U...
asked by 27.09.2018 / 17:41
1
answer

Query table in two columns but one in mysql

I have a table that has inside its columns: period (2017-10, 2017-11, etc.) amount_box (values) billed (has "yes" and "no"). I need to make a table with 4 columns: THE period, the unbilled amount per period, the amount billed per period, and the...
asked by 13.07.2018 / 22:20
2
answers

error Column count does not match value count at row 1

I am trying to save a form in the MySQL database, but when I try to execute to save, it shows me this error:    Column count does not match value count at row 1 In the form I only have the necessary fields, the others I do not put them...
asked by 13.07.2018 / 03:26