Posts by Jorge Kania • 192 points
20 posts
-
0
votes0
answers17
viewsQ: error when url has more parameters
I’m doing a user-friendly url forwarding with page access verification per database, but I have a problem when the URL has more parameters on it, like if the URL looks like this www.site.com/a/b/c…
-
0
votes0
answers25
viewsQ: cron does not update database
I created a php file to check if there are any expired users or update their status with database update 1 time a day. I’m scheduling the cron for the hostgator’s CPANEL. If I run the file in the…
-
1
votes1
answer39
viewsQ: Create array from another json array in php
Guys, I have the following array coming from a url that I’m picking up via file_get_contents $urlHistorical = 'https://mfinance.com.br/api/v1/stocks/historicals/IBOV?months=3'; $dadosHistorical =…
-
0
votes0
answers27
viewsQ: File . htaccess and php route
I’m having trouble creating a route on my localhost that will be later placed on the www server, it always redirects to the 404 even the existing folder, follow settings that esotu using file .…
-
0
votes0
answers10
viewsQ: apexcharts does not plot the information
Someone, I have a strange error here with Apexcharts + PHP and Javascritp, although the console show that the information is coming right he does not plot, I have looked at the documentation and do…
-
0
votes2
answers29
viewsA: Icone does not appear as desired using Fontawesome
More is going, see the example with the link. See if your variable is printing the correct link <link href='https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.css' rel='stylesheet'…
-
0
votes2
answers29
viewsA: Icone does not appear as desired using Fontawesome
I didn’t understand your doubt, a little more specific power? see this example of the button being left or right only using the float-right and float-left class <link…
-
0
votes0
answers113
viewsQ: Suggestion for Login with Access Levels php mysql
I need a hint as to how you would implement a login system via php and mysql with access levels, example: I have a database Mysql with is registered users, this in turn has several different access…
-
0
votes0
answers16
viewsQ: Undefined index error
Can anyone see where the error is in this shipment? I can not understand why report that does not find the field, including the console shows that the information is being recovered in JQUERY/AJAX…
-
0
votes0
answers21
viewsQ: Roll div to a point and stop
I’m trying to do something that should be simple but I’m not getting it. I want to take a div that has a form and make it roll with the page to a certain point on the page, let’s say the middle of…
-
0
votes1
answer27
viewsQ: Send ajax requests one by one
I’m sending an email to a list of say 100 people, process this sending via Ajax, the normal is the ajax send to a page and in Success or error of it, it gives me the return what occurred, until then…
-
-3
votes1
answer58
viewsQ: How to recreate a PHP session without loaning the user
It is possible to recreate a $_SESSION in PHP without dislocating the user? I have a restricted area where he can update some of his information in the database. The problem is that when he logs in…
-
0
votes2
answers85
viewsA: Select to create balance based on previous month’s value
thank you for your reply. I ran your query in my database to test, see how it returned Only adjustments to the names of my columns and gave a GORUP BY to bring the sum of each month set @csum := 0;…
-
0
votes2
answers85
viewsQ: Select to create balance based on previous month’s value
I have the following situation. I have a Mysql database where one of the columns (liquido_dia) brings the daily value generated (positive or negative), I’m already mounting a demonstrative per month…
-
0
votes3
answers1548
viewsA: select text field separated by comma return lines
I managed to solve using : UNNEST(ARRAY[string_to_array(campo_pesquizar, ',')])::INT
postgresqlanswered Jorge Kania 192 -
1
votes3
answers1548
viewsQ: select text field separated by comma return lines
Does anyone know how it is possible in postgresql take a value within a field of type TEXT which has comma-separated records to use in the WHERE? Example of field values…
postgresqlasked Jorge Kania 192 -
0
votes1
answer240
viewsA: Postgres Decode and convert_from error
Situation resolved. I converted the field to TEXT type and solved it.
postgresqlanswered Jorge Kania 192 -
6
votes1
answer240
viewsQ: Postgres Decode and convert_from error
Has anyone been through the Postgres issue to error the Code Base64? I have the following call that informs [Err] ERROR: end of sequence is invalid convert_from(decode('YnJhc2lsc2VtbGVp', 'base64'),…
postgresqlasked Jorge Kania 192 -
0
votes1
answer1473
viewsQ: Single column calculation in Postgresql
How to make a calculation (example: subtraction) of summed values of the same column in Postgresql? Example of query: DROP TABLE if exists saldo; CREATE TEMPORARY TABLE saldo AS select a.usuario…
postgresqlasked Jorge Kania 192 -
6
votes1
answer106
viewsQ: Grab link posted on Facebook
Does anyone know how to get the link that was posted on Facebook via callback? I want to know which link was generated when the user made the sharing, so I can validate and even see if he actually…
facebookasked Jorge Kania 192