Questions tagged as 'sql-update'

Tagged questions
1
answer

update multiple records with php checkbox mysql

I need to update a mysql table with data coming from a / two checkbox where checked is 2 and unchecked is 1. It turns out that if you check the id1 of col1 it will update id4. What will be wrong? My mysql table looks like this: id col...
asked by 01.03.2016 / 02:34
1
answer

Editing form does not display uploaded data

I've been trying for some time to make a form in CodeIgniter 3 for editing data display in its fields the values of each column of the selected record. The update operation is working normally, but since the fields are blank, I need to re...
asked by 16.11.2015 / 04:02
1
answer

mysql update using array

I'm having trouble inserting an array into the database ... I tried this script but it only inserts the last id of the array; <?php $_conexao = mysqli_connect("localhost", "root", "", "vbt_posteds"); $id_ind = $_POST["inds"]; $id = "57";...
asked by 25.09.2014 / 16:07
1
answer

Trigger Mysql from one base to another

I'm trying to create a trigger in Mysql where I need to update a table (I'll call tb1) depending on the situation field, delete a record in another database from a table.    Base 1 = B1   Table 1 = Tb1   Base 2 = B2   Table 2 = Tb2 - trig...
asked by 04.01.2019 / 13:53
2
answers

Update the data associated with a specific name in a Database by PHP and SQL

UPDATE: This question will be long - note that I am very inexperienced in PHP . I have been trying to create a web page that can access a database created in PHPMyAdmin in the last few days, it is currently able to insert data into the databa...
asked by 15.12.2018 / 21:46
1
answer

Doubt with Update in Asp.NET MVC

Sorry for the question, I'm learning Asp.NET with EF and I'm having trouble performing a specific Update. I want to make a system where there are cash transactions between accounts. The structural part is ok, but the problem is this: When...
asked by 25.11.2018 / 23:28
1
answer

Change variable in UPDATE PDO PHPERRO: PDOStatement :: execute (): SQLSTATE [HY093]

@$c_matricula = $_POST['numero']; @$data_aa = $_POST['data_aa']; @$data_ff = $_POST['data_ff']; if(isset($data_aa)){ @$dataa = date("Y-m-d H:i:s"); $pdo = $dbconn->prepare("UPDATE contato SET c_data_andamento = :data_a WHERE c_matri...
asked by 15.09.2018 / 23:22
0
answers

Use cursor to update a MySQL table, based on a search

I would like some guidance on a challenge in MySQL 8. I have two tables: usuarios (id_user, nome, nascimento, endereço, cidade, ...) utilizacao (id_medicamento, nome, nascimento, medicamento, data, ...) The usuarios table stores all...
asked by 24.08.2018 / 15:20
0
answers

Connect my pc's database to the hosting

I want to connect the hosting to the local database of my PC I'm using linux. I have the doors 1604 and 8080 open. When I access my ip: port on an external network, I can access my website. But when I go to the hosting, it does not connect to th...
asked by 05.08.2018 / 09:30
1
answer

Column update of one table with data from another

How do I perform this update? update estoque,tabcest set estoque.cest=tabcest.cest where locate(trim(tabcest.ncm),estoque.ncm) and estoque.tipoproduto in ('produto','consumo') and estoque.cest is null; It's taking a while, it's not actua...
asked by 26.07.2018 / 06:51