How can I display the least factor by ID_ACORDO?
SELECT LIGACOES.ID
,ACORDO.ID_ACORDO
,ACORDO.DATA as 'DATA_ACORDO'
,LIGACOES.time_of_contact AS 'DATA_LIGACAO'
,ACORDO.data-LIGACOES.time_of_contact as FATOR
F...
I'm having trouble while creating the database automatically via PHP. I am developing a project in MVC from college and wanted to import the sql file and through a query create the tables.
In the previous part of the code is made the connecti...
Following in the line Validate different date formats
The function below has met my needs:
function validateDate( $date ){
$europeu = date('Y-m-d', strtotime(current(explode(' ', trim($date)))));
$brazil = date('Y-m-d', strtotime(...
Mysqli (Extended Mysql) has greater security and I had until now thought that I did not need to handle the variable data before adding it to the database, but studying on this page I found this code similar to what I used in the old MySQL. bef...
I have a simple question but it's breaking my head:
I have a form where there are several checkboxes, the value of the checkbox is an id number, I would like to create something that when the user selects a certain number of checks the system m...
I have a form that passes query data and an external PHP file called busca.php
My problem is that I do not get any php error to know the problem that it does not find the filter search. When I use the normal search it returns me all th...
My doubt is that I need to get the ID with the highest value and enter the information in it. The PHP file is working but I need it to identify the ID with the highest VALUE and insert it into it instead of creating another one.
StartReport.p...
Good evening!
I've been stuck for a couple of days in the following situation, I'm not able to parameterize or create an expression that validates interval between dates, which works like this:
In other words, if you already have a s...
My problem is this:
I have this code that displays multiple cars in a table:
<?php
$veiculos = "SELECT * from veiculo ";
$veiculos .= "WHERE id_secretaria = '1' ORDER BY placa DESC LIMIT 2"; //mudar conforme o id da secretaria
$query_veicul...
I have table A with the id and user fields
and table B with id, data and id_A;
In the PHP page I want the contents of table B to appear, and with the id_A to search for the name in table A.
The main thing for me would be to search for a table...