Questions tagged as 'mysql'

Tagged questions
0
answers

INSERT IF NOT SQL (PROCEDURE)

I need to create a SQL procedure that does what's down here! -- procura cadastro SELECT id_cadastro FROM c1datasource.tb_cadastro where cpf_cnpj = '12344'; -- se não achou, insere INSERT INTO 'c1datasource'.'tb_cadastro' ('nome', 'cep', 'cpf_...
asked by 01.02.2018 / 15:26
0
answers

Problem creating log

To create a log for my system to know that it has changed information, but the way I mounted it is giving Fatal error: Call to undefined function anti_injection () in: Can anyone help or give me some example log change logging in php / mysql?...
asked by 02.02.2018 / 16:37
0
answers

Error Can not read property 'toString' of undefined

I'm creating an application using Express , but I'm facing this error: ➜ Futiba git:(master) ✗ node index.js ➜ [ Server ] Online /home/akira/Downloads/Futiba/node_modules/mysql2/lib/packets/execute.js:57 var str = this.parameter...
asked by 02.02.2018 / 15:39
2
answers

Using @Table Hibernate

How do I use the @Table annotation of hibernate using a variable that returns the name of the table, for example @Table(name = "dep4"+Dados.getCodEmp) ? I am using this form but I get the following error: The value for annotation...
asked by 31.01.2018 / 12:11
0
answers

How do I while with mysql to autogenerate scripts to populate the database

People, my problem is this, I have to populate a database based on an excel table, and for each entry in the variable quantity a new row should be added in the table, so I developed this logic where I am going to populate the data using =CONC...
asked by 30.01.2018 / 19:43
1
answer

POST is not getting input data that is in javascript

Well, clicking on the "Schedule News" button displays an input for date and time ... But when you send the "form", the input that is inside the javascript is not receiving the data, the normal ones are already. .. Funny that I used this code yes...
asked by 30.01.2018 / 19:56
1
answer

Website - User changes the password even if there is an error between the new pass and the confirmation of the same

When a user wants to change their password there are 3 labels, 1 for the old password and the other 2 for the new password and for the confirmation. If I enter all the fields correctly, everything goes as I want, but if the new password and its...
asked by 04.02.2018 / 19:58
1
answer

Error in PHP login, the registration is working normal, except that the login does not connect according to the entries in the database

YOU ARE GIVING THIS ERROR WHEN YOU WILL ENTER:    Warning: mysqli_query () expects at least 2 parameters, 1 given in C: \ xampp \ htdocs \ hosste \ Login_v1 \ userauthentication.php on line 28       Warning: mysqli_error () expects exactly 1...
asked by 07.02.2018 / 13:00
1
answer

My insert does not register the data in mysql

I'm trying to insert some data into my bd, I've done this in other systems and it always worked, but this time it's not working, it does not show any error messages, it just does not include the database, I tried I did the echo in the sql and he...
asked by 29.01.2018 / 20:38
1
answer

Problem in update mysql

I have a function that performs an update: function alterarConta(){ $dataemissao = $_POST['dataemissao']; $id = $_POST['id']; $select_fornecedores = $_POST['select_fornecedores']; $valor = $_POST['valor']; $datavencime...
asked by 29.01.2018 / 17:05