Questions tagged as 'mysql'

Tagged questions
1
answer

I want to add all the points of all teachers and create a rank with the 3 best ones

I would like to add the points of the classes of all the teachers and create a rank with the 3 majors. My problem is being in QUERY SQL to return the data to my system. Follow the image of my bank.     
asked by 12.04.2017 / 18:04
1
answer

Error inserting MYSQL by data grid view

The code is as follows, I'm doing an insert from the values of a data grid view foreach (DataGridViewRow row in dgvCON.Rows) { MySqlCommand cmd = new MySqlCommand();...
asked by 14.06.2017 / 02:02
3
answers

Wrong encoding in MySQL when I enter through AJAX

I'm having trouble finding a solution to my problem. Briefly: I send data to a table, using a php file that does the querry, and an ajax call that sends all the values I need to the php file. When it is inserted in the table the accents of th...
asked by 01.02.2017 / 20:12
1
answer

What kind of Mysql data should I use to register random numbers for requests

Colleagues. I am creating a registry where a request number is generated for the user. The structure is as follows: $prefixo = "CAD"; $idCadastro = mysqli_insert_id($this->conexao); $rand = rand(100,999); $ano = date("y")...
asked by 15.02.2017 / 00:51
1
answer

Return values from a column of table X that has 1 code in common

I need to solve a problem. I have a table of responses of a poll where the answers made with checkboxes are in different lines with a common code, that of the question answered, example: cod_questao = 100 / cod_responses = 200                   ...
asked by 01.02.2017 / 18:15
1
answer

Problem listing data in JSP

I can not do the Data Listing. You are giving the "Error processing request", Servlet Path: /pages/dados.jsp Path Info: null Query String: null ... I do not know what it is. Grateful for any help. Note: I'm starting with the back end, my beach i...
asked by 19.05.2018 / 23:17
2
answers

how to do a search in mysql with php and return the data in each input?

My system has to do a search, using the cpf of a patient, then when he enters his cpf, he has to have a search in the bank, where the php will get all the information that the patient has with that cpf that he (ie he already has a registration,...
asked by 09.11.2017 / 05:33
2
answers

database only saving the password [closed]

This is my first post here, I've been following the forum for a long time but I never wanted to interact, today this will came along with a little problem ... To learn html, css, php and etc ... from tutorials, after countless failures...
asked by 14.11.2017 / 10:41
1
answer

How to do automatic dump in MySQL?

I have a simple system for managing a store that for now, in the testing phase, is running with a local server. I wanted to know a way to do the dump of the MySQL database automatically at the same time every day (eg late afternoon) using P...
asked by 23.11.2017 / 22:45
1
answer

Trying to get property of non-object

I have this form: <form class="login" name="login" method="post" action="../controle/usuario-controle.php?op=logar"> <input class="input" type="text" name="txtlogin" pattern="^([0-9a-zA-Z]+([_.-]?[0-9a-zA-Z]+)*@[0-9a-zA-Z]+[0-9,a...
asked by 18.10.2017 / 21:37