Questions tagged as 'mysql'

Tagged questions
1
answer

Problem displaying items in a qtablewidget

Only the first two rows of the table are populated, but the row numbers of the table are filled as per the query result, and in print displays all the items normally. def escreveArquivo(self): con = MySQLdb.connect(host="localhost", user="...
asked by 09.10.2017 / 03:31
1
answer

How to insert an undetermined number of users into an SQL database? [closed]

Hello everyone, I'm a beginner in PHP and SQL, I need to make a kind of form that the person informs how many people want to register, does anyone have any idea? I can only do this with a fixed amount of variables     
asked by 15.02.2018 / 02:37
1
answer

How to create desktop client application for database access without exposing security information?

I have already done web application with access to MySQL database via PHP and I know that the configuration files for access to the database are on the server side, only the necessary data is returned to the user's browser, user does not have ac...
asked by 04.11.2017 / 02:25
1
answer

While in While PHP Pdo [closed]

I would like to know how to do a while within another ... Ex. I have Categories and items within the category. Categoria 1 | Item da categoria 1 | Item da categoria 1 Categoria 2 | Item da categoria 2 | Item...
asked by 28.04.2017 / 21:48
1
answer

Looking for separate words in the same string in MySQL

My question is relatively simple, but I could not find an answer that really helped: My user searches for a name on a form: Fulano Silva The record in my bank is like So-and-so of Tal Silva SELECT * FROM 'dados' WHERE 'nome' LIKE '%"...
asked by 16.03.2017 / 18:29
1
answer

Convert image size before saving in BD

I would like to increase my processing code: // Local onde imagem vai ser salva $_UP['pasta'] = '../../media/'; // Tamanho da imagem $_UP['tamanho'] = 1024*250; // 250Kb // Exrensões permitidas $_UP['extensoes'] = array('png', 'jpg', 'jpeg', '...
asked by 22.06.2017 / 19:39
1
answer

How to update data without auto refresh, through PHP and Ajax functions?

Hello, I'm a beginner in PHP and the web world and I'm doing a project with hardware (NodeMCU, MPU6050, LM35) where the data read by the sensors is being sent to a server, and on the client side the data is being presented in a table and a graph...
asked by 18.07.2018 / 14:33
3
answers

Calculate the average of all records in a table and update the column in MYSQL

I need to make a Query that passes all records in the table and update the rate_general column (this column is the average of the rate_food + rate_service + rate_price + rate_environment / 4 notes) of each record, how to do this? are 20,000 reco...
asked by 03.08.2018 / 20:13
1
answer

has how to execute a query within a user-defined function in php?

I have code like this: function apagar(){ $conexao = mysqli_connect('localhost','usuario','senha'); $db = mysqli_select_db("banco"); $delete = mysqli_query("TRUNCATE table sap_reportes.zempe019"); return $delete; //r...
asked by 11.04.2016 / 14:11
2
answers

for () is showing the same value as the array

Good afternoon, I'm trying to make a for () that shows the values for the current category. I use a function that takes the company and the category and selects the amount of records to display. Soon after, I use a similar function to show the p...
asked by 12.04.2016 / 20:07