Posts by Marcos Paulo • 649 points
56 posts
-
0
votes0
answers8
viewsQ: Group API Output via JSON
Is there any way to Group the returns of an API, accessed via Json cpReferencia = 1 cpDataMoldagem = 26/10/2020 | cpStatus = APROVADO cpDataMoldagem = 20/11/2020 | cpStatus = NEGADO…
-
1
votes1
answer21
viewsQ: Select a value depending on the chosen footage
I need to return the value of a product according to the chosen footage, this value is saved in a table this way de_mt | ate_mt | valor_mt -------------------------- 1 | 5 | 15.00 6 | 8 | 16.00 9 |…
-
0
votes0
answers40
viewsQ: Change one or more value of plots, and automatically recalculate the other fields
I changed the way I wanted, but now I’m having problems with actual formatting! Example link Follow the changed code <script src="https://code.jquery.com/jquery-1.11.3.js"></script>…
-
0
votes1
answer51
viewsQ: Group records, but show repeaters in a row
I have a table where I take all orders made on the day, but show all in a table, so far so good, but the customer needs to be grouped by those who asked, I will give an example, On my table I have…
phpasked Marcos Paulo 649 -
0
votes1
answer30
viewsQ: SQL grouping the same data, but showing the photos of the records
I have an SLQ that returns the amount of repeated records grouped together, However my need is to list all photos from duplicate records SELECT count(Longitude) AS registros, id_local,…
-
0
votes2
answers63
viewsQ: Return Mysql result as ranking
As I should do in this query, where I have a user register, and each user sends several photos to another table, each photo sent receives a score of 1 to 5 I need to bring the 10 with the highest…
-
0
votes1
answer131
viewsQ: file.width and file.height - Does not work in Dropzone.js
I am implemented the system of Dropzone.js in a system, however, I need to limit the size of the image. How I take this information to limit upload that is not within the standards?…
-
0
votes1
answer181
viewsQ: Add rows to a table with Jquery and add a new ID
I am using the solution I saw in this topic to insert new fields to a table Add Line However I need each inserted row to come with an ID, because I will have to take some data from the database and…
jqueryasked Marcos Paulo 649 -
0
votes1
answer154
viewsQ: Return Json Mysql array
I have two tables inside in a database, and I need you to return the data in an array Today I have only return from the table tbl_categorias_photos The return and so on. [ { "id_cat_fotos": "3",…
-
2
votes0
answers91
viewsQ: Return test in an API
I’m testing a way to get data from a database with a simple API, I don’t know if it’s right, if you can give me a hand I wanted it to work via POST, but the tests on POSTMAN only returns if I put…
-
0
votes1
answer18
viewsQ: Save filter to tablesorter
I have a system that returns registered clients with tablesorter, but when I edit a user and go back to screen, the filter performed to find a particular group of customers changes, there is some…
-
0
votes2
answers226
viewsQ: Group by date in a timestamp field
How I can group data from MYSQL by date, and in BD the field and Timestamp 2019-04-18 08:01:10 $sql = "SELECT * FROM tbl_reclamacoes GROUP BY data_reclamacoes ORDER BY data_reclamacoes ASC";…
-
1
votes2
answers344
viewsQ: Determine the amount of times a number can repeat in an array
I need to create a draw system where a certain number will be required to appear 3 times in an array. It has to have 9 random positions from 1 to 6 and only one number 1 can repeat 3 times, the…
phpasked Marcos Paulo 649 -
0
votes3
answers433
viewsQ: Take the JSON return and move to a PHP variable
I need to pass the return variable inside the alert and move on to PHP, but everything I’m trying from examples to here, even from the forum, is giving Javascript error: <?php $pegar_ip =…
-
2
votes1
answer30
viewsQ: Show HTML only from a div
I have a function that generates dynamic form, this form is loaded via a GET via Jquery and shows the form mounted on a div. I need to get only the source code of this DIV, someone knows a way to do…
-
1
votes0
answers27
viewsQ: PDO - Join in a function
I am inserting a new query in a functional system, however I am not able to understand how to insert a JOIN , I saw that there is the Function, I just can’t implant. I tried to run like this…
-
-1
votes1
answer49
viewsQ: Doubts in the functioning of a CRON task, No and how to SCHEDULE and yes the FUNCTIONING of it
I have a question about scheduling tasks in CRON and I would like more clarification on how it works. If I have a task to perform every minute, and this task for example takes longer than 1 minute,…
-
0
votes1
answer74
viewsQ: Separate return from a table to a Timeline
I am creating a Timeline where there may be more than one user update per day. I need my return sql to already compare the dates and I can separate $sql = "SELECT * FROM tb_timeline JOIN…
-
1
votes1
answer188
viewsQ: Get back in PHP JSON
It has a system that will send a return to me every day, however I am not able to receive the data to record in the bank, someone can give me a light? This is the data sent by the system -H…
-
0
votes0
answers38
viewsQ: Count the number of times a category is chosen by customers!
I have a table with categories, and each client who registers can choose up to 10 corresponding categories that corresponds to his work! These categories in the client table are saved the ID’s , I…
-
1
votes1
answer28
viewsQ: Return days of the year, removing those that are in a Variable
I need a PHP function that returns me every day of the year except those that were previously selected. Example My client selected ( 01/01,02/01,04/01,12/01,12/05,18/01,08/01,10/11,05/12,11/09,01/12…
-
1
votes1
answer534
viewsQ: Select Mysql with an array in a table
I have a table in the database called acting, in which generated the`s ID of the areas chosen by the user ex: 1,5,4,9,15 I need the result of the query in Mysql return me all users who have been…
-
0
votes1
answer224
viewsA: header Location NO php.ini
It’s amazing, I spent all morning searching and it was only posting here that I found the solution. It was only necessary to change the php.ini. Change the function output_buffering mark for ON…
phpanswered Marcos Paulo 649 -
0
votes1
answer224
viewsQ: header Location NO php.ini
A while ago I set up a VPS with Cpanel and I had this same problem, but I remember where it was changed but I don’t remember the line php.ini The problem is that I have a page that the user enters…
phpasked Marcos Paulo 649 -
1
votes1
answer199
viewsQ: Recover JSON data via POST
I have an Application that sends the strings via POST and recovers via JSON, but I am not able to separate the coordinates that arrive in an array. Follow an example $datas =…
-
0
votes1
answer462
viewsQ: pass variable javascript to php and write to database
I need to take the variables of Alert and go to PHP, and then record in the bank, the bank recording and quiet, what not getting and send to test page <script…
-
0
votes1
answer1462
viewsQ: JOIN with two queries in the same table
I need two different results coming in the same table with JOIS It works that way I have the PRODUCAO table and the BANCO table In the production table, I take the ID of the bank in the tebela bank…
-
1
votes1
answer136
viewsA: Does not download the XLS spreadsheet
Solved! I had to activate the output_buffering in PHP.INI Done that, problem solved!
-
2
votes1
answer136
viewsQ: Does not download the XLS spreadsheet
The system was in a resale and I had to migrate to a VPS with Cpanel, the script to generate the XLS was working fine, opened and performed the download , but now it just opens on screen What I need…
-
0
votes1
answer85
viewsQ: Recover Data from Json Return
I’m getting a return from a JSON URL, but I’m not able to recover the answers , I only get the first array and then there’s another array that I’m not able to recover Code $json_file =…
-
4
votes2
answers1634
viewsQ: Select records smaller than the current date and time
What is the best way to query the database where the data is smaller than the current date and time SELECT * FROM agenda WHERE agendamento < '".date('Y-m-d H:m:s')."'…
-
0
votes2
answers301
viewsQ: Consultation in bank with accentuation in the table
I know it’s kind of absurd, but unfortunately I came across a situation I don’t know how to get around The company has a system that records in Adobe ACCSSES and some tables theme accentuation and…
-
1
votes2
answers1874
viewsQ: Separate query by month and add the results
I have a database of requests that contain several requests for various dates, however I need to list a report by month and their respective sums in front. Example: The date field in the table is…
-
0
votes1
answer713
viewsQ: Remove only one value in the array
I have an array this way $arr = array('10', '12', '10', '15', '18', '18', '7', '18', '18', '15'); Four times the value 18. I need to remove from it only one value, example 18, and it remains so:…
-
3
votes1
answer46
viewsQ: Sort numbers on a Sept?
I have a table where users select multiple numbers and are recorded in a $_SESSION, I just need these numbers to appear in ascending order: Example of $_SESSION gravada =…
phpasked Marcos Paulo 649 -
4
votes4
answers1413
viewsQ: Know what day falls next Monday
I need a schedule for an agenda that gives me the date of next Monday from a certain date Ex: today and day 01/06 I need to know what day the next 10 Mondays will fall. 1 = 05/06/2017 2 = 12/06/2017…
-
0
votes1
answer114
viewsQ: Return value in UISLIDER input
I need to insert in a form a price range, I am using the noUiSlider with Jquery, it’s working, but I can’t get the chosen values, someone can give me a help? Example $("#slider-start").noUiSlider({…
jqueryasked Marcos Paulo 649 -
2
votes1
answer266
viewsQ: how to perform a SELECT COUNT faster!
I need to perform a query to know a total of operators I have. However the table has almost 18 million records, and it is taking a long time to return almost 3 minutes, and this is because I am…
-
1
votes2
answers1651
viewsQ: Select with JOIN
How do I limit this query to listing only one image record? I have the table of real estate and the table of photos, the table of real estate has several records, and each record has several photos,…
-
0
votes1
answer1302
viewsQ: Post Office AR and Sedex Checker Digit
Someone knows the formula to generate the order checker digit of the post office, I have already contacted them, but it is 3 working days to give an answer, and unfortunately I have to finish the…
-
2
votes1
answer400
viewsQ: Transform Array and String
How to transform an array similar to this and Strings to write each line in the Mysql database. I will only need the data of each array ( date, site and Status ) print_r($arrayOut); Array ( [1]…
-
0
votes1
answer1335
viewsQ: Size of a Mysql table with 200 million records
I am developing a system for a client, and I came across the following situation: he gave me a database, with phone numbers. And I have to create a routine, to generate new numbers for future…
mysqlasked Marcos Paulo 649 -
1
votes2
answers1774
viewsA: Read txt and generate a new with ; at the end of each line
Valew Junior, your answer gave me notion of how to work here, the system separates by ; it will not be necessary to break line, so I let him write one in front of the other, without problem, and it…
-
1
votes2
answers1774
viewsQ: Read txt and generate a new with ; at the end of each line
I created a system that imports the names generated in TXT, but the system interprets the ; at the end of each line and write to the bank, however my client’s commercial system, exports the data…
-
2
votes0
answers32
viewsQ: Help with Calback validationEngine
I’m using the validationEngine for a form validation and sending after all completed. So far so good. However I need to recover some data from the registration after confirmation. Once the user…
-
1
votes0
answers317
viewsQ: Problem when exporting data to Excel
I have a problem when exporting the data to Excel, the number fields of the residence and misinterpreted by EXCEL Example: if the client puts in the Number field of the residence 100 A, goes normal,…
-
1
votes1
answer132
viewsQ: Recover bigger facebook image by ID
I need to recover the image of the Facebook profile, I found a code, but the image comes small, someone knows some code where I can recover it may? I can not use the facebook API, because the ID’s,…
-
0
votes0
answers38
viewsQ: Generate two XLS Files
I need to generate two files with different names and data in a PHP page, but the code only generates the second, follows a short excerpt of the code: // Primeiro Arquivo for($i=0;$i<1;$i++){…
-
3
votes1
answer1355
viewsQ: Validate if person and legal age
Good afternoon staff, how to check if a person is of age with the plugin jQuery.validationEngine? I need the form only validates if the person is over 18 years old, if they are under 18 years old…
-
0
votes1
answer81
viewsA: Select and add records from a table with different fields
Thanks, guys, I got a more viable solution, and I don’t think I’m gonna weigh too much! I created a temporary table where it is recorded every time there is a change or insertion of a new game, so I…