Questions tagged as 'mysql'

Tagged questions
0
answers

Problems to list BD MYSQL in eclipse

I'm having a problem in my Java code when listing the MySQL DB in Eclipse. It turns out that when I post to list the data, it is listing the information 3 times but when I do SELECT * FROM in MySQL the data is being listed correctly. C...
asked by 25.06.2018 / 01:20
0
answers

Group search mysql

I need to search the different dates of the table, and search for the values corresponding to a certain period, in the same search ... already tried some possibilities and did not work $datai = date("Y-m-01"); $dataf = date("Y-m-t"); $st...
asked by 29.06.2018 / 13:59
0
answers

Count the number of times a category is chosen by customers!

I have a table with the categories, and each customer that registers can choose up to 10 corresponding categories that corresponds to his work! These categories in the customer table are saved ID's, I need each category to show in front of th...
asked by 25.06.2018 / 16:34
1
answer

Select from cursor

I'm trying to do a procedure with the following mysql block: DECLARE done INT DEFAULT FALSE; DECLARE v_id INT; DECLARE R CURSOR FOR SELECT id...
asked by 29.06.2018 / 16:21
0
answers

Problem with connection to mysql database configured but not up

I'm trying to upload a local system but it is not connecting to the database. I have already made the settings. I'll leave the error below if you can help me thank you. hereandtheconfigurationinthedatabase line code 124 // Connect...
asked by 26.06.2018 / 23:13
0
answers

Variable within Select

In my web system I have the following select: SELECT round(SUM(peso),3) FROM mov02s WHERE modal = ('Carreta simples') AND data = ('2018-05-16') I'd like to use a variable instead of '2018-05-16'. The user who will choose the date. I thou...
asked by 28.06.2018 / 21:16
0
answers

java.lang.NullPointerException - Having add a user in the database but points this exception [duplicate]

Here is the code for the connection to the database, the user class, and the code already in the jframe: /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Te...
asked by 29.06.2018 / 00:25
1
answer

Attribute for $ _POST loses information

I have an attribute called $nomeConteudo , which makes a select in my database and returns the value correctly, because through echo I check that the value is normal. Within a form, I need to send this value to my formaction. For alread...
asked by 03.09.2018 / 23:09
0
answers

Access denied for user

I'm trying to generate some pages through a program called PHP Generator for MySQL and I'm getting an error message that is not possible, the site usually accesses with the Host passed by the hosting, but in error I see another number. No...
asked by 22.06.2018 / 20:00
1
answer

Insert, sum and display value (in real) using PHP and MySQL [duplicate]

Hello, I am a beginner in PHP and MySQL. I would like to have a form where I enter a value (in real, in the case), add with what you have already saved in the database, and finally display to the user the result of this calculation. It's qu...
asked by 23.06.2018 / 01:47