Good evening,
I'm new here.
One question I think is basic.
I will create an "application" with PHP and mysql where I control the working hours of each collaborator with daily inputs and outputs.
The doubt is the SQL just stores the data...
I'm developing a PHP post system with MySQL.
I need the line breaks that the user enter in textarea to be converted to <br /> .
The variable $texto (contains the contents of the post) goes to the database in the colu...
I have a table with images, images , in which one of these columns ( file_name ) has image names, jpg other png , what I need is to change, make UPDATE all to the extension png , that is, change any extensio...
I have a separate table in MYSQL with the addresses of the users containing the location information (latitude and longitude), each user being able to have more than one registered address. My goal is that when performing a search for a location...
Hello, I'm working on an alert system, when a larger than normal data is registered in the database an alert has to appear on the page where the user is browsing. The problem is that I do not know how to check if an element has been added to the...
I have the following sql query:
$sql= mysql_query("SELECT dia, GROUP_CONCAT(hora) FROM marcacoes WHERE colaborador_id = {$colaborador_id} GROUP BY dia ");
The result is:
07: 30: 00: 00: 00,13: 30: 00: 17: 00: 00
How do I get the com...
I'm studying Java with database and I'm doing a few examples. On the PC with Windows I used a code and it worked, there was no problem, I now use Linux and the same code is giving error when calling the% with% of DriveManager.getConnectio...
The sales table has the following structure:
id_venda | nome_cliente | data_venda | data_agendamento | data_cancelamento | data_ligacao
Where the "date" fields are all datetime.
I would like to sort according to the last move that occurred....
I placed a button on my page to send the data to a table in mysql.
<button type="button" class="btn btn-block btn-primary">CADASTRAR</button>
How do I, when I click the button it does the register operation in the table, the exa...