Posts by Denis L. Murara • 645 points
37 posts
-
1
votes1
answer24
viewsA: Existing dropdown menu (no bootstrap) stopped working after bootstrap library use
I convinced the client to change the dropdown!
-
0
votes1
answer24
viewsQ: Existing dropdown menu (no bootstrap) stopped working after bootstrap library use
I have in the client’s page a dropdown menu that the client does not want to exchange. I had to insert a modal on the page and used bootstrap, it worked well. The problem is that the client dropdown…
-
-1
votes1
answer810
viewsQ: Search date and time range PHP MYSQL
Assuming there is an ex date range: 2019-02-22 and 2019-02-26 I need to search the database by date and time (I need to extract the value by specific date and time, for example only from 05:00 to…
-
0
votes3
answers1090
viewsQ: array in a php foreach
I’ll try to be objective in doubt: I have the following code: <?php foreach ($modelo as $k => $v) { $sql_ = "SELECT * FROM pedido WHERE modelo LIKE '%".$v."%' ORDER BY id ASC"; $disp_sql_ =…
-
0
votes1
answer154
viewsA: Organizing month order in a php array
I managed to solve only by changing the 'usort', by the 'uasort', sorts based on my base array ($Sort), but keeping the keys. $sort = array('Janeiro', 'janeiro','Fevereiro', 'fevereiro','Março',…
-
0
votes1
answer154
viewsQ: Organizing month order in a php array
I used the function below to organize the orders of the months in ascending order, it works perfectly, but it loses the keys, when it creates the new array organized, keys start from 0 (zero) again…
-
0
votes1
answer149
viewsA: Add PHP multidimensional array
I got it with the following code: $second_array = array_reduce($first_array, function($carry, $item) { $key = sprintf('%s-%s', $item['data'], $item['maq']); if (isset($carry[$key])) {…
-
0
votes1
answer149
viewsQ: Add PHP multidimensional array
Good morning, I have the following array: Array ( [0] => Array( [data] => 2018-06-08 [grupo] => 1 [maq] => 1 [segundos] => 10089 ) [1] => Array ( [data] => 2018-06-08 [grupo]…
-
0
votes2
answers905
viewsA: Add values from the same PHP array
Thanks for all your help, I got it with the following code: $soma_array = array(); foreach ($producao_ as $k=>$subArray) { foreach ($subArray as $id=>$v) { $soma_array[$id]+=$v; } }…
-
-1
votes2
answers905
viewsQ: Add values from the same PHP array
It seems to be simple but could not, I would like to add the following array (are two arrays within one, it is divided with the array_chunk): $arr = [ [1, 2, 3, 4, 5], [6, 7, 8, 9, 0] ]; I would…
-
0
votes1
answer46
viewsQ: Group values in a Mysql PHP query
I am pulling values BD for a table with the results of the query, this search is by date, is working perfectly if I search for a single day, but I would like when to search for two or more days (ex…
-
2
votes3
answers92
viewsQ: Insert summary when there is a change in a PHP Array
to with a doubt that may be easy, but to broken the head, I have a table that is generated through an array, follows code below: foreach($grupo_arr $k => $v){ ?> <tr> <td><?php…
-
0
votes1
answer42
viewsA: Production in PHP hours
I managed with the following gambiarra: $horario: '08:20:00'; $pares_p_hora : !valor vindo do BD; $producao = !valor vindo do BD; $segundos = strtotime('1970-01-01 '.$horario.'UTC'); $tempo_producao…
-
0
votes1
answer42
viewsQ: Production in PHP hours
Talks personal, I’m developing a page, and arrived at the time I particularly do not understand much, calculation of hours in php, following: I have values that come from the database, which are:…
-
-2
votes1
answer415
viewsQ: Menu does not appear in mobile version
Good morning everyone, to finalizing a page that has an external menu, requested in PHP with require, I have also tried include, but still continues with the same problem, as images below the menu…
-
0
votes3
answers682
viewsA: Sum of an array and PHP value concatenation
For future research, I was able to add the key 'quantity' with the following code: Date variable is the variable that contains the array: $data ( [0] => Array ( [tag] => 5x1 Acessori Kids -…
-
0
votes3
answers682
viewsQ: Sum of an array and PHP value concatenation
I have a dynamic array, it contains duplicate keys (TAG): [0] => Array ( [0] => Array ( [tag] => 5x1 Acessori Kids [pedido] => 6701622409 [quantidade] => 2125 ) ) [1] => Array (…
-
0
votes1
answer796
viewsQ: Copy values from a PHP array
I have two arrays dynamics in my system: Array 1: $nome { [0] => nome1 [1] => nome2 } Array 2: $contagem { [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 } These two arrays, are…
-
4
votes3
answers1317
viewsQ: Remove duplicate values from an array - php
I need to remove duplicate values from a PHP array, for example: $array = ('2015', '2015', '2012', '2013', '2014', '2014', '2016') I wish I had the output: Array ( [0] => 2012 [1] => 2013 [2]…
-
0
votes3
answers1885
viewsQ: Select different values in two tables - SQL and PHP
I have two tables to pedido_tb and the pedido_grade, what I want to do is compare, the values of the column "request" of the requested table and column "n_pedido" of pedido_grade, basically, would…
-
1
votes1
answer2709
viewsQ: Form inside an html form
A doubt that may be simple, but I had no choice: I have a main HTML form, which captures all the data of a table, the problem is that there is the upload of images inside this form, and this upload…
-
1
votes0
answers183
viewsQ: CSS Element "passing" over each other in a li
I have a custom select (Dropbox), in which there is a search field in the list, this select with jquery was downloaded (I didn’t do it), well, I had to position one over the other for my purpose,…
-
-1
votes1
answer575
viewsQ: Calculate percentage in dynamic field
I have inputs like text where a javascript function takes these input values and makes a percentage account, works correctly, the problem is that depending on the input data these fields become…
-
5
votes1
answer3351
viewsQ: MACRO in Excel - printing with sequential numbers
I have a macro from a few years ago that still works, when I click to print the production orders of my company, I put the start and end number, and the macro prints the Ops with the numbers in…
-
3
votes1
answer1088
viewsQ: EXCEL Paint a certain amount of cells
I have a spreadsheet that works like a chart of Gantt, that goes from day 01 to day 31, and my doubt is simple, based on the day calculation of an order, 12 days for example, have how I make excel…
excelasked Denis L. Murara 645 -
3
votes2
answers550
viewsQ: Logic with date in excel
People, I am developing a spreadsheet to better control the production of the factory in which I work, I do not understand much of excel and I have a doubt that it may be simple to solve. Next, I…
-
4
votes1
answer1376
viewsQ: Dividing integers in MS Excel (exact division)
I have a problem in Excel that I thought would be easy to solve, but to breaking my head is the following: I have an order grid, for example, 2,010 pairs, and the production control and the…
excelasked Denis L. Murara 645 -
3
votes1
answer3099
viewsQ: PHP route system using Google Maps API
I’m finishing a system in PHP, where the client asked if it has how, generate a route between companies, and generate the shortest, for example, it has 50 companies registered in the database, with…
-
0
votes2
answers2308
viewsQ: Dynamic form? how to do?
I have the following question, I have one while in PHP, and in this while have a form and a button of Submit who sends this form, but as there are several records he repeats this form and the system…
-
3
votes3
answers736
viewsQ: Multiple UPDATE from a dynamic field
I’m trying to catch the ids that come by user-selected checkbox (array), and through these ids, update the table, with the following code: $ocs_imp = $_POST['check_imprime']; $contar =…
-
2
votes1
answer604
viewsQ: Store Variable within a While
I’m having a simple doubt but it’s cracking my head: I have a form where there are several checkbox, the checkbox value is an id number, I would like to create something that when the user selects a…
-
4
votes1
answer2998
viewsA: Timestamp update automatically with current date
galera got with the simple sql command below. thanks to all ALTER TABLE `grade_edt` CHANGE `data_ultima_mod` `data_ultima_mod` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;…
-
3
votes1
answer2998
viewsQ: Timestamp update automatically with current date
I wonder if it is possible, when one is made INSERT in a given table, automatically update the value of another column of the TIMESTAMP type called date with the current date and time, similar to…
-
2
votes1
answer552
viewsA: PHP Mysqli Array in select html
I did, with the following Cod: <?php include('conn/conexao.php'); $edt = $_GET['edital']; $sql = "SELECT * FROM edt_cadastro WHERE id = $edt"; $res = $mysqli->query($sql); $i = 0; ?>…
-
3
votes1
answer552
viewsQ: PHP Mysqli Array in select html
I’m a beginner in php and I’m developing a small system for my company and that already serves as a study, because I like this area, doubt is simple, I have the code below: <?php…
-
1
votes2
answers2335
viewsQ: PHP with HTML - Place an array inside a select html
Hello, I am beginner and I have the following question, I have an array, where one of the parameters comes from the bank, where the number 5 is, comes from the bank. $inicio = 1; $ultimo = 5; //esse…
-
1
votes2
answers474
viewsQ: Convert an entire number from the database into an Array
I want to convert an entire number from the BD into an Array, for example: I have the number of deliveries registered in the BD, let’s assume that the 'x' production is completed in 5 deliveries.…