I have the following query:
SELECT finempe.data_empenho
, finempe.num_empenho
, finhisem.quantidade
, finhisem.historico
, finhisem.valor
, finhisem.valor_total
FROM finempe
RIGHT JOIN finhisem ON
(finhis...
I set up a simple polling system in which you can vote only once per IP. However, it registers the IP of the network and not the user's computer, making it impossible for other equipment on the same network to vote.
I already researched Google a...
I can not list a simple table in php ... I do not see what's wrong with the code, when I run this php code it just shows me a blank page ... What am I doing wrong?
<html>
<head>
<title>Listar Alunos</alunos>
</he...
A little while ago, I decided to explore and study some sockets to be worked on in PHP.
So I got a good tutorial on the internet and I decided to create a very simple chat where I connect the server and two machines access the address to do the...
I have a select in which it is populated through a query in the database:
<select class="form-control" name="select_cidades">
<option>Selecione a Cidade</option>
<?php
$resu...
I have 2 forms, one per ajax and the other normal php. both forms are running, but when I run the php form without ajax it returns me the php form errors with ajax.
PHP With ajax
if ($_SERVER["REQUEST_METHOD"] == "POST") {
PHP Wit...
Populate a mysql database with data in this format:
andIwantedtoreturnthisinjsonusingphp,theproblemisthatIhaveforexampleseverallineswiththesamestate,andneedtoreturnthejsonstringformat:{"Estados": {
"Espirito Santo": {
"Cidades": {...
I need to convert date, time and minute to that function time() , I tended something like time('$row[postdate] $row[posthora]') could not, is there any way to do this?
I do not have code to post, I just have to convert $row['p...
In my query I have two columns where I make the sum of hours and the sum of the amount to be paid by the client at these times:
Line summing times: CAST(SUM(SEC_TO_TIME(E.teste1))/100 AS DECIMAL (15,2)) AS QTD 1º e 2º Hora
Line t...