Posts by milho • 161 points
18 posts
-
1
votes1
answer52
viewsQ: How to merge these 2 dataframes and filter the latest timestamp to repeated values?
I have 2 dataframes that I would like to merge DF1: MRN Encounter ID First Name Last Name Birth Date Admission D/T \ 0 1 1234 John Doe 01/02/1999 04/12/2002 5:00 PM 1 2 2345 Joanne Lee 04/19/2002…
-
0
votes1
answer56
viewsA: Stored procedures in mysql do not validate type?
I figured out what it was and how to solve it. In mysql settings it is possible to set the sql_mode="STRICT_ALL_TABLES"; When executing this command, stored procedures will validate the type of…
-
0
votes1
answer56
viewsQ: Stored procedures in mysql do not validate type?
I have a stored file in my mysql that is in simple, it selects a table and filters by an id. Follow the store: create definer procedure fn_get_client_data(IN _email varchar(100), IN _id_loja int)…
-
1
votes1
answer37
viewsA: How to make a Bulk update with two primary keys in the stored mysql database?
I found a solution, would use INSERT with ON DUPLICATE KEY UPDATE. It will attempt to perform an Insert and, if it is a duplicate record, it updates the last record. Example: INSERT INTO my_table…
-
0
votes1
answer37
viewsQ: How to make a Bulk update with two primary keys in the stored mysql database?
I need to perform an update several times as follows: UPDATE my_table set column1='value1', column2='value2' where primary_key1=1 and primary_key2=2; UPDATE my_table set column1='value3',…
-
2
votes0
answers35
viewsQ: Angular8 - How to remove a <style> from a <div> by its class?
I’m using a library called angular-gauge-Chart to insert a gauge gauge gauge in my application. It works perfectly, however, it has some styles, like style='350px', which are default and I can’t…
-
5
votes4
answers319
viewsQ: Regex - set 2 limits and pick up all content inside
In the string below, I need to get the text content from ENERGIA ELETRICA CONSUMO up to the percentage symbol %. That is to say: ENERGIA ELETRICA CONSUMO kWh 370 0,787324 291,31 291,31 29,00% Is it…
-
1
votes1
answer124
viewsQ: Laravel - Inserting & Updating Related Models
in the Laravel documentation it teaches how to do Insert on related models. Here is an example of how to do it in the documentation: Inserting & Updating Related Models $comment = new…
-
-4
votes1
answer159
viewsQ: What is the format of this hour?
What is the date and time format in PHP 7.2? 2019-05-13T10:00:00.000Z For example, the time date 2019-01-01 10:00:00 has the format Y-m-d H:i:s.…
-
2
votes2
answers750
viewsQ: Formatting Date, Time and Time in PHP
I have the following string: 2019-05-13T10:00:00.000Z And I’d like to turn it into this format: 'Y-m-d\TH:i:s'. But I couldn’t find in any documentation what the correct time zone format for the…
-
1
votes1
answer796
viewsA: Apache2 does not run php files
I managed to solve. If someone had the same problem, first I uninstalled php: sudo apt-get purge php7.* then installed again sudo apt-get install php and enabled for apache 2 sudo a2enmod php7.0…
-
0
votes1
answer796
viewsQ: Apache2 does not run php files
My php files do not run in the browser when I access the localhost (var/www/html/index.php). The code is displayed as if it were a common text file. Configs of the system: Apache2 Ubuntu 18.04 LRS…
-
0
votes3
answers139
views -
0
votes1
answer121
viewsQ: Print array on Twig
I have an array with the following structure: array(20) { [0]=> array(13) { ["id_question"]=> string(10) "1312352154" ["date_created"]=> string(19) "2018-06-20 18:08:38" ["anuncio"]=>…
-
0
votes2
answers155
viewsA: Factor Hackerrank Solution - Using Algorithms Only
@Isac, I was able to reach the following solution using 1 for and 1 if only function migratoryBirds($n, $ar) { $contagem = 0; $passaro = []; $maior = 0; $menorChave= 0 ; for($i=0; $i < $n; $i++…
-
1
votes2
answers155
viewsQ: Factor Hackerrank Solution - Using Algorithms Only
I am learning to program and I am doing the hackerrank algorithm exercises. I am in the migratory exercise Birds. To access the exercise you need login access. As many do not have access, I will…
-
0
votes0
answers86
views -
0
votes0
answers546
viewsQ: Uncaught Error: Syntax error, unrecognized Expression: #botao_resp_<?= $Row['id']? >
I have a page with Formularies to answer questions and I am trying to use jquery in a separate file and is giving the following error: Uncaught Error: Syntax error, unrecognized Expression: #boot_…