Posts by Daniel Castro • 36 points
7 posts
-
0
votes1
answer74
viewsA: Access a site from a server that is on the same LAN (XAMPP)
@Milk There must be something ServerName localhost:80 in httpd.conf, what value do you have? If it is localhost, switches to be the server IP, e.g. ServerName 192.168.10.10:80…
-
0
votes1
answer74
viewsQ: Access a site from a server that is on the same LAN (XAMPP)
Hello to all! I have two computers: Windows 7; Windows Server 2012. My site is in the xampp of windows server 2012, and I want to access it through windows 7. I have tried searching the browser for…
-
1
votes1
answer830
viewsA: How to make SQL query using like comparator and various values out of order
Syntax of 'like' in SQL: SELECT (campos) FROM (tabelas) WHERE campo1 LIKE "%variavel%"; In the context you want to use it would look more or less like this: $comando = "SELECT * FROM user WHERE nome…
-
0
votes1
answer126
viewsA: Onetomany or Manytoone?
I would do so: It would have in the same table the birth and the death, and when it wanted to calculate who was born and who died in a certain interval of time would make a query: SELECT (campos que…
-
0
votes3
answers229
viewsA: Display the result of a COUNT in the Database
In your query you have so: $sql = $con->prepare("SELECT COUNT(id) FROM quiz;"); Try adding the AS id: $sql = $con->prepare("SELECT COUNT(id) AS id FROM quiz;"); And when to display, simply…
-
0
votes2
answers305
viewsA: How to merge 4 tables into one and show text instead of INT - INNER JOIN
I didn’t quite understand your question, but to show the relationship between the different 4 tables use the following syntax: SELECT (tabela1.campo1, tabela2.campo2, ...) FROM tabela1 INNER JOIN…
-
1
votes1
answer95
viewsA: How to read a previously built-in CSV file in the android app?
Good afternoon Leandro, I found this article that may be relevant: https://stackoverflow.com/questions/8499351/how-to-read-csv-file-in-android The following code will be the answer given as correct:…
csvanswered Daniel Castro 36