Posts by Saulo • 93 points
18 posts
-
-2
votes2
answers39
viewsQ: Taking values from a for
Very simple doubt indeed. I have the following list: fruits = {"apple":"123", "banana":"456", "cherry":"789"} for fruit in fruits: print(fruit) How do I stop in my return appear the numbers of each?…
-
0
votes0
answers14
viewsQ: Using the getColletion function in Pymongo
some can help me with the following problem? Inside mongoDB, the colletion was created with space, example: "Mkt pipe". mongoDB allowed to do this kind of thing. I created the following route to…
-
1
votes1
answer23
viewsA: Limit using group_contact in Mysql 5
I was able to solve using the Mysql function SUBSTRING_INDEX The final Consultation was as follows: SUBSTRING_INDEX( GROUP_CONCAT(DISTINCT `mvu5877_anuncios_photos`.`image` ORDER BY…
-
1
votes1
answer23
viewsQ: Limit using group_contact in Mysql 5
Good morning guys, I’m having a question: I have the following SQL example: group_concat( DISTINCT `mvu5877_anuncios_photos`.`image` ORDER BY `mvu5877_anuncios_photos`.`order` ASC SEPARATOR ',' ) AS…
-
0
votes0
answers16
viewsQ: Importing CSV with Nodejs Problems with CSV first column
Good evening guys, someone has already had the problem in importing a CSV where the first column of the file comes as Undefined? // import_customers_service…
-
0
votes1
answer37
viewsQ: Creating getFullYear with javascript
Good afternoon guys. See if you can help me with something. I need to generate a data list. Manufacturing Year and Model Year. I did it this way: var i; for (i = new Date().getFullYear(); i >=…
-
0
votes1
answer49
viewsA: group_contact using left Join mysql and separator
I solved the issue using the Mysql FIND_IN_SET function The result of the consultation was thus: SELECT prova.id, GROUP_CONCAT( DISTINCT `respostas`.`name` SEPARATOR ',' ) FROM LEFT JOIN respostas…
-
0
votes1
answer49
viewsQ: group_contact using left Join mysql and separator
Good afternoon, folks. I’m having a question how to mount a query using group_concat. I have 2 tables: Prova ID Name Respostas_ID Status 1 Teste 1 1,2 1 2 Teste 2 2,4,5 1 3 Teste 3 4,5 0 On the…
-
0
votes1
answer87
views -
0
votes1
answer87
views -
-1
votes2
answers49
viewsQ: Javascript code enhancement for site field validation
Good morning guys, I just need a little help improving a javascript field validation. In my form there is a field called website and I need to have a url validation (I already did) and I need to…
-
0
votes1
answer87
viewsQ: Error with AES_DECRYPT Mysql character and Codeigniter
Good afternoon guys. Would anyone like to help me find this mistake? I created a login area on the site, but I’m having trouble when the user uses in his password the exclamation character "!".…
-
1
votes1
answer133
views -
3
votes2
answers2119
viewsQ: Display creation date (created_at) in Laravel 5.5 post
Good morning guys, I am very beginner in Lisbon and I have a small problem that I am not able to solve. In a post view, I need to display the date the post was created. In the database it would be…
-
0
votes1
answer44
viewsQ: Join two array in php
Good morning guys, a quick question. I need to merge two array of a queries in the following way: $tamanhos = array('p', 'm', 'g'); $valor_item = array('10', '20', '30'); where "p" has to be equal…
-
0
votes1
answer60
viewsQ: Bring multiple values from a Join in mysql
Guys, I have a question about a mysql query using the Codeigniter Framework. I have the following tables: Table Products |--------|-----------------| | id | nome_produto |…
-
1
votes1
answer189
views -
1
votes3
answers260
viewsQ: Problem in PHP+Mysql query using LIKE
Good afternoon guys, recently in one of my projects a problem arose and I hope you can help me. To better understand the site is a site of consultations in the area of health, as clinics,…