Questions tagged as 'mysql'

2
answers

I get an error with modifying database from C # [closed]

   This is my code but I do not know if there will be any problem with the sentence I have made public void modificar(Int32 cantidad, String producto, String tipo_pedido, Double total) { conexion.operacion("UPDATE pedidos s...
asked by 04.10.2018 / 02:03
2
answers

record data in different tables

I get the following question: I have three tables in my database (student (role 1), teacher (role 2), guardian (role 3)) each of them has a specific role and I have a form to register the data, I would like to know if there is a way to register...
asked by 20.09.2018 / 17:42
1
answer

AJAX Update live data

I am writing a system that should update two divs, as much as possible, in real time. The way I found it is as follows, using AJAX: function actualizarDatos(){ $.ajax({ type: 'POST', cache: false, async:true, url: 'l...
asked by 25.09.2018 / 15:05
1
answer

Send records to several tabalas- mysqli

I would like to know how it is sent from a single form to different tables. for example I have the following code could add an example by sending different records to two tables. <!doctype html> <html> <head> <meta char...
asked by 17.04.2018 / 03:31
1
answer

Save a two-dimensional array created in Php in a MySQL table

While there are similar questions answered, I could not solve my problem. I have generated from Php, a two-dimensional array obtained from a previous page, from where I passed the data by the POST method, now I need to save them in a table previ...
asked by 06.11.2018 / 15:01
3
answers

Help with SQL query (several records in the same field)

I hope to explain myself well and that you can help me, thanks in advance, the situation is as follows: I am developing a system that diagnoses computer failures, which will work in the following way, the user will select several symptoms and...
asked by 06.11.2018 / 11:42
1
answer

Save result of Array in Mysql

with help I have used the following code that allows me to enter data from an input and that it be separated into 3 different values that I need, which are value, code and serial <?php $datos = "3,5 1401 4145 7854 8454 7458 5152556555 5 140...
asked by 21.09.2018 / 14:18
1
answer

Problem to save record with PHP

I must keep a numeric record (units that come in a box) but it is not saving me I do the following. if(isset($_POST['act'])) { if($_POST['act'] == '1') { if(!isset($_POST['name']) || !isset($_POST['descrp']) || !isset($_POST['cat']...
asked by 11.09.2018 / 16:36
2
answers

Error importing: Operation has completed with errors

I'm trying to make a model's forward engineer to pass it to SQL and it throws a syntax error, the message says that it was completed with errors, the error as I said is syntax, but if the same workbench does the script, does it? why do you get i...
asked by 12.09.2018 / 14:43
3
answers

Display data in a row of a table if 2 data match

I have a record of entry and exit of each worker (each one has an ID) where each of them only enters their user code and records their schedules, but it happens that sometimes they are forgotten. How can I display the data in the same row of a t...
asked by 20.09.2018 / 20:35