Questions tagged as 'mysql'

Tagged questions
1
answer

Search recordset by date

I'm currently creating a Java / Mysql Desktop program. When inserting in the database, the table is very simple: id - dataInserido - códigoProduto - qtd I would like, by means of a SQL, to group the last records entered on the same date in...
asked by 29.05.2017 / 14:16
2
answers

A separate city query sql

My sales chart marks: city for which the sale was made, date and time of sale. I would like to pull all sales sorted by date and time, but with a specific city separately. For example: Sale 12 - Brasilia - 2017-05-29 10:00:00 Sale 20 - Brasil...
asked by 29.05.2017 / 16:07
1
answer

Transform varchar to float

I made a code that takes data from the DB to generate a graph with matplotlib , but the data in the DB is as varchar and for data creation it must be in the format% with%. How can I do the conversion? # -*- coding: utf-8 -*- import MyS...
asked by 29.05.2017 / 22:31
1
answer

Error when trying to fetch from an HTML form DB MySql information

I'm trying to search through information passed by the user. However, when I click send, it gives an error. FollowmyFormcodeandPHPcode.1)HTML<!DOCTYPEhtml><html><head><title>BuscadaPessoaIdeal</title></head>&...
asked by 30.05.2017 / 05:06
1
answer

Select extreme values of a certain range in MySQL

I need to collect only the extreme 'id' values for each given time range. According to the data below, I need to collect the ids 63 and 67 for the time of 00:45:22, 80 and 84 for the time of 01:15:26. How to proceed? id n hora data...
asked by 07.07.2017 / 20:01
1
answer

Form with $ _files does not save the file in the folders of the site [closed]

Hello, my project has a form where an image can be sent, it saves the form data in the BD but does not insert the image in the files. can someone tell me where my error is? <?php session_start(); include_once("../conexao.php"); $nome = $_P...
asked by 18.05.2017 / 22:04
1
answer

Call to a member function fetch_object () on a non-object

In the following code, the following error occurs, which I can not understand why:    Call fetch_object () on a non-object on line 21 <?php require('config.php'); if (isset($_POST['email'])) { $email = stripslashes($_REQUEST['emai...
asked by 21.05.2017 / 18:58
1
answer

Draw system

I'm intending to make a sweepstakes system on my site. I read some questions (including one that I really liked what was this one ) and I noticed people saying that X Cities could never be raffled, while Y Towns raffled several times. The qu...
asked by 20.05.2017 / 18:59
1
answer

How to make a modal confirmation of registration?

Good evening guys, I have a question about modal. I have an address confirmation form, however I have sent my data via bank, so alright, the problem is: I would like to know when I click on the confirm button as I do for him to return me a modal...
asked by 12.05.2017 / 03:42
2
answers

I connect in the database but the values do not change when I give UPDATE MYSQL Qt C ++

The data is loaded into the table, so I change the data in the table, when I click the button to update, I get the data (even the changes) and save it to the variable, but it seems that when I enter the sql query nothing happens . I need to be ab...
asked by 08.06.2017 / 12:51