Posts by Ricardo • 82 points
11 posts
-
1
votes4
answers856
viewsA: Return message to the registration screen
I think you want to make it show a message when it was inserted, you can do so echo '<script> alert ("Quantidade alterada com sucesso!"); location.href=("cadastro.php")</script>';…
-
2
votes1
answer103
viewsQ: Problem with post/get method to update table
I’m trying to update my table using javascript so I don’t have to leave the screen every time I turn off a field, my table: The button I used in PHP but went to another page: <td…
-
-1
votes1
answer653
viewsA: Insert into two separate tables
I believe the error happens because the client’s FK field in the phone table is not in your second input, fields are missing. Divide the 2 Inserts and before entering the phone try to do what I did…
-
1
votes1
answer66
viewsA: Make a session expire
Doesn’t it get easier you do so? I use this way on my websites.. header("Refresh: 1200; url=paginadelogin.php"); Hug!
-
1
votes2
answers51
viewsA: Sort table values by Day and Month
I figured out the problem, it’s actually a bootstrap stylization. <table class="table table-striped table-bordered bootstrap-datatable datatable"> he reference by the first column of the…
-
-1
votes2
answers51
viewsQ: Sort table values by Day and Month
I have this Select below: SELECT b.id, b.codigo, a.codacesso, a.seqproduto, a.desccompleta, b.quantidade, b.data_vencimento, b.data_atual, b.observacao, b.usuario, b.estado, b.loja, a.medvdiageral,…
-
0
votes2
answers105
viewsA: Sum values of the same code
Got it this way, because they are negativing my question? SELECT a.seqproduto, a.desccompleta, SUM(b.quantidade) AS QUANTIDADE FROM master_datas_b a, master_coletores b WHERE b.tipo_acao IS NULL and…
-
-2
votes2
answers105
viewsQ: Sum values of the same code
Hello, I have a table that lists purchase quantity of each product, for example, if the buyer makes 3 purchase orders he repeats the orders and quantities. An example of this is the image below: for…
-
0
votes2
answers41
viewsQ: Save Column Name as item in another Column
Next, I have a table with several values and I need to compare the values of several columns, I did this with PHP and managed to separate the highest value, follows the code: while($aux =…
-
0
votes3
answers1978
viewsA: Merge 2 Oracle SELECTS and as a result 2 columns with different values
I managed to make select a.vlrvenda as venda2017, b.vlrvenda as venda2018 from web.demonstrativo_processados a, web.demonstrativo_processados b where a.nroempresa = 1 and a.data between…
-
2
votes3
answers1978
viewsQ: Merge 2 Oracle SELECTS and as a result 2 columns with different values
I am facing a problem, I have two selects sql select * from web.demonstrativo_processados where nroempresa = 1 and data between to_date('2018/01/01' , 'yyyy/mm/dd') and to_date('2018/12/31' ,…