Questions tagged as 'mysql'

Tagged questions
1
answer

Dynamic site with multiple result pages

I'm doing a project for a dynamic website in college and wanted to know how to mount those result pages with first, second pages and so on without creating new .php files. For example: I have a news site, when the user clicks on a t...
asked by 25.09.2014 / 15:57
2
answers

How to keep the query filters sent via $ _POST?

$page = ((isset($_GET['pagina']) && intval($_GET['pagina']) > 1)? intval($_GET['pagina']) : 1) - 1; $limite = 12; $atual = $page * $limite; $limit = " LIMIT {$atual}, {$limite}"; // Registros limitados $query = $pdo->query("SELE...
asked by 10.10.2014 / 17:16
1
answer

What is the meaning of the "equal or removed indexing" error in MySQL?

I'm working with small relationships and I noticed that in a state table where I've related the id field to the país[id] table I get this error or alert message, I'm not sure. Already in a relationship of table cidade to...
asked by 19.10.2014 / 15:54
3
answers

Compare and replace index array

The problem is the following, I'm creating daily OS graphs, only coming from the day bank in English, I would like to replace each index with the Portuguese value My code public function osSemanal($id_company) { $periodo = date...
asked by 11.12.2017 / 18:03
4
answers

MAX with LIMIT does not give correct result

Imagine the following lines in my MySQL database: I want a query that displays the name and age of the person who is the oldest in the table, so I did this query : SELECT nome, MAX(idade) from pessoas; But it does not return th...
asked by 22.11.2018 / 16:26
2
answers

Union problem in mysql

I am trying to perform a query and is giving the following error:    Unknown column 'FILIAL' in 'field list' The query is as follows: SELECT TICKET, DATAHORA, TIPO, ESTADO, CRITICIDADE, LOGIN, PARECER, INFOPEND, PROP, DATAPROP, PREV, SR...
asked by 17.07.2018 / 14:49
2
answers

How can I not return an "X" value in DB?

How do I not return an "X" value in the database? For example, I have a Vagalume style website, and it has the page of each artist where the tab "Related Artists" is based on the TAGs registered in the BD, I wanted it not to return the artist v...
asked by 04.05.2018 / 04:38
2
answers

What is wrong with this form?

I've created this search form, so it's returning all blank! Here's the form: <h3>O que você esta procurando? Digite aqui:</h3> <form class="form-inline" action="busca.php" method="post"> <div class="...
asked by 09.08.2017 / 22:21
3
answers

How to use SHA1 in login with PHP taking parameters?

I created a password using SHA1 as password encryption, where the password parameter is as follows: $senha = sha1($_GET['senha']); However, I'm not sure how to decrypt, even passing parameter, the sha1() . I have the following example...
asked by 28.07.2017 / 00:58
2
answers

Multiple MySQL Assignment [closed]

How to assign multiple values to an attribute of a table in MySQL? For example a table where a client can have several phones, and in assignment can be passed the several customer phones at one time.     
asked by 30.05.2016 / 21:17