Questions tagged as 'sql-update'

Tagged questions
1
answer

Delete in an UPDATE trigger

How can I delete a record being inserted into a specific condition in a trigger? example: USE 'scompraslenovo'; DELIMITER $$ CREATE TRIGGER 'precad_fornecedor_BUPD' BEFORE UPDATE ON 'precad_fornecedor' FOR EACH ROW BEGIN IF (new.f1 IS N...
asked by 17.12.2014 / 16:54
3
answers

Undefined variable when updating the Database

I have a problem doing Database Update. $AcidenteValidade = $_POST["AcidenteValidade"]; $AcidenteAnexo=''; if (isset($_FILES["AcidenteAnexo"]) && $_FILES["AcidenteAnexo"]["name"] != '') { $nomeTemporario = $_FILES["AcidenteAnexo...
asked by 01.04.2014 / 12:50
1
answer

Update in mysql table in loop [closed]

Hello, I have a mysql table that contains the student's number and class date already registered, and I need to update the "PRESENT" field with "S" or "N". In other words, register the traditional call. Could someone give me a suggestion? I'm us...
asked by 28.10.2017 / 14:31
0
answers

C # Check if there is File then [closed]

Good afternoon, I have a code that cleans notepad, writes to another notepad and inserts into the database, but now I need it to check if there is another file with the same name and if it is recent, do the update, but I do not know how I can do...
asked by 04.01.2019 / 18:03
1
answer

Error updating image "Array to string conversion"

I have a form where information is sent to the database, all are changed correctly except the image that is not changed. ed_cons_.php <?php //inicia a conexao com o banco include ("conexao.php"); ?> <html lang ="pt-br">...
asked by 14.09.2018 / 15:20
1
answer

Update Mysqli Data

I need to make the DB update the following data from this wireframe via MYSQLi, I would like some tips on how to proceed:     
asked by 18.04.2016 / 20:13
2
answers

How to merge edit / new button?

I would like that, if already there is $nome registered in the table, it gives an update and if it does not exist, it gives an insert. I do not understand what the problem is in my code. $dbconn = mysqli_connect($servername, $username,...
asked by 01.07.2017 / 13:24
2
answers

Do a "Update" with a sum of a number that is as a character

I need to do a% with_quality with sum in a table whose column is of type update . Example: UPDATE produto SET codigo = 'codigo'+ 1; I have the following return: UPDATE produto SET codigo = 'codigo'+ 1; ERROR: invalid input syntax f...
asked by 27.07.2018 / 16:06
3
answers

Update in the database is not working

My update in the bank does not work, it follows codes: aluno.php <form method="post" action="?acao=save&id_aluno=<?php echo $id; ?>"> <?php echo $pegaid; ?> <input type="text" name="ID" class="txt-m...
asked by 07.02.2017 / 05:43
1
answer

Update uncomplicated

Hello everyone, first of all, my question is the following ... on my site I have a visits system it works as follows if (the visit does not exist) { $ handle="takes the fields of the visit to the bank"; $ array = mysqli fetch array in ca...
asked by 31.12.2017 / 03:06