Posts by Murilo Souza • 247 points
18 posts
-
0
votes2
answers141
viewsA: How to limit Ips that can remotely connect to mysql?
I was able to solve by deleting the row from the mysql.user table where the host='%' and the user='user'.I don’t know if it’s the best way, but it worked, now only connect users/hosts who have some…
-
1
votes2
answers141
viewsQ: How to limit Ips that can remotely connect to mysql?
I have a centos 7 server with Mysql 5.6 installed, I can control the privileges of each user/host with GRANT.But my question is how to allow only a few Ips to connect to the bank. Currently any IP…
-
9
votes2
answers2252
viewsQ: How to check real-time database change with php websocket?
I want to update a div only when there is change in a certain field in the database, I’m currently using Polling, but I want to switch to websocket for performance reasons, but I only found examples…
-
3
votes1
answer94
viewsQ: How to empty php buffer while running?
I want something printed on the screen during execution, and not only when the script is finished, I tried: <?php ob_start(); for($i = 0; $i < 5; $i++){ echo $i . '<br>'; ob_flush();…
-
1
votes1
answer2051
viewsQ: How to use ssl with php?
I’ll buy a certification SSL for my website, however, I’m still not quite understanding how it works. The only thing I have to do to make the site "safe" is to add "https" to Urls, or I have to…
-
0
votes2
answers303
viewsQ: How to recover data from an invalid form? PHP
I have a registration form that I send to a php script that does the processing and writes to the bd, the problem is that when some form field is invalid, I direct again to the form, but it is…
phpasked Murilo Souza 247 -
0
votes1
answer2356
viewsQ: Phpexcel generates corrupted file . xslx
I want to generate a file .xlsx, with records that were not imported from another table .xlsx, but I can generate the file .xls without problems, already when I try to generate .xlsx, Excel warns…
-
1
votes1
answer115
viewsQ: Export Mysql database with foreign keys
My hosting uses phpMyAdmin to manage the bank and does not allow the remote connection because it is a free plan. I need to export my base to the hosting, generated the . sql file with the command…
mysqlasked Murilo Souza 247 -
0
votes1
answer309
viewsQ: mysqli: Couldn’t fetch mysqli_result
I want to save the result of a query in $_SESSION, but when I try to retrieve the $_SESSION, wrong "Couldn’t fetch mysqli_result". Note: I use the session_start(). Follows the code: Query mysql:…
-
1
votes1
answer108
viewsQ: How to modify :Hidden elements with jquery?
I use Bootstrap Carousel and need to modify the margin-top of a title, but when the content div is :Hidden, I cannot get the text height with jquery. Follows the code: $(document).ready(function ()…
-
1
votes1
answer2645
viewsQ: Doubt fixed navbar at the top with Bootstrap
When I add the class "navbar-Fixed-top" it "eats" 50px of the page, use in navbar, links, to Divs and whenever a link is clicked the first 50px are below the navbar, what I want to do is to prevent…
-
0
votes1
answer1054
viewsQ: How to know which div is shown on the screen with javascript?
I have a site with multiple Ivs, and I need that when the screen arrives in a certain div, an action happens, but I don’t know which javascript event or jquery is responsible for it. Example:…
-
0
votes1
answer112
viewsQ: Pass by reference of a vector structure in C!
I have the following code: #include <stdio.h> #include <stdlib.h> #include <string.h> #define TAM 3 typedef struct{ char nome[50]; char musica[50]; int integrantes; int ranking;…
-
2
votes2
answers853
viewsQ: How to get input value by clicking the div(multiple Divs with the same class) with jquery?
I have the following code: <div class='premios text-center col-xs-12'> <div class='div-img-premio'> <img class='img-premio img-responsive' src='$imagem'> </div> <p…
-
1
votes1
answer57
viewsQ: Select a product by establishment in mysql database!
I have a database with the tables estabelecimentos and produtos. Register the products relating to the establishments. I need to make a query where select only one product from each establishment, I…
-
1
votes3
answers5460
viewsQ: How to hide the file URL? (do not show the whole file up)
Personal I want to hide the URL of the files, example: example.com/cadastro.php would have some way to leave only example.com? Or some other way, but not show the complete path. Thank you.…
-
2
votes1
answer900
viewsQ: How to transform (cut) only one side of the element with css?
I need to do a background like that of the image, I was able to do both sides using the transform: skew(), But I need to do it on the right side as in the image! I appreciate the help!! mine is so I…
-
8
votes2
answers1059
viewsQ: How to create a csv from a database and data query
I was able to create a perfect . xls file, but . csv can’t follow the code I used to create . xls $dadosXls = ""; $dadosXls .= " <table border='1' >"; $dadosXls .= " <tr>"; $dadosXls .=…