Posts by Rodrigo Teixeira Andreotti • 166 points
12 posts
-
0
votes1
answer30
viewsA: How to use FILTER_VALIDATE_IP for an array?
Well, in this case you will have as response an array, your $ip variable will be like this: array( 0=>ip_1, 1=>ip_2 ... ) To validate this, you will need to use a loop to traverse the keys and…
-
2
votes2
answers129
viewsQ: Best way for database normalization
What would be the best way forward regarding data normalization? The system will have basically three types of "people": Agency Collaborator Client These entities have some common properties, for…
-
2
votes3
answers520
viewsA: Why do line breaks between elements cause space between them?
In reality it is precisely because of the indentation that the spacing occurs, because if one observes well a space is being generated, the rendering engine of html browsers ignores the additional…
-
1
votes1
answer77
viewsA: Filling table
Good... Actually I was a little mistaken with the error in the above comments, let’s go to the codes, rs. <tbody> <?php for($i = 1; $i <= 5; $i++){ //coloquei este valor para testar…
-
0
votes1
answer341
viewsA: Error creating zend framework module
Good afternoon! What version of Zend Framework are you using? if it is above 3.0, you need, in addition to the steps you used, to create the entry for your new module also in the file Composer.json…
-
-1
votes1
answer158
viewsA: How to update an Adsense div in x seconds without refreshing the page
Hello! Without updating the page you will need to use some ajax, and to do this x load in X second, you can use setInterval, follow references for you to base: Document Documentation setInterval…
-
0
votes2
answers692
viewsA: Problems with accentuation in Mysql
From what I saw, it’s like Dunga said, there may be a break in the string, try to escape the special characters to insert into the bank: $SQL = "INSERT INTO tb_detalhes_empresa (place_id,…
-
2
votes3
answers308
viewsA: problems with distinct in mysql
So, buddy, did you try to do it with Seamanship? Something in this sense: SELECT DISTINCT a.id, a.unidade, a.posicao, a.nome, a.peso, sum(b.qtd) quant FROM ( (SELECT a.id, a.unidade, a.posicao,…
mysqlanswered Rodrigo Teixeira Andreotti 166 -
1
votes1
answer342
viewsA: I can’t bring all the records from the table
Dude, I think the problem is precisely in Join, since it does not return data if there is no match in the two tables, try using LEFT OUTER JOIN instead of INNER JOIN or LEFT JOIN only. It would be…
-
1
votes2
answers697
viewsA: Problem with Utf 8 in reading txt file
Ah, now it’s easier =] You can try the following, I did here on jsfiddle and it worked. In this line: reader.readAsText((onChangeEvent.srcElement || onChangeEvent.target).files[0]); Replaces by…
-
-2
votes2
answers697
viewsA: Problem with Utf 8 in reading txt file
Good, First of all, in the database is charset UTF=8 too? If yes, it may be the html file encoding (as the comment colleagues said), but it may also be the encoding of the connection to the…
-
2
votes2
answers1258
viewsA: Count values with specific data in MYSQL
Well, basically what you need to use is a Where in your query, try the following code: $result=mysql_query("SELECT count(*) as total from n_emails WHERE ativo='s'"); If you use with group by can…