Questions tagged as 'mysql'

Tagged questions
1
answer

Perform a date search on a timestamp column using spring data

I am trying to perform a search only for the current date in a timestamp column, ie without informing the time, but only the date. Template: @DateTimeFormat(pattern = "dd/MM/yyyy hh:mm") @Temporal(TemporalType.TIMESTAMP) @Column(name = "d...
asked by 20.09.2017 / 15:19
2
answers

Record count

I have a table named cad_faltas , it has the fields: id int(11) id_cad_alunos int(11) falta varchar(8) idcurso int(11) The falta field receives the data AWAY and / or PRESENT. The question is, is there any possibility of doing a co...
asked by 20.09.2017 / 16:07
1
answer

Duplicate data when submitting form and F5 and also stores empty values

Whenever I press f5 or click submit, php stores the data again. I know it's a common problem and I've already tried to redirect it with the header, but it's included in the index.php with include. I also know that the msql words should have a...
asked by 01.04.2018 / 23:58
1
answer

Using data from one select within another?

Two tables tbl_orcamento and tbl_itens the table budgets have a column with the following statuses. 1 = orcamento aprovado 2 = ordem de compra emitida 3 = ordem de compra aprovada The tbl_itens has some columns I will l...
asked by 24.04.2018 / 20:35
2
answers

How to encrypt GET and copy the parameter

I have a feedback email that is sent to a user after the service is completed. This email has 5 links, where each one is the respective service grade (from 1 to 5). I want to direct to the page to update the database, the evaluation of the...
asked by 03.10.2017 / 20:50
2
answers

Download anchor validation

Next,IneedtovalidatethisformsothatonlyafterthepersonregisterscanIdownloadthefile.WiththetagIcanalreadyhavethisvalidationbutImanagedtoputittodownloadonlywiththetag"ancora". <section id="e-book"> <header> <h3>Baixe...
asked by 06.10.2017 / 20:20
2
answers

How to model n-to-n relation correctly? Women also have friendship with men and not only men have friendship with women

Hello, I want to do the following: Create in MySQL the n-to-n relationship where men have friendships with women and women also have friendships with men. Example: Joao has friendship with Fernanda , but Fernanda strong> but with C...
asked by 08.10.2017 / 19:16
1
answer

How to configure remote database in laravel 5.4

I'm setting up a bank in Laravel 5.4, but the same is hosted on another server, set up in Navicat is accessing normally, but Laravel does not connect. APP_NAME=Laravel APP_ENV=local APP_KEY=......... APP_DEBUG=true APP_LOG_LEVEL=debug APP_URL=...
asked by 03.10.2017 / 16:42
1
answer

Change server CRON function through PHP

Is it possible to change some CRON function with PHP or any other language? For example, I have the following non-server function: 30 15 * * 1-5 php /var/www/html/projetos/hist_06.php In this application the user would enter that they wo...
asked by 29.09.2017 / 14:54
1
answer

Group Data with Preference-MYSQL

I'm trying to group rows equal, but based on a value. I know it is possible through sub-query , however as I am using inner join I could not apply. SELECT * FROM Concessionarias C inner join Concessionarias_Marcas CM on C.id =...
asked by 23.12.2017 / 05:59