Questions tagged as 'mysql'

Tagged questions
1
answer

Problems with query in mysql

Good afternoon. I have a query in my db that has to bring the user name and id data from the users table and the commission table brings the commission, award, month, and a month field consisting of year and month ex 201801. My query is this...
asked by 22.01.2018 / 21:18
1
answer

How to interact with bank data with Javascript

I was looking to put together a chart with HTML Canvas using Javascript as well. The required data is in the MySQL database. However, how can I interact and access this data from the Javascript bank, since it is not safe to use that language for...
asked by 09.01.2018 / 17:45
0
answers

Login / logout audit in MySQL

I need to know when users login to the mysql database. My first attempt was to configure the general_log and log_output = FILE parameters. However these options generate excessive logs and this is a problem for me. In fact I do not need t...
asked by 18.01.2018 / 18:52
1
answer

I have two entries grouped but only one is changed in the update

I've mounted an update by grouping the presenca field that should change from two arrays to one repeat loop, follow query : UPDATE acessos AS a JOIN ( SELECT usr_id, presenca FROM acessos GROUP BY presenca...
asked by 09.01.2018 / 01:29
0
answers

Error 2002: can not connect to local mysql server through socket (2)

I have this problem when I try to access my website created in Wordpress:    Error 2002: can not connect to local mysql server through socket (2) Reversed the snapshot and after a few seconds my server has this process alone as shown in t...
asked by 24.01.2018 / 15:29
1
answer

System of registration permission by limit

In my course system, the trainer has to stipulate the number of students who can enroll in each class and the student will only be able to enroll if the number of students enrolled is less than the number stipulated by the trainer. p> For this...
asked by 24.01.2018 / 15:08
1
answer

PHP does not find Session

Hello! I'm logging in with Jquery and PHP, the connection is right. But when I soon rather than keep on a page he does not find my session and sends me back to login. My HTML: <h2 id="errolog">Usuário ou senha errados!</h2>...
asked by 15.01.2018 / 21:25
0
answers

Login in subdomain and returns in the root domain

I'm stuck in this part to finalize the project. The theory is this, you logged into client.site.com, and you access site.com and your login data remain active, without having to log in to site.com. I had asked the same question here, I put al...
asked by 07.01.2018 / 01:42
0
answers

Different results between localhost and on the server

I have the following query that works fine on localhost but when I send it to the server it does not work What can it be? SELECT CONCAT( mes, '/ ', ano ) AS data, IFNULL( SUM( total ) , 0 ) AS Total FROM lc_controle WHERE tipo_venda ='A...
asked by 12.01.2018 / 21:04
2
answers

Filter by date in Mysql

I have a table where the date of registration in DATE () format is stored. The registration comes from 2013 and picks up every day and months until December 2017: 2013-01-01 2013-01-02 2013-01-03 ...... 2017-12-01 2017-12-02 2017-12-03 I w...
asked by 08.01.2018 / 13:24