Posts by Italo Rodrigo • 4,344 points
275 posts
-
9
votes4
answers21837
viewsA: Where is Notepad++ "Plugin Manager?
Download the . zip file from this page -> https://sourceforge.net/projects/npppluginmgr/ When unzipping, you will find two folders: plugins and Updater. To install, copy the . dll file from the…
notepad++answered Italo Rodrigo 4,344 -
3
votes3
answers1918
viewsA: How to change the line color of a Dbgrid in Delphi?
In your database you must have a field where you indicate if the value is an expense or revenue. Let’s say the name of this field is called 'guy'. You can change the colors like this: Two clicks on…
-
0
votes2
answers141
viewsA: Error duplicating HTML form in Mysql PHP Data Search
create any PHP file and write only the code below: <?php $host = 'localhost'; // endereço do servidor de banco de dados. $dbname = 'nome_do_banco'; //nome de sua base de dados $user =…
-
1
votes1
answer607
viewsA: no such table: tbcarro
according to the link on the side -> https://stackoverflow.com/questions/6554269/android-sqlite-no-such-table-error the error is as follows: There is an old version of the database on your device…
-
3
votes2
answers1593
viewsA: How to use the Oninput attribute?
The OnInput is not an element but an attribute/event that fires when the user enters something within an element (it can be the element <input>). Example: <input type="text"…
-
0
votes2
answers141
viewsA: Error duplicating HTML form in Mysql PHP Data Search
redacted <?php $host = 'localhost'; // endereço do servidor de banco de dados. $dbname = 'test'; //nome de sua base de dados $user = 'root'; // seu usuário do banco $pass = ''; // sua senha do…
-
1
votes1
answer2887
viewsQ: Include file in Wordpress
I have a site created in wordpress and need to include the command include 'config.php'; with some specific functions I need to use (including access to an external database). however, on all pages…
-
2
votes1
answer62
viewsA: Method being called several times
from what I’ve seen, you use verification activity.cliente != nullto send messages, but I didn’t see you go back to activity.cliente = null after sending and thus finishing the loop. hope it helps.…
-
1
votes1
answer3603
viewsQ: How to connect Mysql in Visual Studio 2015?
I have Visual Studio 2015, I created a project and I want to connect three databases in it (Firebird, Paradox and Mysql), initially the Mysql. I created a new project like this: C# > Windows >…
-
9
votes1
answer289
viewsQ: Why use a private?
I’m learning variables public and private. If it is I who create all the code of the program, what is the need to create a variable private? It is enough that I do not program a code that accesses…
-
0
votes2
answers58
viewsA: Strange error when adding
see if you can adapt this function to what you want. function somar() { total = 0; //variavel começa zerada //funcao each que varre todos os elementos do tipo que voce quer $("input").each(function(…
javascriptanswered Italo Rodrigo 4,344 -
3
votes2
answers167
viewsA: Take mysql field dynamically
I resolved: I use the following code in loop to know if the fields exist and echo them. if (isset($linha[0]['a'.$anoini])){ echo $linha[0]['a'.$anoini]; } hug to all who helped…
-
4
votes2
answers167
viewsQ: Take mysql field dynamically
I created a select command based on information sent by the user, e.g.: $anoini = $_GET['anoini']; //variavel com ano escolhido pelo usuário $anofim = 2016; //ano final é 2016 $s = 'SELECT…
-
3
votes1
answer269
viewsQ: PIVOT - SELECT reversing row and column
I have a table like this: codigo ano quant 100 2014 15 100 2015 13 100 2016 20 101 2015 15 102 2016 22 102 2014 05 I want to create a query that lists me the code like this: codigo 2014 2015 2016…
-
3
votes1
answer457
viewsA: Make a SELECT COUNT(*) FROM table
Your file <?php require("Configs/connection.php"); $host = 'localhost'; // endereço do servidor de banco de dados. $dbname = 'tabela'; //nome de sua base de dados $user = 'root'; // seu usuário…
phpanswered Italo Rodrigo 4,344 -
-1
votes1
answer545
viewsQ: Pick up specific fetchAll item in PHP
I’m using the code: $lista = $db->query('select * from tabela') or trigger_error($db->error); $lista->execute(); $item = $lista->fetchAll(PDO::FETCH_ASSOC); $mes = 1; while ($mes <…
-
2
votes1
answer70
viewsA: Can you improve these 12 selects where only one parameter varies?
Solved with the help of Bacco. the final code was thus: SELECT COUNT(*) total, MONTH(data) mes FROM tabela WHERE YEAR(data) = "2016" GROUP BY MONTH(data) I didn’t need to use one select inside…
-
1
votes1
answer70
viewsQ: Can you improve these 12 selects where only one parameter varies?
I have an online table with about 3 thousand records. I make twelve selects to list the results per month, ex: select count(campo) from tabela where extract(year from data) = 2016 and extract(month…
-
1
votes2
answers137
viewsQ: Wordpress - How to include new fields in the user table?
I want to include the following fields in the registration of registered users in my blog: IBGE, Municipality and UF. How do I include these fields and later access them on a specific page?…
-
-4
votes2
answers1838
viewsA: How to force the favicon.ico update?
if your internet provider is local, the guy should use cache and you access only some current files from your online site, other files (like icone for example), Windows access the version stored in…
-
0
votes2
answers1511
viewsA: How to Reset Form Select2 and Multiselect Fields
try like this: $('#multiselect').prop('selectedIndex',0); $('#select2').prop('selectedIndex',0); this code will leave selected the first item
-
0
votes2
answers565
viewsQ: Firebird Select Query using same field twice
I have a field called patiente_id, I want to create a select +- like this select count(paciente_id where = 0), count(paciente_id where <> 0) from agenda I don’t know it was clear, but I want…
-
0
votes2
answers761
viewsQ: Firebird - Select to join two or more lines
I have a table with the following structure: Cliente_id | credito | debito | pedido 1 100 1 1 150 1 1 30 1 2 200 2 2 180 2 How to make a Select that the result is similar to the below? Cliente_id |…
-
2
votes1
answer189
viewsQ: Delphi - Date Comparison Error
I compared two dates. When the variable 'date' contains the date of TODAY, the code understands that it is smaller if data < now then begin ...//se a variável DATA fosse igual a hoje (now), ele…
-
1
votes2
answers57
viewsQ: Nullpointerexception error when obtaining location
I’m making an app that shows user coordinates: This works properly and checks if the GPS is released: public void verificaGPS(){ if (ActivityCompat.checkSelfPermission(this,…