Questions tagged as 'sql-update'

1
answer

How to do an update on a table by traversing another table in Mysql? [closed]

I have a schematic according to the picture below: The goal is to update the values of the seller_comission column in the tbl_history table. The tbl_history table already has a few thousand records. The seller's commission is different for...
asked by 11.09.2017 / 14:48
0
answers

Change input file field

I'm having a problem with my file change pdf . I just wanted it to change when the input file field is populated.    is not displaying any errors, but when I edit the   form, and do not fill anything in the input = file it remove...
asked by 31.08.2017 / 04:47
1
answer

Ajax and PHP Update

I'm having a problem editing the database values. My Script Code: $(function(){ $(document).on('click', '#salvar_pedido', function(e) { e.preventDefault; var id = $(this).closest('tr').find('td#id').html(); var nome = $(this).clos...
asked by 06.08.2017 / 22:28
1
answer

Changing data with PDO but does not update in the database

My form looks like this: // pega o ID da URL $id = isset($_GET['id']) ? (int) $_GET['id'] : null; //Valida a variavel da URL if (empty($id)){ echo "ID para alteração não definido"; exit; } $sql_selecao = "SELECT * FROM veiculos WHER...
asked by 30.06.2017 / 15:03
2
answers

Problems with update in federated table

I have a problem understanding an error when using a federated table. Scenery:    Server A: create view federated_view as SELECT ....       Server B: create table table_federada (A, B, C)       ENGINE = FEDERATED CONNECTION = 'mysql: //...
asked by 21.06.2017 / 16:13
2
answers

Doubt - Update in SQL from PHP form

I have a table in which columns 1 through 5 are fixed data that I feed into SQL and it appears the listing on the WEB page. In this WEB page I have a form in which the user should answer 3 questions, in inputs in columns 6 to 8. It turns out...
asked by 30.05.2017 / 19:39
1
answer

Update with Resource AngularJS

Is the Callback method for resource.update on AngularJS ? Type, var instancia = Resource.get({id:1}, function(data){ instancia.$update({id:idModelo}, modeloAtualizado) }); This works, the registry is updated perfe...
asked by 29.03.2017 / 19:21
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

SQL UPDATE SUM VALUE NOT NULL

dataTmp referencia nStock 2017-02-18 DC01234567 NULL 2017-02-18 DC01234567 NULL 2017-02-18 DC01234567 NULL 2017-02-19 DC01234567 0 2017-02-19 DC01234567 0 2017-02-19 DC01234567 0 2017-02-20 DC01234567 0 201...
asked by 18.02.2017 / 23:47
1
answer

Update table without losing information

I'm making a photo profile screen. The upload and display is ok. But when I change some other page data and saved, the image is deleted from the database (or at least out of the database). How can I change data on this screen without losing...
asked by 16.12.2016 / 16:19