Posts by Wpbarcelos • 424 points
22 posts
-
0
votes1
answer132
viewsA: How to remove an HTML element with Javascript
Friend you can do as follows... Store input from Description,value in an array; Render the list using map Total using map and reduce let productList = []; function renderProducts() { const html =…
-
0
votes2
answers69
viewsA: Query with more than one view field
What was missing was the group by of the field you want to bring, when no function aggregators do not need, MIN MAX COUNT SUM AVG. Remember to treat the null value of the transaction if the client…
-
1
votes1
answer91
viewsA: Pass array by Ajax and receive in PHP script
You don’t need to give one json_decode in his POST, the default of contentType ajax is application/x-www-form-urlencoded, that will make the requisition as if it were a form HTML. In this way:…
-
4
votes3
answers3355
viewsA: What is the difference between LOCATE and INSTR functions?
Locale accepts a third parameter, this is to inform from which position Voce wants to find the term in the string Mysql> SELECT LOCATE('bar', 'foobarbar'); -> 4 Mysql> SELECT LOCATE('xbar',…
-
2
votes3
answers9451
viewsA: What is the meaning of the sign || '-' || in SQL
Server For Concaternar String, in Oracle it is possible to concaterate string with number, however in SQL SERVER it is necessary to convert number to string
-
0
votes2
answers170
viewsA: Deactivate Combo select
<div class="form-group"> <label class="col-md-4 control-label" for="textinput">Parcelado: </label> <div class="col-md-4"> <div class="radio"…
-
1
votes1
answer1444
viewsA: ERROR 1242 (21000): Subquery Returns more than 1 Row
Your select is returning more than one expensive line Voce can solve like this DELIMITER // CREATE trigger VERIFICAENCERRADA BEFORE UPDATE ON ocorrencias FOR EACH ROW BEGIN SET @descricao_resolvida…
-
1
votes2
answers309
viewsA: Select in two tables with data from the first table?
SELECT * FROM usuarios u JOIN comentarios c ON c.id_usuario = u.id_usuario In your case it is ideal to make the ordered select on the recent comment date for the old ones, and check if really has a…
-
0
votes2
answers166
viewsA: Open Window behind main window
how are you using jquery ... utilize jquery-ui, very easy to implement Example jquery-ui Docs <!doctype html> <html lang="en"> <head> <meta charset="utf-8">…
-
0
votes2
answers51
viewsA: Pick up records that are there 3 days to win
In Mysql the query to be used is $sql = "select * from cotas where datediff(ultimo_recebimento,now()) <= 3"; The Function now() Mysql returns the time the query was executed. ***Use the database…
-
1
votes1
answer279
viewsA: How to run a command on Android when touching the screen or swiping your finger on the screen?
You have instantiating an element in your Activity class, although d is not very indicated does package com.containersol.scecarro; import android.app.Activity; import android.view.View; import…
-
2
votes3
answers2883
viewsA: Insert combobox data into a SELECT
Code of the Codepen /* Dropdown with Multiple checkbox select with jQuery - May 27, 2013 (c) 2013 @ElmahdiMahmoud license: http://www.opensource.org/licenses/mit-license.php */ $(".dropdown dt…
-
3
votes3
answers2379
viewsA: When is the controller needed?
The MVC is related in the organization of your application, the Controller is the intermediate layer between the Model and View. In the example you mentioned is not demonstrating the full potential…
mvcanswered Wpbarcelos 424 -
4
votes2
answers869
viewsA: What is Finally for in PHP 5.5?
Try => It is the command block that you want to run Catch = > This is the command block you run if an error occurs (Exception). You Can Treat Multiple exceptions. Catch will only be executed…
-
1
votes1
answer440
viewsA: Dialog to feed Form field
Recital 2 archives php table.: <table> <tr> <td>Linha1 -Valor 1</td><td>Linha1 -Valor 2</td><td>Linha1 -Valor 3</td><td>Linha1 -Valor…
-
-1
votes3
answers3942
viewsA: Scroll on page adds "ACTIVE" class to menu
$(a[href^='#']).click(function(){ $(nav navbar-nav menu a).removeClass('active'); $(this).addClass('active'); return false; });
-
2
votes2
answers600
viewsA: How to read a file with an email list?
Starting from the pre-presumed that the bank has the emails table, and that the file is teste.txt: // Pega o conteudo do arquivo teste.txt $arquivo_texto = file_get_contents('teste.txt'); // Cria um…
-
1
votes5
answers7269
viewsA: Use if inside foreach
Instead of displaying inside the foreach, store these values within a string and when you finish the look print the biggest $and then the lowest $ $numeros = array(1, 2, 3, 4, 5, 6, 7, 8, 9);…
-
1
votes3
answers24286
viewsA: What is the difference between <div> and <Section>?
The benefit of using is semantic. If you only use css formatting, there really won’t be any difference. But if you write thinking of html semantics, Voce will create facilitators for search systems…
html5answered Wpbarcelos 424 -
2
votes2
answers1996
viewsA: Query PHP data using the $.get json method and list data in an html
In PHP file name = json.php <?php ... .../*consulta ao banco de dados*/ $rows=array(); while($row = mysql_fetch_assoc($result)) { $rows[]= $row; } header('Content-Type: application/json'); echo…
-
4
votes3
answers1143
viewsA: Loop output within another loop with SQL and PHP
Check the source code of the file. If Voce wants to store in a text file, just store all the echo into a variable and write to the file. <!DOCTYPE html> <html> <head> <meta…
-
1
votes4
answers1634
viewsA: Scroll with Jquery
Using the href of the links: <a href="#Id_da_div"> link </a> Ex: <a href="#contato">Fale Conosco</a> <script> $('a[href*=#]').click(function() { var destino =…