Posts by Peter • 95 points
8 posts
-
0
votes1
answer78
viewsA: Safari sends $_FILE as empty (NULL) via Ajax
I managed to solve it. If someone is also with this problem, follow below the solution I found. I changed js to the next: function saveImg() { var myForm = document.getElementById('formImg');…
-
0
votes1
answer78
viewsQ: Safari sends $_FILE as empty (NULL) via Ajax
I have an image upload script that works normally with Chrome, EDGE, Firefox and Opera. But it doesn’t work with Safari. The Safari browser opens the windows window for me to choose an image. When…
-
1
votes0
answers126
viewsQ: Is it worth using index for table in Mysql that stores chat messages?
Friends, I read several posts about the use of the index in the tables of the Mysql database, its advantages and disadvantages, but I still had a question for my situation. Consider over 300,000…
-
2
votes0
answers66
viewsQ: Tips to optimize Select in SQL. Does the conditional order in Where matter?
Do you have any tips for optimizing Select in sql? If I search a table with over 500,000 or 1 million records, is there any way to optimize my search so that it doesn’t spend too much server…
-
1
votes1
answer578
viewsQ: ORDER BY or LIMIT. What is processed first in SQL Select?
Friends, what is first processed in SQL Select? "Order by" or "Limit"? For example, if I have a table with cities of several states. Then I search the cities with more than 100 thousand inhabitants…
-
1
votes1
answer3737
viewsQ: Simple script to know how many users are online on the site?
Friends, is there a simple script in php (or some other solution for linux php/mysql server) to know how many users are online on the site? I read that websocket is good for chats. In my case, it’s…
-
3
votes3
answers924
viewsQ: Can you start a Select (SQL) in the middle of the data table?
Friends, is there any way inside the SQL language (and using mysql BD) where I can start a Select in the middle of a table? For example, I have 500 addresses in the table. I do a search of…
-
1
votes1
answer162
viewsQ: SQL doubt using subquery and IN command
I need to do the following. So-and-so has several car models. I want to list other users who also have 3 specific car models that so-and-so has. What I did: $iduser = id do fulano $mod1 = modelo de…