Questions tagged as 'mysql'

Tagged questions
0
answers

Inheritance - Database?

I started deploying a bank, and I'm doubtful of the following: I have 4 tables Person Client Employee Administrator. Cliente and Funcionario inherit from Pessoa and Administrador inherit from Funcio...
asked by 22.03.2017 / 16:27
1
answer

Graph based on weekly data

Colleagues programmers, good night. I'm having a hard time setting up a chart of weekly records using PHP, MySQL, and the Highcharts library. I have records of connections and disconnections, in which it is saved in 2017-03-30 16:43:04 for...
asked by 03.04.2017 / 22:55
1
answer

Wordpress slow and with database access errors

All good personal, I had asked another question, but I was able to identify some queries that are consuming a lot of execution time. I developed a theme for a news portal, and in each area I upload news from a certain category. But since s...
asked by 03.04.2017 / 21:12
1
answer

Select the values of the "select" through the "GET"

I'm trying and can not do the following: I thought of "automating" the process of reports of the system that I am doing, by registering the PRODUCT, you also register the name of the column id and the name of the product id, as follows: T...
asked by 30.03.2017 / 22:04
1
answer

Detail master table, totalizing fields

I am doing a work order control where in a work order several users will register products and labor, so I have three tables: - Service order (master) - Products (detail) - Labor (detail) The detail tables generate values that will have to repre...
asked by 31.03.2017 / 04:02
1
answer

MySQL Web connection error

Hello, I am trying to connect a java class with a MySQL BD from the db4free.net host but it is returning the error below: SQLException: java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long...
asked by 15.03.2017 / 03:24
1
answer

How can I pass more than one point to google maps in this while?

I wanted to mark all points where the approximate distance is less than 25 km, but it does not even show the first point that is the closest (4km), it shows the last point (18km). Here's what comes from my bank: Array ( [0] => -22.356472 [...
asked by 27.03.2017 / 15:08
1
answer

Identify cities or other subjects

Good afternoon, friends. I'm creating a website for a company and I have a small question. can anyone tell me how do I make the site "auto complete" the user's cities? EX: in the state I select that I live in São Paulo, and automatically that of...
asked by 27.03.2017 / 20:11
0
answers

PHP display duplicate record

Recently I started developing in PHP + MySQL, I'm doubtful about displaying the query, scenario follows. I am doing select with 3 tables mdl_logstore_standard , mdl_course and mdl_user , where in the mdl_logstore_standard...
asked by 13.03.2017 / 21:06
1
answer

Concatenate Lines with the same User

I have the following query: SELECT e.id_taxe, u.nm_user, dt_taxe, SUM(e.vl_taxe) as vl_taxe FROM taxe as e INNER JOIN user as u ON u.id_user = e.id_user WHERE id_enterprise = 86 AND (dt_taxe BETWEEN '2017-01-01' AND '2017-03-31') AND lg_can...
asked by 13.03.2017 / 19:11