Posts by Robson Nery Souza Garcia • 146 points
13 posts
-
0
votes1
answer129
viewsA: Recover parameters with $_GET and $_POST in the same php file, is that correct?
Francis, In a simple way, verbs GET, POST, PUT, DELETE, PATCH and others represent a semantics suggested so that the systems become clearer. It is as each of them defined a clear action that is…
-
0
votes1
answer19
viewsA: How and where to validate form controls that match the fields in my database?
Abner, The question is broader than a simple rework when validating the fields before sending to the bank. Imagine the work behind it to make all the information reach the database and be validated…
-
1
votes1
answer31
viewsA: Notifying the Browser via backend
Ricardo, Signalr will be a Feature for you to establish real-time communication with the customer, but your real problem doesn’t just involve this. With this implementation with Signalr, you need to…
-
0
votes2
answers72
viewsA: Doubt about dll version
Good night Gustavo. Probably your solution has more than one project and what may be happening is that there are different versions of the packages installed in the projects. In Visual Studio…
-
1
votes2
answers158
viewsA: SELECT COUNT with low performance in mysql
You can use other strategies, such as building a View by summarizing the number of sub-variables per tbl_parent: Select tbl_pai, count(*) as qtde from categoria Group by tbl_pai So, whenever you…
-
1
votes2
answers138
viewsA: C# conversion error
Rodrigo, I think the concept of interface is getting in your way. See the interface ITributavel as a contract that must be fulfilled. Thus, in his method accumulates, he expects an object that…
-
0
votes2
answers995
viewsA: is not a GROUP BY expression
There are times not working with Oracle, but trying to help, it may be the lack of an aggregation function (SUM, MAX, MIN, etc.) in some fields that are not pointed as grouping fields (GROUP BY).…
-
3
votes1
answer22
viewsA: How to store notifications for performance?
I believe you are concerned to scale your application in the future if there is expected growth. The decision on this architecture should be thought of in relation to the maturity of the project…
-
1
votes3
answers172
viewsA: Hide duplicate SQL values
The important thing is to understand what happens in the consultation. UNION makes the union of two results removing the duplicities. I remember that UNION will take into account all the return…
-
1
votes2
answers54
viewsA: Help with Query Mysql
From what I understand, you want to show the units and which dentist this unit and which auxiliary unit and every unit will have a dentist and an assistant. Correct? If this is the understanding,…
-
2
votes1
answer418
viewsA: Avoid simultaneous user access
Knowing if the user is logged in and inhibiting a second login depends a lot on how the user behaves in your application. If your system uses session, with the user’s session identifier you can…
-
0
votes1
answer172
viewsA: Consume the Security of an API for MVC Web Application
the [Authorize] defines that the authenticated user the points where only authenticated users can have access. When you decorate the Clases and/or methods with [Authorize] you are defining that only…
-
0
votes2
answers236
viewsA: PHP+Mysql Search System
Good afternoon Rodrigo. You can use two different strategies. I understood that they are filters and you can check in the code if the field is null and add to your search condition (WHERE) or you…