Posts by SandroMarques • 973 points
11 posts
-
1
votes1
answer318
viewsA: I can’t change my column collate in mysql to utf8_general_ci
This example worked for me: ALTER TABLE `minhaTabela` CHANGE `nome` `nome` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; NOTE: there is no difference in the query to…
-
1
votes2
answers1900
viewsA: block access to a particular directory via htacess
Block the access completely Create the . htaccess file inside the folder you want to protect Deny from all NOTE: inclusive, no script has access to this folder Block access in part Create the .…
-
55
votes7
answers26094
viewsA: What is the difference between parameter and argument?
The function defines the parameter, and the call code passes the argument to that parameter. By analogy, we can consider the parameter as a parking space and the argument as an automobile. Therefore…
-
3
votes2
answers36
viewsA: Search only data from two tables with different id’s
I think GROUP BY resolves (I have not tested) SELECT DISTINCT carros.id, carros.modelo, carros_img.img, carros_desc.comb, carros_desc.preco from carros, carros_desc, carros_img where carros.id =…
-
4
votes2
answers139
viewsA: Return record with highest number of appearances
The query should be the following: SELECT nome FROM tbl_abc GROUP BY nome ORDER BY count(nome) Desc LIMIT 1
-
1
votes2
answers3152
viewsA: What is CSRF attack and what damage can it cause?
A CSRF (from English Cross-Site Request Forgery) It’s a type of attack that, by running a malicious script on the victim’s browser, accesses another website without the victim noticing. The attacker…
-
2
votes3
answers521
viewsA: Where should I put FK?
First of all, in 1:1 relationships I put everything on one table. Anyway if you want to separate the tables, here’s a solution: table user iduser (PK) nome sexo table login iduser (PF) login senha…
-
1
votes1
answer51
viewsA: Site opening horizontal margin how to resolve
I didn’t quite understand the question but I suspect your problem will be solved with the following CSS: body { margin:0; }
-
2
votes1
answer79
viewsA: Reformulating URL in htacess
I’ll write down some examples to see if I can help you... Example with 1 querystring In the case of the URL www.domain.com/page-x, will be interpreted as www.domain.com/index_.php? pagename=page-x…
-
0
votes2
answers266
viewsA: Insertion in Mysql with PHP works for nothing
Try changing the following line die('Erro: ' . mysql_error($conexao)); for this die('Erro: ' . mysqli_error($conexao)); I think this way the error already appears and it’s easier to understand…
-
1
votes1
answer178
viewsA: Problem mounting Textviews on Android Studio
When orientation is not specified, default horizontal and in this case should be vertical. <?xml version="1.0" encoding="utf-8"?> <LinearLayout…
android-studioanswered SandroMarques 973