Posts by DeBarros • 335 points
9 posts
-
1
votes3
answers2852
views -
2
votes1
answer100
viewsQ: Generate a table from another 5
I need help to build a query that brings data from 5 other tables. I will try to be as clear as possible, in case information is lacking, please inform me. Come on: I have the Midias table:…
-
2
votes2
answers707
viewsQ: Query Mysql returns no error or result
I have five tables in which each one of them has data that I need to be displayed grouped by date. Proposals are grouped by date, number of proposals, value of proposals, media, amount invested,…
-
4
votes1
answer605
viewsQ: Recover Corrupted . gz File
I have a file in . gz which is corrupted. Is it possible to extract data from this file? Even if it is partially? This file is a sql database dump. Thanks.
-
4
votes4
answers23723
viewsA: How not to write duplicate data to Mysql with PHP?
You can also put the field you don’t want repetition as UNIQUE: ADD UNIQUE INDEX `campo_da_tabela_UNIQUE`
-
1
votes3
answers853
viewsA: MYSQL How to order this date field
To use dates in a database the correct is to have a field in the datetime format() (https://dev.mysql.com/doc/refman/5.1/en/datetime.html) and then you’ll be able to do the ordination by date.…
-
2
votes2
answers2943
viewsA: Deprecated Error: Function ereg()
Your php version is up to date and letting you know that ereg no longer works. You can substitute for preg_match() which is an alternative.
-
0
votes4
answers483
viewsA: Is it possible to check the size of a string that is inside an array?
Use the strlen (http://br1.php.net/manual/en/function.strlen.php) to know if the stringé is greater than 0. isset will only tell if the variable was started, which in this case was, by, started…
-
6
votes2
answers2478
viewsQ: How to insert multiple arrays into a Mysql table
I receive via Ajax a request $_POST with 5 indexes and the last 3 are Arrays. It’s kind of like this: Array ( [c] => [s] => [dt] => [nl] => Array ( [0] => valor1 [1] => valor2 [2]…