Posts by João Paulo Araujo • 359 points
22 posts
-
0
votes2
answers37
viewsA: Error summing using Join and sub-query - MYSQL
Try it like this: SELECT *, (SELECT SUM(deposito2.valor_deposito) FROM deposito deposito2 WHERE deposito2.id_nota = deposito.id_nota ) AS amount from deposito inner join notas on notas.id_nota =…
-
0
votes2
answers153
viewsA: Remove duplicity in two columns
Try this, I hope it helps SELECT * FROM nome_tabela WHERE Coluna1 NOT IN ( SELECT Coluna1 FROM nome_tabela GROUP BY Coluna1 HAVING Count(*) > 1 ) And Coluna2 NOT IN ( SELECT Coluna2 FROM…
-
1
votes1
answer40
viewsA: How do I set the date of Bootstrap Datepicker to null?
Try to use defaultDate $('#datepicker') .datepicker({ format: "dd/mm/yyyy", language: "pt-BR", orientation: "top auto", defaultDate: '00/00/0000' });…
-
0
votes1
answer198
viewsA: How to drag selected text to the left with sublime text?
Select the block and try to use the keys combined this way: Shift+TAB.
sublime-textanswered João Paulo Araujo 359 -
0
votes1
answer71
viewsA: How to upload an image through its path stored in the database?
You’re putting inside the attribute src tag img? If yes, then you have to look in the way of where the code file is, and the image.
phpmyadminanswered João Paulo Araujo 359 -
1
votes3
answers229
viewsA: Fatal error: Uncaught Error: Call to Undefined Function mb_substr_count()
Access your php.ini, search extension=e look at the list of extensions. If there is none with the name mbstring, the extension should be installed. If the line is commented (if you have ; in front),…
-
0
votes1
answer29
viewsA: Searches in mysql - Accented letters
Change the type of encoding your bank uses, do so ALTER DATABASE `seu_banco`CHARSET = UTF8 COLLATE = utf8_general_ci;
-
1
votes2
answers422
viewsA: Error installing nodemon globally
Just use "SUDO", this is access permission error sudo npm install -g [email protected] --save-dev --save-exact
-
0
votes1
answer61
viewsA: E-mail with Phpmailer using PHP variable
Try to leave it that way, php already treats these two variables as strings, so you don’t have to worry about the quotes(" "), try it that way, just couldn’t find the "$email" email, since you put…
-
1
votes1
answer128
viewsA: How to pass a php variable to shell_exec
I hope it helps <?php $qtdteste = $_POST['testes']; shell_exec('/bin/speedtest '.$qtdteste.' -l');
-
0
votes1
answer109
viewsA: PHP code to send a sms via API to a phone list
Try this <?php $ch = curl_init(); $lista_telefone[] = '888888888'; $lista_telefone[] = '999999999'; $data = []; foreach($lista_telefone as $indice => $numero){ $array_numero = array('key'…
-
0
votes1
answer135
viewsA: How to close a td with a tr after the loop and continue printing the rest of the code in PHP
Change to that, I changed inside the second foreach require_once("db.php"); $sql = $pdo->query("SELECT site FROM tabelactr GROUP BY site"); $resultsql1 = $sql->fetchAll(); $i=0; $conteudo =…
-
0
votes2
answers82
viewsA: Use For in Javascript in an HTML concatenation
Try this function listAjustes(){ $.ajax({ type : 'ajax', url : 'diversos/show', async : false, dataType : 'json', success : function(data){ var html = ''; var i; for(i=0; i<data.diversos.length;…
-
2
votes3
answers216
viewsA: As a search for any term removing spaces, traces and points with LIKE
My dear, try this way, if it doesn’t work let me know to look for another solution and if it meets the characters, if they are really in utf8 $palavras = explode(' ', $pesquisa); $sqla = "";…
-
-1
votes3
answers1112
viewsA: how to create search system using filter
Change your query to this $sql = $pdo->query("SELECT * FROM usuarios WHERE nome LIKE '$nome' OR idade = '$idade' OR email LIKE '$email' ");
-
0
votes3
answers65
viewsA: Select the next TD within a Loop
I don’t quite understand, but I did it to help you. <script> $("tr td:first-child").each( function(index) { var texto = $(this).closest("tr td").text(); if(texto == "administração"){ var…
jqueryanswered João Paulo Araujo 359 -
1
votes3
answers95
viewsA: How can I copy content from a div to a hiddenfield?
To get the html of any div with jquery use the following argument var valorDiv = $('#list').html(); $('#id_input').val(valorDiv);
-
0
votes1
answer266
viewsA: How to update @angular/core globally?
That link can help you if you are using the npm Applying some of the changes npm i -g @angular/[email protected]…
-
7
votes2
answers1019
viewsA: select bringing all un-duplicated records based on a single column
Try this. SELECT * FROM nome_tabela WHERE tela NOT IN ( SELECT tela FROM nome_tabela GROUP BY tela HAVING Count(*) > 1 ) Or you can try it SELECT tela FROM nome_tabela GROUP BY tela HAVING…
-
-1
votes3
answers247
viewsA: I cannot send form data with AJAX
Try using jquery to send the data, it looks like this: $.post(form_url, form_data, function(returnhtml){ if(returnhtml){ $("form").css({"display": "none"}); $('h2').html('Parabéns!');…
-
0
votes2
answers110
viewsA: Error calling Java Script in HTML
Place the script on the page of your "paginadeconteudo.php" content, including the Mask, jquery, and return: echo '<script> $("#cpf").mask("000.000.000-00"); $("#tel, #tel2").mask("(00)…
-
1
votes4
answers134
viewsA: Mysql query involving Profession and Note information registered in the same column
Follow-up: SELECT count(*) as qtd_otimo FROM tabela t1 INNER JOIN tabela t2 ON t2.inf_codigo_contrato = t1.inf_codigo_contrato WHERE t1.inf_codigo_variavel = 117 AND t1.inf_valor='ANALISTA DE…
mysqlanswered João Paulo Araujo 359