Questions tagged as 'mysql'

Tagged questions
0
answers

Select VIEW returns zero

I made a simple login screen in the local environment (xampp) and it works perfectly, without any error, however, when uploading to my web server (both run PHP 7.1), it does not work, it only generates the error message login and password. After...
asked by 25.05.2018 / 12:52
1
answer

Registering form data with equal name input PHP

I meet: implement a form this has several inputs with the same name I need to insert the data into the database I intend for the moment: create a record for each platform user The form has multiple fields that link...
asked by 25.05.2018 / 13:18
2
answers

Is it possible to insert and remove at the same time on the same php page?

Well, at the moment I'm doing a project with html, php and mysql and I'm having a little problem now. Going further to the subject: Assuming I have two tables: unconfirmed and confirmed, and what I want is in the php page to get pass the unc...
asked by 25.05.2018 / 13:11
0
answers

Error executing MySQL trigger - RESULT SQLSTATE

I made a trigger in mysql to save a query to a table that is executed whenever there is an update or it in the provider table. On my computer, localhost with xampp, it works normal, that is, every time I update or delete a record in the table...
asked by 24.05.2018 / 05:01
2
answers

Help Foreach stdClass

Good morning: D I need a light! I need to get all the 'ids' of users from a table and move to another table, but when I give a foreach it returns only 1 result like stdClass. Follow the code: $stmt = $PDO->prepare("SELECT usuario_id F...
asked by 02.06.2018 / 16:15
1
answer

Return database search data in JTable

I'm developing an interface that should return a JTable of the values of a mysql table. I developed the following method: public class Teste extends javax.swing.JFrame { private JTable table; DefaultTableModel modelo = new Defa...
asked by 27.05.2018 / 00:45
0
answers

Read number and turn into word [duplicate]

I'm a beginner in programming, and I've been trying to develop some things that could help in my day-to-day work with something in the market today that I have not found any system, and I've been learning a little and adapting one to myself ....
asked by 27.05.2018 / 02:44
0
answers

Compile error when adding "using MySql.Data.MySqlClient;"

When I add using MySql.Data.MySqlClient; the following error message appears: can not start debugging because the debug target 'c: \ users \ user \ documents \ visualstudio2018 \ Projects \ Application \ bin \ Debug \ Application.exe' is missi...
asked by 26.05.2018 / 23:47
0
answers

Combobox selects State and city search in MySQL

I need to solve this part, my intention is to select the state in the combobox the query below recognize the selected acronym and query in MySQL. function BuscaDAO(connection){ this._connection = connection; } BuscaDAO.prototype.getBusca...
asked by 27.05.2018 / 03:32
1
answer

MySQL - How to get results that were not found

I need to check which IDs were not found in the table. SELECT * FROM example_table WHERE id IN (123, 124, 125, 126, 127) Since of (123, 124, 125, 126, 127) , in the table I only have (123, 124) . The result I'm expecting is...
asked by 24.05.2018 / 15:45