Posts by CristianeBaill • 227 points
13 posts
-
1
votes1
answer1385
viewsQ: Authenticate a Json API with PHP
I need to do a user authentication in a JSON format API, I have all the documentation of this API. After authenticating I can make the queries I need. Developer says I precious this to authenticate.…
-
0
votes2
answers3562
viewsA: How to connect to Xampp Mysql from another server with Linux installed?
To resolve the issue in the Xampp v3.2.2 version you should go to the C: xampp apache conf extra folder to find and edit the file. httpd-xampp.conf locate the text where this structure <Directory…
-
1
votes2
answers3562
viewsQ: How to connect to Xampp Mysql from another server with Linux installed?
Hello I have a test server known as Xampp in it I have an active database in mysql, only I also have another server with apache running on another machine, and it is in this machine that I want to…
-
1
votes2
answers188
viewsQ: How to remove accent text in php?
I have the following situation, the text below it has the following words ATENÇÃO: and será that in turn they are accented, they should be removed from the text but due to accents I cannot remove.…
phpasked CristianeBaill 227 -
3
votes1
answer780
viewsQ: Mysql complex banking type statement how to solve
I have a VIEW table that I need to extract an extract from it, already managed with help right here from the stackoverflow progress to an extract. The problem is that now I need to filter this…
-
2
votes1
answer493
viewsA: How to modify a daily statement for a monthly statement?
I was able to get to the result but I had to create a VIEW. I used a @Maniero tip and it all worked out. I smell a whirlwind, but it worked. Follows the link demo SQL Fiddle. SELECT…
mysqlanswered CristianeBaill 227 -
0
votes1
answer493
viewsQ: How to modify a daily statement for a monthly statement?
I have a table that is not in the normal forms of database, but it has old data that I need to get. I managed to get you to present me the daily statement, but now I need to modify to generate the…
mysqlasked CristianeBaill 227 -
1
votes2
answers2263
viewsA: How to generate an extract per month in the database?
I got the result wait, my table is not in the normal forms, but it would be very expensive to have to reprogram. follows the expected result link. SQL Fiddle SELECT dia, mes, ano, credito, debito,…
-
2
votes2
answers2263
viewsQ: How to generate an extract per month in the database?
I have to generate a statement in the database that is similar to the bank statement and present the cumulative balance. I have the following columns Data, Debito, Crédito. Data entry is daily but…
-
0
votes1
answer556
viewsQ: How to sort by date when day, month and year are each in a column?
Hello, I am with the following situation, I have to sort a table by date, but for some particular reason the programmer decided to save the day, month and year in separate columns, Obs the database…
-
0
votes3
answers591
viewsA: SQL sorting only after the third character
All I’ve done is make the substring combined with order by as in the example below. SELECT * FROM cadastro WHERE 1 order by SUBSTRING(nome,5) This way he orders after the 5th character.…
-
5
votes3
answers591
viewsQ: SQL sorting only after the third character
I have a field in my table in Mysql that is string type, with the following data: Coluna 01DV 03DV 04DV If you enter the value 02CA the field lays like this Coluna 01DV 02CA 03DV 04DV I need him to…
-
2
votes1
answer1004
viewsQ: Changing td color without updating the page with ajax
How to solve this problem, I saw that there are solutions in ajax but I couldn’t develop, what I need is to change the color of td of a table without having to refresh the page, change the color of…