Posts by ivan veloso • 2,900 points
119 posts
-
0
votes1
answer833
viewsQ: Layout button in flutter
I’m trying to build a video player. However I’m not getting to leave the button the way I’d like. It’s like I need to "extend" the size of the button so that the intersection point of borderRadius…
-
5
votes2
answers255
viewsQ: Return the highest value between columns and the row ID of that highest value
Let’s say I have two columns in my table, column A and B. +-----+-----+-----+ | ID | A | B | +-----+-----+-----+ | 1 | 500 | 681 | +-----+-----+-----+ | 2 | 980 | 101 | +-----+-----+-----+ | 3 | 110…
-
3
votes1
answer56
viewsQ: Defining the chained methods of a method
Let’s say I have the following class: class animal{ private $animal; private $som; function gato(){ $this->animal = 'gato'; return $this; } function cachorro(){ $this->animal = 'cachorro';…
-
12
votes5
answers35616
viewsQ: SELECT condition WHERE with multiple values in the same column
I have two tables in my bank and perform JOIN with them. A table is a list of people and the other characteristic list of that person. By logic there is only one person and each person can have…
-
0
votes1
answer34
viewsQ: Split search term to enlarge results and sort results according to the term
Let’s say I have a table called carros. In this table I have some registered cars. Ex: ID | Name 1 | Corsa Amarelo 2 | Camaro 2 Portas Amarelo 3 | Camaro V12 Amarelo 4 | Camaro Esportivo Amarelo 5 |…
-
0
votes0
answers287
viewsQ: Turning all variables into global variables
I am developing a project and it works with many files and these files are called via require_once(). It is hard work to declare each variable created as a global variable in view of the number of…
-
0
votes3
answers781
viewsA: Printing schedules at predetermined intervals
The way you tried it would be possible, but it will be bad practice! In this case the ideal would be to use the native PHP function strtotime,and within the function pass as the current time…
-
1
votes1
answer800
viewsA: Upload images larger than 2mb
This error can be caused because of some settings on your server! In this case it is necessary to modify these values! If you are a localhost server, look for the "php.ini" file and look for the…
-
2
votes0
answers84
viewsQ: Method calling method
By my knowledge I can only call the method of a class only if I instantiate or if the method is static! I can just do something myself class->metodo('var') or class::metodo('var'). But I’ve seen…
-
1
votes1
answer1580
viewsA: Recover database from . frm and . idb files
As stated in the question, my ibdata was corrupted. At first my reaction was to copy the folders of the created tables and reinstall XAMP. The folders referring to the created database are in place…
-
1
votes1
answer1580
viewsQ: Recover database from . frm and . idb files
My backup got incomplete and corrupted my ibdata database, now my database does not access my tables. Keeps giving error! I don’t care about the data! But I really need the structure of the tables.…
-
6
votes4
answers1595
viewsQ: Leaving div height equal to width using css only
Let’s say I have 4 div, with the property width:25%. In a space of 1000px, this 25% would represent 250px. <div style="width:1000px"></div> <div style="width:25%;"></div>…
cssasked ivan veloso 2,900 -
1
votes2
answers241
viewsQ: A file with multiple functions OR multiple files with a function?
In the scope of my design use include("funcoes.php"), inside that file has all the functions I use in different parts of the project, I don’t use all the functions all the time. So a doubt! Pro…
-
0
votes2
answers98
viewsQ: Repeat condition in WHERE at the time of query
Currently use WHERE coluna IN (1,2,3,4) in my consultation. Only I realized that the IN works as a kind of "OR", it generates me a small problem, because the ID are features of a product. These…
-
1
votes2
answers1020
viewsQ: Delete record being duplicated in query with Inner Join
I am making a query to my database and in this query I use an INNER JOIN to join two tables! But I have a problem, because I do not know how to manipulate JOIN very well, and this is generating a…
-
0
votes1
answer38
viewsQ: Performance at query time to database
Suppose I have a table with 100,000 records, which in this example I will call dictionary, and will have a LIMIT of 1000 results. SELECT FROM * dicionario Let’s say that hypothetically I have…
-
1
votes1
answer31
viewsA: Content of an input to HREF
I don’t know if you really need to use PHP to do what you want! If it’s just a field! You can use a form with method="get" But if you don’t want to do it that way, just capture the input value, add…
phpanswered ivan veloso 2,900 -
0
votes1
answer1894
viewsQ: Using Function within Select
I have a select, within it I have a function : SELECT VAL1, VAL2, ".funcao('VAL1', 'VAL2')." AS soma FROM Conta WHERE soma < 100 Table structure CONTA -------------------- | ID | VAL1 | VAL2 |…
-
1
votes3
answers704
viewsQ: You can use two columns of the same table in a WHERE
In a select I can use in Where to filter the results, two columns of the same table? Ex: Select id, idpai, nome FROM tabela Where id=idpai
-
0
votes1
answer1829
viewsQ: Variable inside the WHERE of a select
I have a variable that changes your content according to some user actions! I intend to use this same variable within a select, as follows! " Select * FROM tabele WHERE '$variável' " But when I…
-
1
votes1
answer360
viewsQ: You can use a foreach of a query within a function
I have a query simple: $Consulta = $pdo->query(" SELECT * FROM dados ")->fetchAll(); foreach ($Consulta as $key) { echo $key["InfoDado"]; } If you execute the foreach of it out of a function!…
-
0
votes0
answers23
viewsQ: Registration with empty column affects performance at query time
Let’s say I have a table with 4 columns and 4 records. Not all columns are filled in at the time of the form because it is not mandatory, so the database has some gaps in its grid! Example: ID |…
-
1
votes1
answer266
viewsQ: Using Inner Join correctly and aggregating results
In my comic book, I have 4 tables: Aluno, Ano, Matérias and Nota. They are mounted as follows: Tabela :: Colunas ---------------------------------------------------------- Aluno :: AlunoID |…
-
0
votes1
answer73
viewsQ: Split widget on screen
I want to split two widget within the Layoutlinear, being both Textview . If I use "orientation="horizontal" and in the Textview use the attribute android:layout_weight="1", widgets were split on…
-
0
votes0
answers46
viewsQ: According to Scroll and apply class on the specific link in the menu
I’ve seen the effect on some sites! But I have no idea how to do it! The effect works in a set, formed by the menu the page body and the class! Let’s say I have a menu with three tabs, being A B C.…
-
1
votes2
answers45
viewsQ: Hide a certain amount of items
Supposing I was 10 div class="code" in my document! How do I add a button, so that when loading the page only 5 of these items is shown, and the other 5 are hidden, and after clicking the button…
jqueryasked ivan veloso 2,900 -
1
votes1
answer556
viewsQ: Block body scroll when Lightbox is open, but be able to scroll Lightbox content
Forgive me if I’m wrong, because I don’t know the exact name of the effect I’m looking for, I’ve seen such an effect on some web pages but at the moment I don’t have any link I can use as an…
-
2
votes2
answers4704
viewsQ: Count elements within a parent div separately
In Jquery it is possible to count the number of equal Ivs within another using the $(".pai .filha").length;. Example: <div class="pai"> <div class="filha"></div> <div…
-
1
votes1
answer45
viewsQ: How to take the whole result of a for, and make it become a single variable
Let’s say I have one for! And that the result of the is is " 1 2 3 4 5 6", only each number is a line!! How to take all these lines and make it become a single variable?
phpasked ivan veloso 2,900 -
7
votes2
answers1310
viewsQ: Is there any way to transfer Mysql data directly to an Excel table?
Is there any way to transfer all data from the database to a table in Excel? It can be with any language.
-
3
votes1
answer336
viewsQ: Blocking the Webview cache
I’m designing a Webapp, and I use a Webview to open a specific url within the app! Only the app is caching everything, so in case I come to make any changes to the site, the app doesn’t "compute"…
-
7
votes6
answers18836
viewsQ: Removing Titlebar from the android app
I’m starting on android, and know very little! I’m developing slowly and with each change I save the apk and see it running on my phone. I noticed that there is a bar in the app with the name of the…
-
2
votes2
answers3084
viewsQ: Swap div of place with jquery
Let’s say I have one div Mom, and inside that div I have another 3. And a Button. <div id="mae"> <div id="a" class="child"></div> <div id="b" class="child"></div>…
-
1
votes2
answers967
viewsQ: Error caused by line break in append
In jquery, if I insert the following code, error :: variavel.append('<div class="qualquer"> <div class="subdivs"> conteudo da subdiv </div> <div class="subdivs"> conteudo da…
-
1
votes2
answers168
viewsQ: Take all src contained in the document and transform into array in jquery
Assuming I have 10 img elements on my page. I would then like to create an array that contains the attr-src of each img contained on that page. How do I perform such a task?
jqueryasked ivan veloso 2,900 -
2
votes2
answers355
viewsQ: Split Divs into group with jquery
Assuming I have 4 Divs whose class is "block". With jQuery would like to divide the Divs into blocks of 2, and "encompass" each set of "blocks" within another div. I would like to make the code very…
-
4
votes6
answers650
viewsQ: How to extract a variable from within a function
Suppose I use the following function in .js... And inside it there are some variables. $(document).on("load", function(){ var Variavel1= "um"; var Variavel2= "dois"; var Variavel3= "tres"; var…
-
1
votes1
answer80
viewsQ: How to differentiate "001" from "1" in PHP?
If I compare 001 and 1 in PHP, it gives a result that the numbers are identical! Indeed it seems so! How do I differentiate 1 from 001, treat each one as if it were different?
-
0
votes1
answer629
viewsQ: input inserted with "append" is not "recognized"
I’m trying to make a slightly more dynamic form! But when adding new inputs with the append javascript, the same is not recognized. And the effect is not realized. The effect in question is the…
-
2
votes1
answer359
viewsQ: ajax auto complete by entering values in all inputs
To using an ajax request, to send a number to the server and return information relating to that number! In case I return two values, they are nome & funcao. So far so good! It’s working as it…
-
1
votes1
answer1770
viewsQ: Creating Basic app that opens a url
I already touched a little on these sites that offer "free app" and some of these sites have a good feature for me! They create an app that works with a specific url, as if the app was just a…
-
4
votes2
answers1422
viewsQ: Update the information on the page when making a change in the BD
Let’s say I have button value="+1" on my page, and every time I click on that button is updated in the database, the page refreshes and displayed a message of success or error. This update process…
-
3
votes4
answers535
viewsQ: Multiplying values within a for
I’m using the for to generate a loop of 4 repetitions! Inside this loop I do a simple numerical multiplication. <?php echo "Resultado: "; for($loop = 1; $loop <= 4; $loop += 1) { echo ($loop *…
-
-1
votes2
answers294
viewsQ: include is only inserted after the <body>, and would like it to be included earlier
I use a file called head.php to add meta tags to each page more easily! However include is only included after the body, when in fact I need you to stay before the body! Codebase:…
-
1
votes1
answer133
viewsQ: use COUNT and insert X DIV in X quantity
Assuming I have a database with X elements! At the time of the query I will use a count to see how many lines I have! I would like to divide this result and divide by any number, in which case I…
phpasked ivan veloso 2,900 -
1
votes1
answer180
viewsQ: Ideal "replacement" for the placeholder
I’m in the final phase of a project! And now I’m doing the analysis as performance tests and structuring errors! One of the errors found is the placeholder of inputs and textarea. What I can use in…
-
2
votes1
answer477
viewsQ: Implement form, causing the message to be sent directly to my email
I have a contact form on my website. It picks up information like name, email, phone and message. However, this data is displayed only in the administration panel of the site itself. I would like…
-
2
votes1
answer184
viewsQ: "clear" text written in input A and rewrite it in input B using jquery
I have a < input type="text" id="A" >, I would like that when typing any text in this input, it would be rewritten in input B, but before the text is rewritten, I would like it to be…
-
0
votes1
answer88
viewsQ: Ending any connection after "closing" the link
I’m using a small ajax code to open some links! Only sometimes these links have some videos!! And even that loads!! But the problem is that these links are opened in a lightbox! And when you close…
-
3
votes1
answer53
viewsQ: Reversing the jquery effect
I am learning Jquery. And I made the following code $(document).ready(function(){ $('html').click(function(){ $('.box').css("background-color", "#666"); $('.box').animate({"width":"400px"}, 1000);…
jqueryasked ivan veloso 2,900