Posts by Gabriel • 27 points
7 posts
-
0
votes1
answer61
viewsQ: Search json tags with REGEXP ignoring accents
How can I ignore the accents with regexp? with LIKE was working, however I was having trouble with posts whose number of tags was large. SELECT id, JSON_EXTRACT(quiz_json, '$.tags') from…
-
-1
votes1
answer70
viewsQ: Is it safe to make mysql queries using cookie values?
Hello, next I made a system that works, but I am doubtful whether it is safe to use it to ensure that it has greater security or at least try to obtain it. I’m using a function that only reads…
-
0
votes1
answer47
viewsQ: Limit cookie value to 30
Next I’m with the system to make a history on a site, it saves the id of the page that the user visited, separating the id by comma. Would it be possible to limit the value to 30 ? example…
-
1
votes1
answer315
viewsQ: Allow number-only queries in mysql
I would like to know if you can prevent the query of words, characters and other things that can make an Injection sql on a site. I am developing a system for the history of a site, follow the…
-
0
votes1
answer27
viewsQ: Multiple value with comma separation
Next, I am using setcookie in order to get ids of all pages visited per user and so do a kind of history, but I come across a problem when not the possibility to update the cookie value by adding…
-
-1
votes1
answer472
viewsQ: History with last accessed links
I recently saw a site with a somewhat cool system, it showed a history with all the links that the visitor had clicked, showing images and page titles, and clearly used browser cookies. I researched…
javascriptasked Gabriel 27 -
1
votes2
answers362
viewsQ: Sort Numbers and seasons correctly
Next I need to formulate a SELECT, whose function is to show episodes in order of seasons, example T1E1, T1E2, T2E1 continuously, for the following structure : `eid` int(10) NOT NULL, `aid`…