Questions tagged as 'mysql'

Tagged questions
1
answer

Modify table PHP / MySQL

I have a monthly billing table that shows earnings for January through December. It sums all values in the pagseguro table ( ProdValor_1 column). Below is the table code: <?php $mes = array("0", "Janeiro", "Fevereiro",...
asked by 05.06.2017 / 19:29
1
answer

Complete other fields

Good evening Home The problem was as follows, I have a select where it contains all the products registered, autocomplete it with a foreach so that it pulls all the products of the bank, what I want is the following, when I select...
asked by 06.06.2017 / 03:47
1
answer

Maximum number of rows from a mysql import

Well, I'm importing all my database, since I changed the computer, I exported it from the old one, and I want to import it into the new one, but when I import, I get an error: "tempo limite alcançado, envie novamente o arquivo para continuar"...
asked by 01.07.2017 / 23:03
1
answer

Get records with date greater than the current one - Laravel 5.1

I need to list schedules that have date greater than or equal to the current date, I'm doing it as below but it does not work, it does not return any record. Auth::user()->Agendamentos->where('data', '>=', date("Y-m-d h:i:s")) I'm...
asked by 01.06.2017 / 16:19
1
answer

E-mail Scheduling System

I have the following problem: A user performs a test X step, when he clicks to get the first result, he must create 9 e-mail messages to be sent to the logo of 3 days, morning (7:00), afternoon (13: 00) and the night (21:00). The question is...
asked by 31.05.2017 / 20:25
3
answers

Compare data from two tables

I have two tables: Tabela1 Tabela2 +------+----------+--------+ +------+----------+------------+ | id | idCidade | bairro | | id | idBairro | logradouro | +------+----------+--------+ +------+----------+------...
asked by 31.05.2017 / 19:38
1
answer

Query on two tables with count

I have a table in mysql that has a number of contracted items. Table itens_contratados    contracted id   Item   Qtd_contracted Table servico , in this I inform the service that I executed in the contract    contract_...
asked by 13.07.2017 / 19:06
3
answers

Search field with php and mysql. How can I not differentiate special characters?

I'm having a problem with a search field on a php site with MySql database. I have a record in the database as "SIPHONE" and when I search as a siphon, sifao or SIFAO does not return this record. I would like you to not case-sensitive and spe...
asked by 30.05.2017 / 13:47
1
answer

How together did these two select?

How do I get these two select in a query? //Retorna todos os dados do fornecedor SELECT * FROM suppliers WHERE id=$id //Retorna todos os serviços do fornecedor SELECT suppliers_services.*, third_party_services.* FROM suppliers_service...
asked by 15.06.2017 / 03:14
1
answer

UPDATE of database information

I have a table, where there is a field called (PAYMENT), the default value of it is "PAY". Imadethefollowingcodetochangethe"PAY" VALUE to "PAYMENT" $results = "UPDATE snaps SET Pagamento='PAGO' WHERE id= 27"; However, it only works for...
asked by 15.06.2017 / 22:57