Posts by kurole • 123 points
9 posts
-
0
votes1
answer16
viewsA: Delete a key from all arrays if null or empty
Folks abei trying here and got we assume that $arr_comp is my above-mentioned array. foreach($arr_comp as $cha => $val){ foreach($val as $cha2 => $val2){ $arr_new[$cha2][] = $val2; } }…
-
0
votes1
answer16
viewsQ: Delete a key from all arrays if null or empty
Array ( [0] => Array ( [Foto] => imagem.jpg [Código] => 311102 [Tipo] => Meu tipo [Cidade] => Araçatuba [Valor] => [Mais Info] => Todos juntos ) [1] => Array ( [Foto] =>…
-
1
votes0
answers132
viewsQ: CRONTAB Run for a certain time
Hello I’m having trouble running php’s Document root directly on crontab current rule working correctly 23 23 * * * Sleep 33 && wget -t 1 -T 1800 http://www.dominio.com.br/script.php…
-
-1
votes1
answer85
viewsQ: Import Emails to a CRM
I would like to know how to integrate the messages sent via CRM in php, and when the person responds, can import the email automatically to CRM. I imagined something like this, enable the mail on…
-
1
votes0
answers41
viewsQ: Replace, tag with attributes for merging documents
Hello I am creating a document that makes it possible to merge through tags, but, I will allow the user to add a separation within the tag, because I am doing this, in case of a customer…
-
1
votes0
answers122
viewsQ: Which best Mysql index
Hello I have a question about explain, index in mysql Real Estate Table 47.240 Table of Order of Attendance 1,887,421 SELECT SQL_NO_CACHE COUNT(*) FROM imoveis I INNER JOIN situacao_cod_venda SCV ON…
-
1
votes2
answers465
viewsA: UPDATE in Mysql based on the last date of a column
Hello tried to do so UPDATE Cliente C SET C.status = 'Alerta' WHERE EXISTS( SELECT A.dataAgendada FROM Agendamento A WHERE C.idCliente = A.idCliente AND DATE(A.dataAgendada) = DATE(NOW()) )…
-
2
votes3
answers331
viewsQ: PHP remove a URI snippet with regular expression
I have the following Uri $uri = "http://www.meudominio.com.br/pagina.php?campo=teste&ordem=2&cor=azul" how to remove the "ordem=2" of the above url with regular expression, knowing that the…
-
4
votes1
answer281
viewsQ: Optimize search in Mysql
Hello I have a query that I can’t optimize. Records: 1.904.447 records Name: table_mae Related to Records: 10.748.360 records Name: table_son -- index criado para id_tabela_mae -- index criado para…