Posts by SneepS NinjA • 7,691 points
231 posts
-
1
votes1
answer445
viewsA: How to pass a stored parameter with escaped characters?
in mysql use: UPDATE exemple SET col = '{"video":"<iframe width=\'480\' height=\'600\' src=\'www.qualquercoisa.com\'"}' where id=1; or in php use addslashes()…
-
0
votes4
answers599
viewsA: Tool for mobile zoom
I use the zoom on the entire page It’s a different idea try there: http://jaukia.github.io/zoomooz/ I have it on a system and I needed to make some adjustments to run on all browsers, so if you use…
-
1
votes1
answer996
viewsA: How to send message only to a user with Websocket
1 - think of sender/recipient 2 - Sender sends message and recipient to socket(ex: login). 3 - All "listeners" of the socket receive the message, but you have to make a filter to check if the…
-
5
votes1
answer184
viewsA: "clear" text written in input A and rewrite it in input B using jquery
To make a replaceAll in all "spaces" need to implement the rest is simple thing, I made an example: String.prototype.replaceAll = function(de, para){ var str = this; var pos = str.indexOf(de); while…
-
2
votes1
answer222
viewsA: Database with problems for accentuation
next, p/ do the charset configuration from mysql+php until the HTML view has to configure the my.ini or my.cnf file depending on the platform [mysql] default-character-set=utf8 the php.ini file…
-
1
votes1
answer155
viewsA: transform Query String url to a Readable url for the user
When you use the url with the symbol "?" what comes next are $_GET parameters. I also know that it is possible to change the url via javascript, so yes it is possible to make the url more "readable"…
-
0
votes1
answer1425
viewsA: How do I use Node.js to run a PHP page?
for Node to run the page I see no problem, you simply configure it, run the script that makes the call from php and end, but I think the most elegant solution is to make php itself calling itself (…
-
1
votes1
answer773
viewsA: jQuery UI autocomplete with AJAX call not displaying settings
ta missing part of "select" friend I will show you an example of my: $('#cid_nome').autocomplete({ // AUTOCOMPLETAR A PLACA DO VEICULO minLength: 2, // TAMANHO MINIMO PARA AUTOCOMPLETAR source:…
-
1
votes1
answer1126
viewsA: Previous registry Mysql
tested and worked well below it takes the penultimate record from the table SELECT max(compoid)-1, t.* FROM Tabela t ORDER BY compoid DESC LIMIT 1;
-
12
votes13
answers20263
viewsA: What makes a language to be considered low/high level?
I will be short not to lengthen like the others, the code you wrote is to directly manipulate the hardware? ex: driver programming of a particular equipment, then you will use a low-level language,…
-
1
votes1
answer665
viewsQ: Number of processors in Hyper-V
I have a virtualized Windows Server 2003 server with Hyper-V. I set the option "logic processor numbers" to 4. On Windows, it appears on the 4 Cpus device management list. But in Windows task…
-
4
votes2
answers472
viewsQ: linux command - lock folder name/rename
need to give access to an ftp user in the /var/www folder but there are folders there that it cannot access/edit/delete tried a command: #chmod 000 <pasta> almost worked, it does not delete,…
-
1
votes2
answers268
viewsQ: Large images corrupted or truncated when pulling from SQL server with PHP
I am searching images from the SQL-server database through PHP and jQuery+AJAX. The image when it is small loads everything full, but when the image is a bit large from this error in Javascript:…
-
1
votes1
answer148
viewsA: select like that returns a Sting without line break
GOT IT THIS WAY: select distinct con_destinatario from tab_conhecimento where con_destinatario like '%CALLE%' AND con_destinatario NOT LIKE '% %CALLE%' order by con_destinatario; Thank you.…
-
1
votes1
answer148
viewsQ: select like that returns a Sting without line break
I am using the following query: select distinct con_destinatario from tab_conhecimento where con_destinatario like '%CALLE%' order by con_destinatario; and get several results of this type: A.S.…
-
0
votes2
answers171
viewsA: How to reset a selection menu (selectmenu) when changing another field using a function?
With the change event in both looks like this: <script src="js/js_1.9/jquery-1.8.2.js" type="text/javascript"></script> <div> <label>Selecione Um Prazo Padrão:</label>…
-
2
votes3
answers220
viewsA: Show query (Problem Different Id’s)
In accordance with Mr. @Motta, the correct is to make A table to record the details of each worker so being the same rule for the table where records the equipment, and company ( assuming that there…
-
0
votes2
answers451
viewsA: How to avoid duplicate emails in the database?
just put the field where the email is registered as UNIQUE, if an Insert tries to enter an equal value it will not allow. ALTER TABLE `test`.`aplicacao` CHANGE COLUMN `name` `email` VARCHAR(255) NOT…
-
1
votes1
answer204
viewsA: Slowness with group_concat in mysql
I did a test here and saw that the query is doing select_full_join, ie this giving select in the entire table p/ generate this query, what I did is the one of the execution plan that Mr. Jorge…
mysqlanswered SneepS NinjA 7,691 -
2
votes3
answers1488
viewsA: Foreign Key in another database?
about the first question, foreign key in another database, what is allowed is to make an attribute with the same name and use the value of equal Indice in the other database, but mysql does not…
-
1
votes2
answers2564
viewsA: Mark all checkboxes of a Datatable table?
In this code every checkbox that has the class='mark' will receive the checked, this will happen at the moment the script is called, in case you have conditioned in the event click of another…
-
1
votes2
answers308
viewsA: Duplicate Ajax Records, Jquery
It can be two situations: 1 - when the user clicks the button, implement in the event click the button’s Hide to prevent it to be clicked 2 times. 2 - use stopPropagation() in the event to prevent…
-
1
votes4
answers1083
viewsA: External connection JSON Webservice
ta running only localhost right? then the problem may be because you are not releasing cross-Omain, you have to allow external access in the header: <php> header('Access-Control-Allow-Origin:…
-
1
votes3
answers627
viewsA: How to collect the height of an element with jQuery
I made a test here p/ you, this is how I do, probably you are not managing to perform what you want for some reason "after" you have already set the height. $('#foo').click(function(){ var altura =…
-
0
votes3
answers522
viewsA: Hide div, display only at home
Two solutions to make the banner disappear when you click the menu. Solution number 1: $('#cssmenu').click(function(){ $('.imgBaFu').hide(); }); Solution number 2: (function($){ $.getUrlVar =…
-
1
votes2
answers5787
viewsA: How to take CSS values from one element and apply to other elements. Stick Footer
Ryan’s solution says nothing about colors whether from source or background but if you want to take css from an element do the request like this <script> var cor_texto =…
-
3
votes1
answer1066
viewsA: How to make a hover effect change another "object" selected in jqGrid?
Come on I’ll give you an example <style> .azul{color: blue;} </style> <script> $('#a').hover(function(){ $('#b').toggleClass('azul'); // muda a cor do texto em B quando A estiver…
-
0
votes2
answers146
viewsA: Error in mysql query in php
solved the problem, need to open another connection for the other operation, just do not know why. Thanks lost for the tip, I will use mysqli_* because I didn’t even know about the mysql…
-
1
votes2
answers146
viewsQ: Error in mysql query in php
I make an appointment at DB mysql and it works normal, then I’m going to do the second consultation and you give me the following mistake: Warning: mysql_fetch_object(): supplied argument is not a…
-
3
votes3
answers637
viewsA: Deploying queues for Websocket
regarding "doubt is how I will be sure that the first message was sent to send the second of the queue and so on..." Here’s the thing, in socket, the server side can "hear" a client, when the client…
-
-2
votes4
answers4082
viewsA: Change page without changing user URL
In native javascript to do so: <script> document.getElementById("id_da_div_ou_Body").innerHTML = '<object type="text/html" data="arquivo.php" ></object>'; </script>…