Posts by Rafael Araújo • 334 points
11 posts
-
1
votes2
answers264
viewsA: How does PHP handle type declaration?
Hi, Anderson. Yes, in this step of compatibilization of the signature with the return, the language checks if the return is an instance of Foo without the Foo class exists. Considering the moment…
-
3
votes1
answer467
viewsA: How do I make an INNER JOIN conditional?
You must use LEFT JOIN for the photo tables. SELECT imoveis.id, fotos.foto, imoveis.titulo, imoveis.descricao, imoveis.vvenda, imoveis.vtemporada, imoveis.vanual, imoveis.status, imoveis.cod FROM…
-
0
votes1
answer475
viewsA: Error trying to insert - Call to a Member Function prepare() on a non-object
You need to create the object with the same name with which you want to use it. You are creating the object as $PDO = new PDO, but wants to use as $pdo->prepare. Or use $PDO or $pdo in both…
-
3
votes1
answer1473
viewsA: Error importing Postgre bank
The restoration using pg_restore, which is what is being used by Pgadmin does not support sql files as it is necessary to have backup format files generated. To use the sql file, you can open the…
-
0
votes1
answer31
viewsA: ng-repeat does not display empty values
This requires a button to reset your search object to null, since filling it gains a value: <button data-ng-click="search = null">Limpar</button>
angularjsanswered Rafael Araújo 334 -
1
votes2
answers295
viewsA: Update page with route without "#" Angularjs
Error 404 is sent because of the answer from your http server, which does not recognize the route, since the directory does not physically exist, nor does it pass to the angular control. You need to…
angularjsanswered Rafael Araújo 334 -
1
votes4
answers1877
viewsA: Export MYSQL information to JSON
THE JSON (http://json.org/) is a data format. It facilitates data exchange between different systems as it is simple to generate and recover. For your case, you need to generate a JSON output to be…
-
2
votes2
answers374
viewsA: Query bringing duplicate items + product code
Use the check query as subquery to bring the results: select CD_PRODUTO_SERVICO, ds_produto_servico from tb_produto_servico where ds_produto_servico IN ( select ds_produto_servico from…
-
2
votes1
answer28
viewsA: Doubt regarding the IN in Oracle
It would be a mix of LEFT JOIN with CTE to realize the logic. WITH sql AS ( SELECT BASI_030.NIVEL_ESTRUTURA NIVEL, BASI_030.REFERENCIA GRUPO, BASI_030.DESCR_REFERENCIA, BASI_030.CONTA_ESTOQUE,…
-
2
votes5
answers5717
viewsA: Error npm and Ubuntu Node
Make sure you can fix broken packages: sudo apt-get install -f If it gives you the possible options to fix the packages, you can proceed. It may be that the installation of the nodejs package has…
-
0
votes2
answers481
viewsA: Doubt - SQL update from PHP form
1) You need to create a field hidden with the value of your id in the form, as in <input type="hidden" name="id" value="<?=$id_do_registro?>"> 2) Recover this id on next page by $id =…