Questions tagged as 'mysql'

Tagged questions
1
answer

Format xml in php to write to MySQL?

I need to format a xml in php to write to MySQL , but I'm having difficulty understanding and even doing it. Today I have this xml: <?xml version='1.0' encoding='UTF-8'?> <api> <response vers...
asked by 06.04.2017 / 16:23
0
answers

Assemble a dynamic search

How to do a filter search in the database using this example below: The bank variables are: Nome Professor T | Matricula T |Nome Professor S | Matricula S | Nome Professor A | Matricula A | Turma | Ano | Unidade | Modalidade | Tipo do Profe...
asked by 25.04.2017 / 22:49
0
answers

Question on How to pass selected rows from one datagridview to another

Good evening. I'm developing a Windownsform application with C # and mySql , I'm having some questions on how to pass data from one datagridview to another. Datagridviews are found in different forms. I have some code already done that I can al...
asked by 01.04.2017 / 00:42
0
answers

Delete database data after 20 minutes

Colleagues. I'm finalizing a virtual store, however the customer will work with inventory. The proposal is that after 20 minutes of idleness of that user, the products will be automatically deleted from the cart so inventory will not get stuc...
asked by 01.04.2017 / 15:59
0
answers

Incorrect date / time format

In my following code snippet: String horario = evento.getDataOcorrencia().concat(" ").concat(evento.getHoraOcorrencia()); horario = horario.replaceAll("/", "-"); SimpleDateFormat dateFormat = new SimpleD...
asked by 28.03.2017 / 13:07
1
answer

How to put a variable alert in the onclick parameter of a link? using jquery and php

I need to put a product message unavailable on my system, which takes the available status of the db (YES or NO) I did an IF that changes the image of the product when the status is NAO but I want a message if the user clicks on it saying that t...
asked by 30.03.2017 / 02:57
2
answers

Select in multiple columns with dot in name does not return result

Each column is composed of names, so-and-so, cyclamen, beltran etc. I want to select all names that are different. If Joaquim exists in two columns, he must return one. But the problem is not there, it's in the name of the columns that contain c...
asked by 23.03.2017 / 23:19
0
answers

How to convert a string from a worksheet to date format for mysql?

I'm looking for a way to do this, but I'm not sure how to do it. try converting to mysql but in the insert the following column error appears    'column name' can not be null follow the insert $salesplan_insert = mysqli_query($link,"i...
asked by 15.03.2017 / 13:10
1
answer

Select best sellers in related table

I have a table pedidos , produtos and other produtos_em_pedidos described as follows: produtos: id | nome pedidos: id | data produtos_em_pedidos: produto_id | pedido_id | quantidade I need to select the products that mos...
asked by 15.03.2017 / 14:43
1
answer

Creating MySQL Table

Recently I started to study a bit of , and I solved create a register table here in the club that I am part of. Create database Clube default character set utf8 default collate utf8_general_ci; use Clube; create table Cadastrados( Nome varch...
asked by 15.03.2017 / 16:58