Posts by EASoares • 69 points
6 posts
-
0
votes2
answers509
viewsA: joomla article mod_calls are being redirected to the home page when clicking
First try to check in your template file of this module if the link path is correct. Normally the template file is in /seu_path_base/module/mod_name/tmpl It can be a difficult diagnosis without…
-
1
votes3
answers71
viewsA: differentiate user type with php
I believe that instead of echo "Usuário ou senha incorretos"; you could pass the access error message to the index by parameter, to present to the user. I would also try to extract some…
-
-1
votes5
answers16830
viewsA: How do I list all tables with their respective databases?
Try something like: SELECT * FROM sys.databases as db INNER JOIN INFORMATION_SCHEMA.TABLES as tb ON db.name=tb.TABLE_CATALOG AND TABLE_NAME like '%attach'
-
2
votes1
answer371
viewsA: PHP - is it possible to make an INSERT INTO with php variables and more SELECT?
Your number of arguments declared in values is incorrect, try something like: INSERT INTO tabProdutos ( id, descricao, unidade, qtd, valor) VALUES ( SELECT cod, descricao, unidade, qtd, valor FROM…
-
0
votes2
answers337
viewsA: How to treat error when deleting a BD record, which has a foreign key, PHP
I believe the best way out is to use a Try catch block: try { //coloque aqui sua query //TO DO } catch (MySQLException $e) { // mysql exception - trate aqui a váriavel abaixo para exibir o erro como…
-
1
votes4
answers1903
viewsA: How to join two lines in SELECT?
Hello, maybe you can leave UNION and try selects that resolve Counts for you within the initial query, for example: SELECT date(cdr.calldate) as data, cdr.dst as ramal, users.name as nome,…