Questions tagged as 'mysql'

Tagged questions
2
answers

Show data on screen according to clicked ID

Hello, I have a small problem here, maybe easy to solve, but I can not. I have a first screen (alumn.php) where you will have several search terms, and one of them will be by study time, where they will bring me some results from the database. S...
asked by 05.02.2017 / 15:55
3
answers

Conditional for record selection

I am having a question for selecting a record from a table and would like some help. An example of the structure of the following table: idhistorico_profissional | idprofessional | function | beginning | end | situation 9 77...
asked by 14.12.2016 / 01:43
1
answer

Lost my script to recover?

After a blue screen, I lost my work in the workbench, but keep the schema. Can you recover or will I have to do the work again?     
asked by 23.06.2017 / 06:23
1
answer

How to do a SQL query (MySQL) with average and several INNER tables?

I have an SQL statement with 5 tables. Notice that in it I make up a radius calculation. I need to add a new table of ratings with: cod_avaliacao int (11) customer_code cod_provider decimal_value evaluation (10,0) Where the avaliac...
asked by 03.05.2017 / 22:01
1
answer

Primefaces does not find Panel and DataTable components

I'm doing a job where I use Primefaces + Ajax + Hibernate. I have a screen to add / change a client that should open in a modal every time the user clicks the button. And in that same code I have a dataTable to show all clients. However, for som...
asked by 12.11.2016 / 15:33
1
answer

Unexpected error in PDO class

I've been breaking the code with this code for some time, it's the first time I'm using the PHP PDO class and I'm having an error that I do not know how to solve. <?php include "conexao.php"; $banco = new Banco(); //Instanciando o banco de...
asked by 22.10.2016 / 16:18
1
answer

MySQL doubt on Select

I have a table of chats in mysql , in it is the record of conversations between users. The fields are. id, id_from, id_to, message Example (My Data in DB): 1, 50, 10, 'Hello' 2, 10, 50, 'Nice?' 3, 50, 10, 'Yeah, And you?' 4, 10,...
asked by 06.11.2016 / 13:47
2
answers

Mysql Update filtering by expired date with x Days tolerance

I need to update only on records that are expired and adding a tolerance of x days Example                Tolerance of 5 days                Today is = 11/10/2016 id = 1 expiration = 10/10/2016 // just update if today was day 15 id =...
asked by 02.11.2016 / 22:32
1
answer

Paging logic with angular and mysql

I would like to know how to implement a paging logic in the database using mysql and angular on the front end with ui-bootstrap or dirPagination. For example, getting 10 in 10 on the bank using LIMIT and OFFSET . My question is in t...
asked by 07.11.2016 / 11:31
1
answer

Relate tables to make customer recommendations?

I have a table "tanned", "commented" and "visited", every time a user likes, comments or visits a certain book on my page a record is inserted into the database for such: Tanned table: +----------------+-------------+ | id_livro | usu...
asked by 02.02.2017 / 19:14