Posts by Fernando VR • 941 points
48 posts
- 
		2 votes2 answers2541 viewsA: How to make a select inside another select in mysqlI wonder if it’ll solve what you need? SELECT p.pro_name, p.id, f.image as foto, Max(f.ordering) AS orderingmax FROM osrs_properties p LEFT JOIN osrs_photos as f ON f.pro_id = p.id GROUP BY… 
- 
		3 votes2 answers164 viewsA: How to conditional disable a link with bind href in Vue.js?You can use conditions within the bind. Ex: (condition ? if : Else) In your case it would look like this: <a v-bind:href="(opts.level >= 2 ? 'http://meusite.com.br/' + opts.cod : '#')">… 
- 
		1 votes1 answer116 viewsA: How to update two tables in an alternative way that does not return "safe update mode" in Mysql?I do not know if it will be good for you and if I understood right what you want to do, but an alternative that I like very much to use is the functions of Mysql itself. You can create one for… mysqlanswered Fernando VR 941
- 
		0 votes1 answer50 viewsQ: Is it possible to simplify the Runnable command on an Android function?I have created a class to facilitate the use of Dialogs, and I would like to know if it is possible to simplify further. My class is like this: public class FVRDialog { private Activity act; private… 
- 
		0 votes1 answer682 viewsA: How to do error handling for outdated Google Play Services avoiding application crash on android?I managed to solve the problem as follows: I found an outdated code on the net, after hours searching, and updating to the new method was like this inside a function I created: public Boolean… 
- 
		0 votes1 answer682 viewsQ: How to do error handling for outdated Google Play Services avoiding application crash on android?I’m creating an app that uses Firebase, and which in turn uses the Google Play Services. In my tests, when the Google Play Services is outdated, it crashes the application and gives an error saying… 
- 
		0 votes0 answers36 viewsQ: Do I have any risk in using parentActivity in the manifest of my android app?I have an Activity with a text about terms of use. It can be called through a menu and opened directly. So for this reason I have put in the manifest this Activity in parentActivityName so that when… 
- 
		0 votes2 answers145 viewsQ: How to run request again after having permission accepted on android?I have a button that when pressed it should open the telephone call mode with a dynamic number. This method requires permission CALL_PHONE. And when pressed the first time, it opens a dialog asking… 
- 
		0 votes1 answer127 viewsQ: How to fix a Bug with loading a Fragment within another Fragment?I have a Mainactivity with Navigation Drawer, and all the items in this browser opens in Fragments. When starting the application I load the home page as follows:… 
- 
		0 votes1 answer682 viewsA: How to put back icon on a Toolbar inside a Fragment that hides the main Toolbar?I ended up getting it sorted out. maybe in a gambit. I added an Imagebutton with an arrow to go back. <android.support.v7.widget.Toolbar android:id="@+id/toolbar_custom"… 
- 
		0 votes1 answer682 viewsQ: How to put back icon on a Toolbar inside a Fragment that hides the main Toolbar?I’m having a problem putting the back icon on a Toolbar inside a Fragment that is hiding the main Toolbar. I use android studio, and created a Navigation Drawer Activity, where I work with Fragments… 
- 
		0 votes2 answers297 viewsQ: Can I have performance problems joining multiple classes to a single file?Watching many tutorials and video lessons, I always see that a java file is created for each action/class. As I indicate in the image below with arrow number 1 yellow. But as my app is getting huge,… 
- 
		0 votes3 answers385 viewsA: The same variable repeats several times in the whileYour mysqli_fetch_array is repeated and misplaced in while. See comment on your code line below: ...$rsProjeto= mysqli_query($mysqli, $sqlProjetos) or die (mysqli_error($mysqli));… 
- 
		0 votes1 answer153 viewsA: Collecting Facebook Data with a Boot ShareYou can only get these types of data if users allow this data to be released. To do this you need to create a APP on facebook by the link: https://developers.facebook.com/apps/ and then create a… 
- 
		3 votes4 answers1768 viewsA: How to generate a serial key that contains a prefix in the first 5 characters?I don’t know if I got this right, but your serial prefix, is it a fixed text that you’re going to choose for yourself? If it is you can make a very simple change to your code, which is to take all… phpanswered Fernando VR 941
- 
		0 votes2 answers365 viewsA: filter_input GETIt seems that is giving problem in Mysql Insert, all fields are string even? If they try to give a filter for each GET, maybe for sure. Now if any field is integer, you need to pass the data as… 
- 
		1 votes1 answer716 viewsA: How to switch between 2 style sheets?You can use the jquery command .attr("href") with the command .on("click") on the button, to change your css link. See an example I made below, where I created two links one to change my theme from… 
- 
		2 votes2 answers384 viewsA: How to create a regular expressionIt’s a bit complicated to get the City and State in this html. I did a test here and managed using the following Regular Expression:… 
- 
		1 votes1 answer529 viewsA: encrypt filesAccording to your answer for wanting to stream encrypted video in the same way as Netflix, I believe that your need is not possible to do by PHP encryption. Netflix, iTunes, Amazon Prime Videos,… 
- 
		6 votes2 answers30215 viewsA: how does auto increment work in mysql?If you don’t have the field yet you can use the command ADD COLUMN ALTER TABLE `Sua_tabela` ADD COLUMN `id` int(11) NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`); If the field already exists, you… 
- 
		0 votes2 answers943 viewsA: Hover with border and CSS imageHide the item that contains the class saiba_mais thus: .saiba_mais { display: none; } And to appear, you can grab any mouse area that is inside the item that contains your class linha thus:… 
- 
		0 votes2 answers38 viewsA: Can anyone help me figure out why the dropdown menu is not working?Any mistake however simple can compromise the whole code. In your case you got the word wrong data-toggle that in your code is data-toogle. It’s just a letter the and two letters g in toggle. See… 
- 
		0 votes1 answer593 viewsA: Notice: Undefined variable: connectionWhen you must have confused the connection variable. You are using this on line 17 and 18 of your header.php: $conectar=new DB; $conectar=$conectar->conectar(); And so in the line of error:… 
- 
		1 votes2 answers2210 viewsA: How to open a page according to the link inserted in the input?You can use javascript with window.open or window.location to do as you wish. Example with window.open(): It will open the url in a new window. window.open('http://www.google.com'); Example with… 
- 
		1 votes2 answers85 viewsA: Quantify new line ( n) in regexI’m not sure I understand. Would you like to take the first 54 lines of a text? Would that be what you’re trying to do? (.*\n){54} If not, more details showing what you have on the screen, and what… regexanswered Fernando VR 941
- 
		1 votes3 answers1242 viewsA: PHP-Loop repetition table using multidimensional arrayYou don’t need to start an empty array in this case when vc starts an array using square brackets, PHP already understands that it is an array, so you can ignore the line $teste = array();. You can… 
- 
		1 votes2 answers2803 viewsA: What is the most appropriate content to put in the header or Nav?Are you wearing any framework?? guy boostrap or some other? If you have, you have to check their documentation, because every framework follows a hyena along with CSS If you don’t follow it may get… html5answered Fernando VR 941
- 
		1 votes2 answers979 viewsA: How to replace string values from all array values?I think you could use a multidimensional array to solve this case, but if you can’t, maybe a tbm array_combine would work: $valor = array('1', '2', '3', '4', '5'); $nome = array('valor1', 'valor2',… 
- 
		0 votes1 answer601 viewsA: How to map an image using Google Areas and Coordinates.Cloud.Vision.ApiHas q see if these coordinates are for two areas of the rect type to form two squares, or if they are for a single area in a polygon. If it is a polygon by the coordinates that is there, there will… 
- 
		1 votes2 answers714 viewsA: Can you create a menu from an image?There is, and you don’t even have to create an image for that. Using Fontawesome vc has hundreds of icones q vc can use in the applications, and with boostrap vc has médodos to make the menu without… 
- 
		5 votes1 answer1417 viewsA: Query mysql to take two-line data and merge into oneI think what you’re looking for is group_concat. You can make a select of the fields you want to display, with a group_concat in the field you want to join, and grouping by the fields that are… mysqlanswered Fernando VR 941
- 
		5 votes2 answers1514 viewsA: How to continue executing a script even after sending the data to the browser?Based on Anderson’s answer, it didn’t work out that way Wallace? <?php ignore_user_abort(true); set_time_limit(0); gravar_dados_no_banco(); ob_start(); // Envia a resposta pro navegador // Porém… 
- 
		0 votes1 answer23 viewsA: A logic in phpMake a select before opening the posting field to check how many posts it has already made. If you want q be 5 posts per day, make a date field in the database, to count how many posts were made on… 
- 
		2 votes1 answer253 viewsA: dropdown-menu does not work BootstrapI didn’t test it here, but if you put the float in .menu_2 not right?? .menu_2{ padding: 10px; font-size: 10pt; margin-top: 23px; color: #6495ED; float: left; } And you’ve tried using Boostrap??… 
- 
		2 votes3 answers529 viewsA: Login with validation systemYou have problem in the first if / Else, where you try to find the type of active variable before making the SQL query, the line below is wrong: (`ativo` = 1) It is not a variable and tbm does not… 
- 
		0 votes1 answer36 viewsA: Conditions on dates in MYSQL know which last record and penultimateYou could not run a single query to return the two values you want, instead of having q make two queries and all these calculations?? Something like that wouldn’t solve your problem: SELECT * FROM… mysqlanswered Fernando VR 941
- 
		1 votes3 answers206 viewsA: Countdown - include monthUsing jquery ready script for counters does not help?? Take a look at this one: http://keith-wood.name/countdown.html You can call him that: $('#byMonth').countdown({until: longWayOff, format:… javascriptanswered Fernando VR 941
- 
		1 votes2 answers1526 viewsA: Place item side by side with border round CSSYou can use float: left; in the CSS where you want to put side by side: Sort of like this: .user{ margin-right: 30px; font-size: 13pt; border-radius: 1px solid ; float: left; } and Border Radius to… 
- 
		0 votes2 answers80 viewsA: Load code according to deviceWith Jquery you can capture the size of the viewport with the code: $( window ).width(); and $( window ).height(); It is still not very clear what you want to do, but I believe if you use this form… 
- 
		0 votes1 answer262 viewsA: Handling glyphicon BootstrapI think the ideal is you create a css to fix this, because I think the boostrap itself does not have this correction that you seek. Try something like this for your CSS: .vertical-align { display:… 
- 
		1 votes1 answer92 viewsA: Configure log of errorsIt seems to be having a limit of characters there, and so does not display the complete path of the directory for being a very long way. I know q there is a character limit setting for the errors… 
- 
		0 votes1 answer95 viewsA: Variable value does not updateI think it may be Cache problem, I’ve heard about it in apache and php, I’m not sure if it will work, but try to configure the following: 1) Google Pagespeed Module is enabled on these lines in… 
- 
		1 votes4 answers151 viewsA: How to build a class correctly with access methods?I don’t know if it’s what you want, but the function can’t have multiple returns, so you can use arrays. more or less like this: function getProduto(){ return array('variavelcpu' =>… 
- 
		0 votes2 answers1376 viewsA: How to make a Login and Password system secure for Mobile Apps?Well, after doing a lot of research, I had an idea, but I haven’t developed it yet, but I think it might actually work. My problem would be for a hacker to decompile the application with root access… 
- 
		0 votes2 answers1376 viewsQ: How to make a Login and Password system secure for Mobile Apps?I created a security system in php with mysql for my website, but through the browser on desktop computers, the session is stored in cookies, and it is easy to know which user is logged in and what… 
- 
		3 votes1 answer2285 viewsQ: What is the best method to create forms in Adroid?I am creating a registration form, to add and edit SQL records. I found a place that indicated to do through ScrollView, so that the form has a scrolling, and in my case it would be really… 
- 
		3 votes5 answers2275 viewsA: How to reduce the search time in a table with more than 200,000 records?After many hours of testing, and without more time to continue on the same problem, I solved the situation by modifying the table, the query and what will be returned on the screen by PHP. Before in… 
- 
		4 votes5 answers2275 viewsQ: How to reduce the search time in a table with more than 200,000 records?I’m trying problems to list and search data table with more than 200 thousand records. I read in researches, that for the search system, the ideal would be to make indexes of type "fulltext" in the…