Posts by Fabio Henrique • 2,156 points
146 posts
-
3
votes1
answer2359
viewsQ: Perform direct calculations in the sql query
How could you perform a series of calculations directly in the sql query, as there is SUM() that performs the sum would have some way to add one column to another and decrease another? $sql02 =…
-
1
votes2
answers1000
viewsQ: How to Catch Results inside the loop and grouping into a variable outside it
How to Catch Results inside the loop and grouping into a variable outside it Example: $sql55 = "SELECT * FROM finan WHERE MONTH(data_fechamento)= '02' "; $resultado55 = mysql_query($sql55) or die(…
phpasked Fabio Henrique 2,156 -
2
votes4
answers978
viewsQ: Loop autoincrementing date
How can I make a auto increment date per month and showing the last day of the month Example: 2017-01-31 2017-02-28 2017-03-31 $parcelas = 12; $data_inicial = 2017-01-31 for ($i = 1; $i <=…
phpasked Fabio Henrique 2,156 -
0
votes2
answers120
viewsQ: Error Showing Next Month
In this script below it returns me the next month of a specific date and the error only happens on 31/01/2017 and 28/02/2017 echo $mes = date('m', strtotime('+1 months',…
phpasked Fabio Henrique 2,156 -
1
votes2
answers158
viewsQ: Mysql update filtering by due date with tolerance of x Days
I need to update only records that are expired and add a tolerance of x days Example Tolerance of 5 days Today is = 11/10/2016 id= 1 maturity = 10/10/2016 // only update if today was day 15 id= 2…
-
0
votes1
answer207
viewsQ: Generate Table with PHP Group Index
How can I make a Table that shows me a Line at the beginning of each Group in a table To understand me better I’m putting down an image of how I need Current Table Table With Index <table…
-
4
votes1
answer42
viewsQ: WEB Systems What is the best way to escape from Searchers and make it invisible
When it comes to WEB systems What would be the safest and most used way for it to become invisible to search engines? I know there are the "Goals" but I think there should be more reliable way…
-
2
votes1
answer119
viewsQ: Online Calculator Applying Fine and Discount
In my code below it adds a sum between fields per line. What I don’t know how to do, is when clicking on a checkbox he carries out the discount in percentage and in the other checkbox sum a fine in…
-
0
votes1
answer31
viewsQ: Update of Random Divs
In this my Script below it is doing an update of a Divs pulling a file tv2.php of so much and I try time... until then it works, the more I need it Intercale between two files. Example 1 and 1…
-
0
votes0
answers1121
viewsQ: Auto Complete Addresses with Google Api
As I have no knowledge of javascript I need a little help.... What I need is to do an address autocomplete in several fields by a google Api how could I do this? This example below is what I needed,…
-
-1
votes1
answer64
viewsQ: Time Comparison in Approach
How can I make a script for if current time is approaching the scheduled time to do something Exemplo date_default_timezone_set('America/Sao_Paulo'); $hora_atual = date('H:i'); //11:45 Hora Atual…
phpasked Fabio Henrique 2,156 -
0
votes2
answers72
viewsQ: Show Div if note is less than 8
How to make a script, that if some of these 3 dropdowns down is less than 8 display a div <select name="pes21" id="privileges1" class="" onclick="craateUserJsObject.ShowPrivileges();">…
javascriptasked Fabio Henrique 2,156 -
0
votes1
answer636
viewsQ: Script to disable and enable compos with "READONLY" from a Checkbox
I need a script that enables and disables a field with READONLY from a checkbox I don’t know how to program in javascript, How do this script <input readonly="" type="text" name="xx" value=""…
javascriptasked Fabio Henrique 2,156 -
1
votes1
answer487
viewsA: Send a value to modal
ola use in this way Table link <a href="#" id="botfun" data-id="<?echo $id_funcionario?>" title="Editar">Fulanp</span></a> Modal <script>…
-
0
votes1
answer125
viewsA: Shipping to the Insurance Company
Download the Pagseguro Library and point your action from your form to this script I posted below, put your key, and seven variables as you like. I just tested with your form and ran perfectly…
phpanswered Fabio Henrique 2,156 -
1
votes1
answer35
viewsQ: How to align 2 while result per line
How can I make the Divs contained in the loop list 2 per line instead of listing one at the bottom of the other Lowlife $sql = "SELECT * FROM aparelhos "; $resultado = mysql_query($sql) or die(…
-
0
votes1
answer1688
viewsQ: Capture GET Coordinates in the Google Maps api
In this script I just need javascript to get the coordinates //Algo parecido.... $lato = $_GET['lato']; $longo = $_GET['longo']; $lato = $_GET['latd']; $longd = $_GET['longd']; <script> var…
-
21
votes3
answers2168
viewsQ: How to Make Icone Ride in the Google Maps api
In this My script below it every 30 seconds causes the icone to change position, only the icone disappears and appears at the next point. What I wanted was for him to walk up to the next point as…
-
1
votes1
answer73
viewsQ: Display div according to note
This script works as follows: if one of the 3 dropdowns have note less than 8, it will show the content of a div occult. It works as follows: first dropdown has a note <= 8 // Shows the div 2nd…
jqueryasked Fabio Henrique 2,156 -
1
votes3
answers63
viewsQ: Perform separation on a Data Line and mount an array
I receive from a GPS a data line as in the first example below, and I have to treat it separating by comma in the same way as the second example: Example Original Data…
phpasked Fabio Henrique 2,156 -
1
votes1
answer1360
viewsQ: Insert Multiple Routes into the Google Maps Maps Api
how can I be putting multiple routes in my code same in the image below Data of horigem and destination already arrive in this variable var destino = gps.attr("destino"); var from_to =…
-
0
votes1
answer583
viewsQ: How to run a php socket
This script below is a php socket to receive data from a tk102 vehicular tracker. The problem is that I think it has to run in a specific folder on the server and I don’t know how to do it, and…
-
-3
votes2
answers30
viewsQ: Divergence between manual populated A Array and variable data
I’m not sure how to treat this, if I put the data in the array manually the array will be correct if I put the same data coming from a variable the array already wrong. how can I make the variable…
phpasked Fabio Henrique 2,156 -
0
votes0
answers31
viewsQ: FUNCTION database.column does not exist
In this select this gives this error (FUNCTION base.coordinates does not exist) $sql ="select AsText(coordenadas) from cerca_gps where coordenadas( GeomFromText('POLYGON((-22.970981 -43.217496…
phpasked Fabio Henrique 2,156 -
5
votes1
answer1838
viewsQ: Compare Coordinates
In my mysql I have a column containing positioning coordinates coming from a polygon, drawn in the google maps api, the question is how can I compare the coordinates I have within the column with…
-
1
votes0
answers46
viewsQ: Error Deploying Label in Google Maps Api
Hello guys I don’t have much knowledge of java script and need a help, how to deploy a code in the google maps api to create a label at each point. Below I’m putting my code and if anyone can help…
-
2
votes1
answer141
viewsQ: Check/Uncheck all checkboxes except disabled checkboxes
In this script below it marks and unchecks all checkbox but I wish that when a checkbox is "checked" and "disabled" it doesn’t change anything. The problem is that I don’t know how to do it, someone…
javascriptasked Fabio Henrique 2,156 -
0
votes1
answer1189
viewsQ: How to Switch Input Select according to Radio Button
How can I make a Radio Button display an Input select for it Radio x ---> mostrar Select x Radio y ---> mostrar Select y <input type="radio" name="x" /> <input type="radio" name="y"…
javascriptasked Fabio Henrique 2,156 -
1
votes1
answer1367
viewsQ: How to group and list repeated values in array?
As shown below, in the database comes a list of purchased chairs, linked to their respective tables. How can I list grouping the tables? [M] Significa => Mesa [c] Significa Cadeiras $id2 =…
phpasked Fabio Henrique 2,156 -
0
votes3
answers890
viewsQ: Mysql update of Empty columns only
Is there any way to do an Update in mysql where only let update the data if the column is empty. Imagine 4 radio input (the radios will be 1 at a time is not) Ai if a user(x) chooses radio 1 and…
-
3
votes3
answers1372
viewsQ: How to not allow repeated INSERT by giving Reload on the page?
How can I not allow INSERT repeated if someone re-loads the page? Example: $libera = $_POST['libera']; if ($libera == "sim"){ $sql = mysql_query ("INSERT INTO…
-
0
votes7
answers1134
viewsA: Select a file by name in PHP
Eduardo You can also do this way $arquivo = "20160111_ALGUMA_COISA"; $arquivo = explode("_", $arquivo); $arq1 = trim($arquivo[0]); // 1º $arq2 = trim($arquivo[1]); // 2º echo $arq1.'<br>';…
-
1
votes1
answer242
viewsQ: Nan Error in Calculation using Javascript after click Submit
I have a problem here that I can not solve , in this script below performs a calculation of on the marked seats, so far everything is perfect the problem and when I put a Ubmit button to send the…
-
2
votes1
answer153
viewsQ: Pass Javascript Output to a field
In this my script below is not passing the results to the fields at all someone would have a light on how I can solve this $(window).load(function(){ var contador = function() { var n =…
javascriptasked Fabio Henrique 2,156 -
0
votes1
answer151
viewsQ: Insert mysql with Ajax inside While
I’m trying to make a dynamical Insert using ajax. as shown in the image below. I want to be able to click send from any line and do the post referring to it How can I do that <script…
-
3
votes1
answer510
viewsQ: How to create fields dynamically when selecting a value in the checkbox?
In this script below it counts checkbox marked. How can I make it besides count, also add new fields <input type="text"> according to the quantity of checkbox marked For example: I marked 5…
-
1
votes1
answer36
viewsQ: Checkbox enabled count
That code counts how many checkbox were marked. How can I make sure he doesn’t count checkbox disabled <script type='text/javascript'>//<![CDATA[ window.onload=function(){ var contador =…
javascriptasked Fabio Henrique 2,156 -
-1
votes1
answer122
viewsQ: How to serialize a checkbox form
In this script he calculates the total values of the checkbox marked, which adaptation would be necessary in addition to the sum he also show the attributes name and value of their checked…
javascriptasked Fabio Henrique 2,156 -
4
votes2
answers706
viewsQ: How to toggle images when clicking a checkbox?
In this my script I’m making a seat marker, but I’m not getting to change the images after the click in the checkbox, and every time the table chairs get misaligned. Type: checkbox marked shows the…
-
5
votes1
answer5204
viewsQ: How to create a Radio button with image?
How can I make a Radio Button turn into an Image? I need to make an image gallery inside a form to, when clicking on the image would be selecting a radio button as in the image below:…
-
1
votes1
answer109
viewsQ: Error Generating PDF with Phpmailer
I am using Phpmailer to perform email sending more I would like to know why when I try to create a PDF attachment the file does not open right, With the upload everything is normal, up to the pdf…
-
1
votes1
answer66
viewsQ: Expandable Table With Reversal of Exposure
In this script below https://jsfiddle.net/gxr47dqr/ I have a table that expands when we click on the line. How can I make it expand once. Example: clico na primeira linha "**expande**" se clico em…
javascriptasked Fabio Henrique 2,156 -
0
votes1
answer193
viewsQ: Delete a specific ID inserted as serialize in a column in Mysql
In my db I have a column called Range_ids, I do an ID insertion using the function serialize. These Ids look like an array, the problem is how I can make one DELETE of the specific ID within the…
-
4
votes3
answers463
viewsQ: Add Array from multiple fields
I have a form with several fields containing values in currency as I can add all these values in the post output Example form <form id="form2" name="form2"…
phpasked Fabio Henrique 2,156 -
2
votes3
answers1016
viewsQ: Read Array out of foreach
In this script below I read an array inside the foreach, more how can I read it out? when I give an echo it only returns me 1 id $data = unserialize ($linha["range_ids"]); //…
phpasked Fabio Henrique 2,156 -
3
votes3
answers2040
viewsA: Check if a record was deleted when running DELETE query
Try So $Success = mysql_affected_rows(); if( isset($_POST['delemail']) ){ // Se existir o post prossiga... $emailDel = $_POST['delemail']; $dbc = mysqli_connect('localhost', 'xavier', 'xavier',…
-
1
votes1
answer42
viewsQ: Query mysql according to Array unserialize
In this select the bottom how can I make it only return the lines with the ids that are in this variable ( $range ) this variable is returning data from several ids database // estou utlizando a…
-
1
votes2
answers668
viewsQ: Update sql Sem Reload with a click on Link
I would like that in this script below when clicking on the link it did the update in sql without Reload. it was made to perform through a Ubmit in a more would like it to be through a link even…
-
0
votes2
answers688
viewsQ: Expandable Table how to do Double select?
In this script a have an expandable table showing by GROUP by nome , that when we click on the line, it will expand, showing a second table listing all the lines referring to the GROUP by nome.…
-
3
votes1
answer716
viewsQ: Expandable Table
In this script below https://jsfiddle.net/gatkzgtw/4/ I have a table that expands when we click on the line. when expanding it shows me a second table. the problem is that the script is repeating…
javascriptasked Fabio Henrique 2,156