Questions tagged as 'mysql'

Tagged questions
3
answers

Modal form validation using Bootstrap

I have the following question. I have a simple registry and I want to register a new registry and tell me: If the field is empty it shows me the message "Fill in the fields"; If the form field already exists in the database it shows "Dupl...
asked by 21.09.2015 / 20:11
3
answers

Select with WHERE condition with multiple values in the same column

I have two tables in my bank and I do the JOIN with them. One table is a list of people and the other list that person's characteristics. By logic there is only one person and each person can have several characteristics, so two tables. So when...
asked by 01.05.2018 / 17:02
3
answers

Receive array and write multiple rows in MySQL

I have the following form in HTML: <h2>Sessao 1</h2> <input type="text" name="ipl[]" class="span12 "> <input type="text" name="spot[]" class="span12 "> <input type="text" name="energia[]" class="span12 "> <inpu...
asked by 23.10.2014 / 07:17
1
answer

What character encoding (Collation) should I use in Mysql?

What is the most appropriate Collation for a database in Mysql that will store Portuguese language data?     
asked by 01.07.2015 / 01:31
4
answers

How to check if the user is online?

I'm developing a project in PHP and using MySQL as a database. I only have one question about how to chat: How to know which users are online right now?     
asked by 17.03.2014 / 18:08
1
answer

How do I receive a notification whenever there is a new record in a database table?

I need to receive a notification whenever there is a new record in a particular database table, what can I do to receive? If I make an Ajax request every time, I'll make unnecessary requests. Any other ideas?
asked by 04.01.2014 / 18:10
5
answers

Currency formatting to save in the database as DECIMAL

I am using a mysql database, the field format is Decimal (7,2) and it receives the salary value. Based on what the user types I store in the bank like this: str_replace(',','.', $_POST['txtSalario']) Substituting the comma by period....
asked by 06.02.2014 / 13:21
4
answers

MySql decimal value

I'm trying to insert decimal value into the mysql database, I wanted to put these values for example: 1.500,00 Thousands, hundreds and tens What kind of column should I declare?     
asked by 24.10.2014 / 01:44
1
answer

Local MySQL synchronization with remote

I would like to know if it is possible to replicate a local MySQL database with the remote. I use PhpMyAdmin and I do not know if it will be possible because I do not have a fixed IP to find the other one.     
asked by 06.07.2016 / 12:54
2
answers

Error updating the entire JAVA table

I am trying to perform a mass update to update all the prices of products registered in the system, adding the value passed by the user to the unit price of the product registered, according to the company entered in the system and the product c...
asked by 18.02.2016 / 14:03