Questions tagged as 'mysql'

1
answer

Get totals by date range, relating to additional table [closed]

The case is as follows, I have a table in MySQL for a company box, and I'm creating a table in JAVA that will be a cost center. The database table has the columns: id | data | descricao | id_tipoDespesa | valor | I need the total amount of...
asked by 22.08.2016 / 01:29
1
answer

Limit the number of forms to be printed per page

I have the following code that generates a form of information brought back from the bank. If I print 2 forms of this per page, it works fine on an A4 sheet, but the issue is that I've tried to change the layout in several ways and it's not...
asked by 20.08.2016 / 02:30
2
answers

How to Sort Records After Count

Query SET @ranking = 0; SELECT @ranking := @ranking + 1 AS rank, 'empresas'.'id', 'empresas'.'id' AS 'id_empresa', 'empresas'.'id_marca', 'slug', 'slug_bairro', 'empresa_logins'.'nome', 'empresas'.'id_cidade',...
asked by 19.10.2016 / 16:00
1
answer

How to do update retrieving value from another table?

I have a table in my DB, called contas . Where do I register all system accounts. As soon as they are paid I make a update by changing their status. However, I send a single update for multiple accounts, as follows: update cont...
asked by 04.07.2016 / 18:54
3
answers

Get the id from a list of the database, and use on another page to insert phones in PHP

Hello everyone, I'm doing a test, and I have the data in a table in my HTML index page and I want to click on a button in front of some data and then go to another page that shows the name of the person that I clicked and insert phones on the oth...
asked by 08.09.2016 / 16:12
1
answer

What better way to solve slowness to generate report?

At one time, I developed a page of reports, the users have a filters option, this is working, but as the data in the database are growing it is getting slower and I do not know which option is best to solve this problem, some of the things I tho...
asked by 09.09.2016 / 20:32
2
answers

Limit 1 row in queries with primary key queries

One of the best practices for optimizing MySQL queries, dictated by an internet source, says that it is important to limit queries that already display only one row to one. For example, if I'm going to change a user's record, my current query...
asked by 26.08.2016 / 00:17
1
answer

MySql server with Xampp to be accessed by another machine? [closed]

I am a complete beginner in tinkering with web programming and local and remote servers, my notion on these subjects is quite partial. Well, I have a system that will need to access a Mysql database. But this server with the database must be on...
asked by 25.08.2016 / 16:53
2
answers

Load client data in a PHP modal

Hello, I'm having a problem developing a page that reports a list of clients. The ID, Name and CPF fields appear in the main screen. Also, on the same line, the "Preview" button appears, which should open a modal, in which the database inform...
asked by 13.07.2016 / 19:22
1
answer

How to adjust the entire screen according to the monitor resolution?

How to adjust the entire screen according to monitor resolution? See the image below: MydashboardisgettingasintheBimageasIcouldtostaylikeA.I'musingphp+mysql+bootstrap+html.Followthecodebelow:<!DOCTYPEhtml><htmllang="pt"> <hea...
asked by 24.08.2016 / 20:21