In the projects page, where all the projects are, there is an option (select option) to sort alphabetically and another to sort chronologically.
When going to the detail of each project has a link to the project to follow and another link to the...
I'm trying to do an INSERT on two tables, first I need to enter the vehicle information on the 'vehicle_table' table and I need to insert the images into the 'image_table' table. You are entering the ELSE of the first INSERT, I wanted to know wh...
I'm developing an order tracking system, and I'm finishing, but now I came across a problem in the payments part schema:
I'm linking id_pedido to payments, but when the request costs R$48,90 and the person pays R$50,00 , I...
Hello,
I need to get the description of my parent category, but I can not get the description in the same select, I can only get the parent category id.
I have a table with the following structure
Below is the code that I am getti...
Hello! I'm doing a web project and needed a click simulator, where for every click on the link I would give 1 centime, 0.01 euro (Portuguese currency)
The instructions they gave me were:
We will develop the application financing module. is...
Hello, I am developing a small order control system for a restaurant and I do not have much experience in database modeling, I have created the following entities:
The problem is the following, for normal products it works but has produc...
Save working correctly
<?php include "conectar.php";
$nome="$_POST[nome]";
$sobrenome="$_POST[sobrenome]";
$email="$_POST[email]";
$cpf="$_POST[cpf]";
$dddcel="$_POST[dddcel]";
$cel="$_POST[cel]";
$dddtel="$_POST[dddtel]";
$tel="$_POST[tel]...
I have the following query:
SELECT FORMAT(valor,2,'de_DE') AS valor,
DATE_FORMAT(data_vencimento, '%d/%m/%Y') AS data_vencimento,
realizado,
DATE_FORMAT(data_realizado, '%d/%m/%Y') AS data_realizado,
parcelas,...
I'm building a database, but at the time of generating the diagram in the reverse engineering of the workbench no table linked to another, and the FK does not appear, I wanted to know if I did something wrong,
CREATE database db_hospital;
USE...