Questions tagged as 'mysql'

Tagged questions
1
answer

MySQL Search with filter select option

I have a question. I have a php page with several select option to filter a search in the database. However, I can not use the values selected in the query. I made as an example I saw in another site, an array to store only the values of the sel...
asked by 03.08.2015 / 21:23
2
answers

How do I get a die on one page and put on another?

I need to get a data sent by the user through the GET method on a page, put that data in the database and, on another page, I need to read that data from the database and write the page. In this case, I have a table named comandos where I...
asked by 03.08.2015 / 18:33
3
answers

Search in multiple tables MySQL

I have the following SQL SELECT * FROM cliente as c INNER JOIN cliente_contato as ct ON ct.nome LIKE '%{$pesquisa}%' OR ct.telefone LIKE '%{$pesquisa}%' JOIN cliente_ip as cip ON cip.detalhes LIKE '%{$pesquisa}%' INNER JOIN cliente_mac as ma...
asked by 01.07.2015 / 19:03
2
answers

Search only a random part inside a code with select in mysql

The problem is as follows, I have the concatenated code, I need to see this concatenated code if part of it is in the table, ie by putting field 1 and field 2 > with PHP, before searching the table, a variable brings me this preprogrammed, I...
asked by 09.07.2015 / 01:04
1
answer

Symfony2 - Refresh field of one entity when executing action on Controller of another entity

I need to update the budget field of my Client entity when entering new data into the Budget table. Both have relation oneToMany and manyToOne , respectively. I received suggestions to use the OO concept to do this operation, so somethi...
asked by 08.09.2015 / 05:03
1
answer

Subtract row from one table by another from another table

I have a question. I need to subtract a row (quantity) from the table (sales) that was entered by the user in form , in the table (products) in the (inventory) line, being that only the last record registered in the table (products). I mad...
asked by 08.07.2015 / 14:36
1
answer

How can I save checkbox in bank with php?

I have several checkbox components on the site, each with the value of the name of a movie, how can I save it to the bank? HTML of one of them: <input type="checkbox" class="checkbox" name="filme"> Do you have to have value or nam...
asked by 10.09.2015 / 01:29
2
answers

register plots php mysql

Good morning, I'm doing a promissory system and would like to know how to register the parcels in the bd with the information. wanted to enter the information as follows in the registration form when I put the value $ 300.00 and put in 3 parc...
asked by 02.09.2015 / 15:49
2
answers

Problem with login / logout in PHP

I have a small login / logout system in PHP / MySQL where when I log off, and try to enter again at the same time, the page does not enter. It only works after a few minutes. What would it be? pegasenha.php (page where I do the post (ajax))...
asked by 24.06.2015 / 16:03
3
answers

Filters records via datetime and fetch them between a start date and end date

I have the balance table, which always when executing a procedure, is generated a new record in the same, being able to have several record the same day ... However, when I make an appointment, I want to bring only the last record of each da...
asked by 19.06.2015 / 19:57