Posts by João Pedro Morais • 127 points
18 posts
-
0
votes1
answer76
viewsQ: Consultation of very slow cep
date_default_timezone_set('America/Sao_Paulo'); include 'conn.php'; $query = $mysql_adv->query("SELECT * FROM dados"); while($row = $query->fetch_array()){ $url =…
-
1
votes1
answer62
viewsQ: How to take a JSON data in this case
I’m not getting a given JSON in this case: Use this site only for own testing https://devjp.xyz/data.json I tried some combinations: $url = "https://devjp.xyz/data.json"; $json =…
-
1
votes1
answer1920
viewsQ: How to update the page and run a javascript function
I want when the page is updated to perform a function when opening When running this Reload open the page with the next code: ---------------Executou para dar reload------------ window.location.href…
javascriptasked João Pedro Morais 127 -
0
votes0
answers66
viewsQ: My modal won’t open
The modal is working normally but does not open inside this function, I am very lay in javascript $(function($) { $('#frmLogin').submit(function() { $('div.mensagem-erro').html('');…
javascriptasked João Pedro Morais 127 -
-1
votes2
answers2893
viewsQ: Change date and date time format in Mysql
I do not want code to send the date converted to Mysql, I want to know if it is possible to show the date as 09/05/2018 09:59:54 instead of 2018-05-09 09:59:54. It is possible to change this in some…
-
1
votes1
answer40
viewsQ: Register filter by date
My code is not working which may be wrong? In the database the date is with Date/Time as datetime, follows the code: <?php $query = $mysql->query("SELECT * FROM c_clientes WHERE…
-
0
votes1
answer20
viewsQ: How to change the date 2017-07-04 12:53:14 to Day/Month/Year with PHP
How to change the date 2017-07-04 12:53:14 to Day/Month/Year and continue the normal schedule with PHP, it’s coming like this "2017-07-04 12:53:14" from the database I want to stay 04/07/2017…
phpasked João Pedro Morais 127 -
1
votes0
answers47
viewsQ: My listing is taking too long to load
<div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th class="text-center">ID</th> <th>Nome</th> <th>Cpf</th>…
phpasked João Pedro Morais 127 -
-1
votes1
answer124
viewsQ: How to replace data with php mysql EX:
I have a table with all the states with a column of STATE ID, and one of the name of the right state. When the registered user goes the state number with his registration, there need to make a query…
phpasked João Pedro Morais 127 -
1
votes0
answers37
viewsQ: How to put SSL in this PHP Websokets system
I created this chat on websokets but I can’t use it on my domain with SSL if someone can help http://rlag.esy.es/, are 2 code files to work 1 php executable and the front-end javascript could not…
-
0
votes1
answer57
viewsQ: How to use ORDER BY for a data that does not come from the Bank?
How to use ORDER BY for a data that does not come from db? ex: $query = $mysql->query("SELECT * FROM db_aux ;"); while($row = $query->fetch_array()) { $url =…
-
1
votes1
answer40
viewsA: How to take while from this example and display only 1 data?
$query = $mysql->query("SELECT * FROM dados WHERE id='$id'"); $row = $query->fetch_array(); echo $row['nome'];
-
0
votes1
answer40
viewsQ: How to take while from this example and display only 1 data?
How to take while from this example and display only 1 given? $query = $mysql->query("SELECT * FROM dados WHERE id='$id'"); while($row = $query->fetch_array()){ echo $row['nome']; }…
-
0
votes1
answer58
viewsQ: Does it make any difference to use .class.php?
Change something to use .class.php example: Conn.class.php Whenever I search about appears about class and the programming itself!
phpasked João Pedro Morais 127 -
0
votes1
answer50
viewsA: I cannot join two tables in php
Have you tried using INNER JOIN ? EX: "SELECT * FROM c_endereco INNER JOIN c_cliente ON c_cliente.idunico_cliente = c_endereco.idunico_cliente INNER JOIN c_cadastro ON c_cadastro.idunico_cliente =…
-
0
votes0
answers28
viewsQ: How to sort by the smallest number my table with data that comes from an api
How to sort by the smallest number my table with data that comes from an api? <?php $query = $mysqladv->query("SELECT * FROM advogados_aux WHERE adv_idunico='$idadvun';"); while($row =…
phpasked João Pedro Morais 127 -
0
votes1
answer22
viewsQ: Shouldn’t queries be executed in a view?
I ended up reading this little "It is important to note that queries should not be executed in a view. The correct thing is that you apply a MVC Pattern( Model View Controller) and separate things.…
phpasked João Pedro Morais 127 -
1
votes1
answer45
viewsQ: How do I get the given 'distance' in JSON in this example?
How do I get the given 'distance' in JSON in this example? $url =…