Questions tagged as 'mysql'

Tagged questions
1
answer

Using ResultSet, converting String to Array

I'm trying to convert some data that comes from DB into an Array, using ResultSet to select DB data. In the code below it does not give any error though. If I try to use one:    System.out.println (x [0]); It does not show the first data,...
asked by 23.04.2015 / 21:51
1
answer

Doubt about 'NUMA' (non uniform memory access) in Microsoft SQL Server

Can anyone help me to understand the concept of 'NUMA' in Portuguese and their respective characteristics sff? I've found websites in English, but I still do not understand!     
asked by 27.05.2015 / 02:40
1
answer

Trigger that feeds a table with information from the other MySQL

I have a database in MySQL with the Inventory, Sales and SalesIt tables. When you perform a sales record information on the Sales and SalesItems tables, but I want to get an information from the Inventory table and register on the Ite_Venda....
asked by 31.03.2015 / 14:05
0
answers

error while doing id query in Sql table

I am having an error when querying the id in a table, I am developing a system of friendship between users and the error is as follows:    PDOException: SQLSTATE [23000]: Integrity constraint violation: 1062   Duplicate du champ '0' pour la c...
asked by 01.04.2015 / 21:54
0
answers

Duplicate data in DB when doing Ajax request

Every time I try to register a new comment it duplicates in my database. It loads the comment through ajax, but after I refresh the page the duplicate comment appears. <?php require_once("classes/dao/UsuarioDAO.class.php"); //Chama a classe...
asked by 02.04.2015 / 04:08
0
answers

Mass mailing

I need to send bulk emails with PHP, how can I do this without having to wait for PHP to finish sending the emails to only after reloading the page? For example, I have to send 100 emails, but I want to continue browsing my site while it's st...
asked by 12.05.2015 / 04:45
0
answers

Webservice (PHP, MySQL, JSON) no response

I have a webservice in PHP with MySQL database and getting answers in JSON. It is working normally, but I have a problem using the following query: SELECT podcast.id, podcast.nome, podcast.descricao, autor.nome, categoria.nome_cat FROM po...
asked by 10.05.2015 / 00:12
1
answer

Syntax Error in MySQL Procedure

I have the following Stored Procedure. When you run it, the syntax error 1064 is not returned as in the image below. What am I missing?     
asked by 18.03.2015 / 17:11
2
answers

Add a fixed word to a friendly URL

Good evening, I'm doing a search and I'm having a problem passing the value that is written in input to another page where the result will be displayed. Url example I'm trying to pass values http://exemplo.com/locais/pesquisa?q=...
asked by 18.03.2015 / 02:35
0
answers

php secure login attempts system

I would like to know how you make a secure login system. Because it is difficult to get information from the user that will try to login: Ex: echo getenv("username").'<br>'; echo getenv("REMOTE_ADDR").'<br>'; $hostname = geth...
asked by 19.03.2015 / 16:00