Questions tagged as 'sql-insert'

1
answer

INSERT WITH TWO TABLES - PHP

I have the student table and the payments table, I'm doing a gym system. I have listed the two tables by putting student_id in the payments table as a foreign key. I want you to enter the data together of these two tables on the screen wh...
asked by 24.09.2018 / 17:10
1
answer

Insert in related tables

That's right, I'm not sure how to do this. tb_Customer(id_Customer INTEGER [PK], nm_Customer VARCHAR, cpf_cnpj NUMERIC) dm_address_type(cd_address_type CHAR(1) [PK], ds_address_type VARCHAR) tb_customer_address(id_customer [PFK], cd_address...
asked by 13.05.2018 / 16:30
1
answer

How to enter values in Laravel

I'm trying to use the following command to insert: $sql = "INSERT INTO tabela (campo1, campo2, campo2, campo4) values(:campo1, :campo2, :campo3,'S')"; $campos = array( ':campo1' => $nome,...
asked by 06.03.2018 / 20:18
1
answer

Sql executes in Oracle SQL Developer, but does not run in the C #

vsql = @"INSERT INTO ALUNOS_ (UF, IDADE, TELEFONE, NOME_PAI, ENDERECO, EMAIL, NOME, CIDADE, NOME_MAE) values ('sp', 0,'','','','','','','');"; This SQL when executed in oracle does the insertion but in the...
asked by 31.01.2018 / 14:20
1
answer

NullPointerException in connection with database

Anyway, I'm getting a nullpointerException so I have no clue how to deal with it, I read the net on and apparently the problem is in uninitialized variables and stuff like that, but I'm sure everything has been initialized here. Servl...
asked by 19.11.2017 / 16:24
2
answers

If there is data in mysql make a PHP / MySQL update

Well, I suppose this question is recurrent. I even tried some alternatives but they did not work. I have a Screen where I record Service Orders with the Client and PC data. It turns out that. I am filling 2 Tables simultaneously. In the...
asked by 15.10.2017 / 18:22
2
answers

How to use Insert with multiple C # SQL records

I'm new here and also in the world of programming, today I managed for the first time to make the connection from C # to SQL, when making a simple connection with BD I can insert records, but when trying to insert 2 data in the same table simult...
asked by 22.10.2017 / 01:55
1
answer

Error With Connection in Bank phpMyAdmim (New Code) Nothing is solving [duplicate]

Look, I'm not sure where to start but, anyway ... I have the page posted below, and I have already checked some with errors in the database and insertion of data in it. The code was made in case there is some kind of error it indicates during...
asked by 23.08.2017 / 20:43
1
answer

Form with automatic save

I am creating a form in tabs, which has 3 tabs and each one belongs to a table, was it possible to know if I have to save what was filled in a tab as soon as I switch to another tab without redirecting the page? <script> $('button').on('...
asked by 20.09.2017 / 19:42
2
answers

Close modal when page refreshes after an INSERT

I searched all corners of the internet but could not find anything like my problem. I have a registration form that after doing the INSERT in the database shows a modal window and inside it a success or error message along with an "OK" button. T...
asked by 05.04.2017 / 19:20