Posts by Givanildo R. de Oliveira • 534 points
23 posts
-
1
votes2
answers66
viewsA: Show only larger records two days before today
Put your WHERE this way: WHERE DATEDIFF(STR_TO_DATE(LEFT(data_gabarito,10),'%d/%m/%Y'), NOW()) >= -2
-
1
votes4
answers289
viewsA: Php Array - Associating data
To make the association, I think is better this way. Because if some checkbox is not marked, do not lose the index: <?php if( $_POST ) { foreach( $_POST['carro'] as $key => $value ) { echo…
-
0
votes2
answers112
viewsA: Responsive Site
The numbers in the classes col-**-* range from 1 to 12. If you want to divide into two columns, you say each div will occupy 6 parts. If you want to divide it into 3 columns, you say that the div…
-
2
votes1
answer1579
viewsA: Add point to every three numbers (thousand) in an input range tooltip?
Brow, I don’t know if there’s anything native that does that. But I did this function there that solves: ... $('#valores-credito, #valores-parcela').slider({ formatter: function(value) { return 'R$…
-
1
votes1
answer647
viewsA: Load HTML into Div via Ajax
Do so: ... success: function (response) { $("#detalhamentoDiv").html(response); } ...
-
1
votes1
answer194
viewsA: How to do a search in an app using Angularjs with correct parameter passage?
It is not safe and much less advisable to leave the query exposed in this way. I advise you to work with Restful. If you work with PHP, you can use a microframework for this. I use and quite like…
-
1
votes3
answers1178
viewsA: Apply class with innerHTML
Use the classname. If adding the class to the totalOp element, do the following: function tipoOperacao(tipo){ if (tipo.value == 'todas'){ document.getElementById('totalOp').className = "classeA";…
-
0
votes1
answer178
viewsA: How to make a fully fixed footer in html page
Leave the div that will be in the footer with fixed position: position:Fixed; <div style="width:100%"> <img id="topo" alt="" class="form-image" border="0"…
-
0
votes1
answer92
viewsA: Help with PHP email form
Download phpmailer, put it in your project folder and leave the upload code in this style: <?php if (isset($_POST["submit"])) { $name = $_POST['name']; $email = $_POST['email']; $message =…
-
1
votes1
answer275
viewsA: sum specific line in Mysql
Let’s say the new value to be added is 20 min -> 00:20:00 and the id is 1, then it would look like this: UPDATE tabela SET tTempo = SEC_TO_TIME( TIME_TO_SEC(tTempo) + TIME_TO_SEC('00:20:00') )…
-
1
votes1
answer38
viewsA: Query to get all records regardless of whether they exist in another table or not
Use LEFT JOIN for this. SELECT u.contribuinte, u.nome, u.tlm FROM utilizador AS u LEFT JOIN entrada AS e ON u.contribuinte = e.contribuinte WHERE u.nome LIKE '%".$utilizador."%' ORDER BY…
-
1
votes3
answers14234
viewsA: Remove options from select with jQuery
Simply 'clear' the select html, as follows: $("#profissionalFiltro").html(''); Or so: $("#profissionalFiltro").html('<option value="">Selecione</option>');…
-
1
votes1
answer25
viewsA: Get Only Registry Ranking Number in One Query
Do a SELECT that picks up this result and then you do the WHERE, that way: SELECT b.ranking FROM ( SELECT a.id_concessionaria, a.avscore, @rank := @rank + 1 AS ranking FROM ( SELECT…
mysqlanswered Givanildo R. de Oliveira 534 -
1
votes1
answer41
viewsA: Active section in the div
That solves Brow: $( '#quote-popup-tabs li:eq(0)' ).click(); If you want, you can put in the functions123.js file on line 502, which is right after the function: $( '#quote-popup-tabs li' ).click(…
-
-1
votes1
answer503
viewsA: Fill Modal with Database data
Set the ajax to: $.ajax({ ... data : { rowid : rowid }, ... })
-
1
votes1
answer151
viewsA: Array receiving two objects
From what I understand, this should solve your question. var obj1 = {1:"1", 2:"2"}; var obj2 = {1:"teste 1", 2:"teste 2"}; var arr = []; for( i in obj1 ){ arr.push(…
-
0
votes1
answer93
viewsA: Form destination page via GET with custom link
Well, I imagine a javascript function to solve this. <script> function enviaDados(){ var campos = [ document.getElementById('campo1').value, document.getElementById('campo2').value,…
phpanswered Givanildo R. de Oliveira 534 -
0
votes1
answer34
viewsA: Resize the form as hidden fields are displayed
Put an overflow-y in the Gray background div. <div style="width:100%; height: 700px; background-color: gray; overflow-y: auto;">
javascriptanswered Givanildo R. de Oliveira 534 -
2
votes2
answers270
viewsA: Convert bank date to AJAX
In the case of a date and time field: <input type="datetime-local" class="dataFiltro" /> You don’t need to convert, just concatenate the date with the time: ... success: function(data) { var…
-
2
votes1
answer83
viewsA: Facebook, Google+ and Twitter sharing goals
As far as the targets are concerned, I believe they are more than sufficient, they are the main ones. What you can do to help is work with structured data. If you don’t work with this, consider…
-
1
votes2
answers773
viewsA: Disable line breaking by pressing enter with javascript
To stop breaking the line and posting blank, do the following: if(code == 13) { var post = $('.status-box').val(); if( post.length > 0 ) { $('<li>').text(post).prependTo('.posts');…
-
1
votes1
answer499
viewsA: How do sum and Count in Mysql?
SELECT b.falhas, SUM(a.falhas) FROM tabela AS a, tabela AS b WHERE a.id <= b.id GROUP BY b.falhas ORDER BY b.falhas DESC
mysqlanswered Givanildo R. de Oliveira 534 -
2
votes1
answer337
viewsA: Change A style when hovering LI
On the line where: .topMenu ul > li:hover { ... } Put it that way: .topMenu ul > li:hover, .topMenu ul > li:hover a { ... }…
cssanswered Givanildo R. de Oliveira 534