Posts by Leo Nogueira • 171 points
12 posts
-
0
votes2
answers1946
viewsA: Datatables problems using PHP and Mysql
To display the return data of the columns I usually use in the format: { 'targets': indicedacoluna, "data": function ( data, type, row ) { return data['nomedocampo']; } } in your case I think I’d…
-
0
votes2
answers31
viewsA: Search and display results in select
Already tried using Select2? I use a lot and do exactly what you want. SELECT2
-
2
votes1
answer572
viewsA: Create id field with Datatable Jquery Checkbox
You can in the row that creates the column that contains the checkbox, use a function. For example: "columns": [ { "data": function ( data, type, row ) { return "<input type='checkbox'…
-
4
votes1
answer55
viewsA: What’s wrong with this code?
You are making the difference of dates directly, as if they were numbers, and this is not correct. Make sure that both variables containing date are in the same format. Then use the Datetime(date)…
phpanswered Leo Nogueira 171 -
0
votes2
answers821
viewsA: Hide table <td> in some mobile resolutions
You can do this only with CSS. Set a maximum width resolution and within the items you want to search for. For example hiding a column with a maximum screen width of 450px. @media only screen and…
-
0
votes1
answer36
viewsA: Expected out of order display
I think your problem is just the asynchronous request, which is the default for browsers. Explanation If you change the third entry of the next line of code to FALSE, I believe you will get the…
-
3
votes3
answers229
viewsA: Function within Jquery what is the execution order?
Because the execution of ajax codes by default is asynchronous, ie jquery will not wait for the end of the execution of its routine to save the data in the database before giving the console.log of…
-
1
votes3
answers90
viewsA: How to do more than one select in the same query in different BD tables?
I did not test, but I believe that you can solve everything with JOINS and not subselects. If obligatory in table connectors, always be registered an id of each table I think will work. Try SELECT…
-
2
votes5
answers7965
viewsA: Some way to get the price of the dollar
Here is another example for using the BACEN web service. Simply instantiate the BACEN class and use the getUltimoValorXML function for the last quotation or getValue for quotation on a specific…
-
1
votes1
answer120
viewsA: SELECT Mysql with wrong result
Problem solved. Updated Mysql version to 5.6.19 (was 5.5.?). Problem with Partified table and multiple indexes. More information here link Thanks to those who tried to help.…
-
-1
votes3
answers436
viewsA: Event Routine - PHP
If your routine is in PHP or Linux shell, you can include a Cronjob on the server to run at the desired time.
-
-2
votes1
answer120
viewsQ: SELECT Mysql with wrong result
Let’s take the table below as an example: id empresa forneedor 1 10 105 2 10 102 3 10 105 4 10 112 5 10 105 Using company and supplier as indexes. Making SELECT * FROM table WHERE empresa = 10;…