Posts by Aryana Valcanaia • 427 points
20 posts
-
1
votes3
answers340
viewsQ: Sort in SQL by prioritizing a specific field value
I have a large client table, and I need to select the following fields (sample data) id | id_ls | id_sistema_ls | nome | ativo ---------------------------------------- 1 | 1007 | 158849 | A | 0 2 |…
-
2
votes1
answer115
viewsA: iOS does not respect the overflow-x Hidden
There were 3 problems related to content overflow. The first was related to library owlCarousel. I had to add fixed width in pixels (I was using 100% container percentage) in the Responsive. The…
-
0
votes1
answer115
viewsQ: iOS does not respect the overflow-x Hidden
I have a published website and it is featuring a side scrolling in version Responsive when accessed via iPhone that no longer exists on any device. Both in Safari and in Chrome is accessed via…
-
1
votes1
answer61
viewsQ: Manipulating a jquery Children by clicking another
Hello, I would like to make a script similar to accordion. My HTML <div class="pergunta"> <h3>Titulo</h3> <article>Texto</article> </div> <div…
jqueryasked Aryana Valcanaia 427 -
1
votes1
answer668
viewsQ: I don’t get POST sandbox in my Pagseguro (PHP) notifications URL
In the TOTAL absence of any return in the community of pagseguro dev I am here to see if any good soul has any suggestions. I can’t receive the notifications sent by Sandbox from pagseguro, actually…
phpasked Aryana Valcanaia 427 -
1
votes1
answer524
viewsA: Ajax and PHP for image upload + information registration
I adjusted the js and solved :) HTML <form id="cadastrar-evento" method="POST" enctype="multipart/form-data"> <label>Título</label> <input class="form-control" type="text"…
-
3
votes1
answer524
viewsQ: Ajax and PHP for image upload + information registration
I am hitting myself since yesterday with an upload of images in AJAX. I will publish the advances I have studied and the difficulties I still have in case anyone can help me :) My script as I always…
-
0
votes1
answer244
viewsA: How to take a floating div after a certain scroll
I’ll paste a code that I use here and maybe adapting will help you, okay? //Topo fixo $(window).bind('scroll', function () { if ($(window).scrollTop() > 500 && $(window).width() > 680)…
-
1
votes0
answers161
viewsQ: Confirm jQuery by running 2 times
Hello, I have a code that "activates and disables" users. This: HTML <button type='button' class='btn btn-success btn-circle ativar-gestor'> <i class='fa fa-check'></i> <input…
-
0
votes2
answers1045
viewsA: Change input color according to value
Use jQuery :) you can use "on change" with a class for code optimization. Then just add the "class" where you want to apply the colors. Follow an example: $(document).ready(function(){…
-
2
votes2
answers174
viewsA: How to transform multiple JSON into only valid JSON with json_encode in PHP
The bug was because of the charset :( silly haha. When giving a var_dump I noticed that the charset was in trouble. Fixing it, json compiled it. Thank you! For demo only, I added the charset to the…
-
0
votes2
answers174
viewsQ: How to transform multiple JSON into only valid JSON with json_encode in PHP
Hello! I have a script that at the end of each while loop prints a json echo json_encode($retorno); The result when running the script is (example bringing several results) { "IdClienteLS": 1695,…
-
1
votes1
answer131
viewsQ: mysql PHP problem when using trema
I need to develop a script that checks for an accented character with trema in the string and saves a string variable without the trema. The script I list below compiles //Checa Especial…
-
3
votes4
answers662
viewsA: How to improve SQL performance with IN clause?
I managed to solve it with everyone’s help. In fact the creation of indexes improved the load to 4 seconds (still a little slow) but I believe this happens by the amount of records. Some…
-
8
votes4
answers662
viewsQ: How to improve SQL performance with IN clause?
I have this SQL here: SELECT id, nome, url FROM categorias WHERE status = 1 AND id_ls IN (SELECT id_categoria FROM cliente_categorias) GROUP BY url What he does is seek only categories that have…
-
2
votes1
answer429
viewsA: Htaccess Wordpress URL Problem
Solved! I went to the panel > Settings > Permanent Links and updated its structure to recreate a new file. htaccess. Automatically correcting and referencing the directory. Became: # BEGIN…
-
1
votes1
answer429
viewsQ: Htaccess Wordpress URL Problem
I have a project that has an institutional website (main domain example: client.com.br) and a blog with Worpdress in sub-domain(example: blog.cliente.com.br). I have an htaccess in the root…
-
0
votes2
answers465
viewsQ: How not to show jQuery UI autocomplete input the HTML of the variable?
I’m using the autocomplete of jQuery. I got him to play HTML, but the HTML is displayed on input. I need to format my search like I did: When I click, however, the result is displayed like this:…
-
0
votes1
answer238
viewsQ: How to use "mock" to perform function only after a while
Hello. I am developing a script that runs when the user arrives at the end of the page scrolling. What I have so far is the following code: $(document).ready(function() { var posicaoAtual =…
-
3
votes2
answers269
viewsQ: Length of jQuery does not update with the append, how to resolve?
I am working on a script that makes it load more records from the database when the user arrives at the end of the page scrolling. PHP/SQL is right, the problem is that jQuery does not correctly…