Questions tagged as 'mysql'

Tagged questions
1
answer

PHPExcel, select sheet when importing data to mysql

I want to import data from a worksheet but from sheet 2 and I'm not able to. I indicated sheet 2 (index 1) as active in this way, but always goes to sheet 1 (index 0): $ objWorksheet = $ objPHPExcel-> setActiveSheetIndex (1); What will b...
asked by 24.05.2016 / 15:04
2
answers

Error executing a trigger

I have a problem with a trigger that when I make an insert of a record I want to automatically pass a value that comes by default is 1 to 0 only that is always giving this error. Can not update table 'receipts' in stored function / trigger b...
asked by 23.05.2016 / 18:57
1
answer

System posts - Tips [closed]

Hello, I'm trying to create a posts system for my site and I have an initial idea of how to do it, very basic. In the basics, I would have one that will send the text of a <textarea> to the database, along with the author, date,...
asked by 17.05.2016 / 05:09
0
answers

Compare text file with data in bank

Hi, I would like to know how to compare several txt files with MySQL, so when I create a txt file in the folder it does not re-insert the data of the other txt files in MySQL. I am using JNotify to run in time real and insert the TXT file data i...
asked by 09.06.2016 / 14:07
1
answer

Doubt with PHP and textarea

all blz? I have a small problem. I have to send a text with paragraphs and line breaks, via php pro bd, and on another page draw the text with the paragraphs and the correct line breaks, what can I do?     
asked by 11.06.2016 / 00:45
1
answer

Wrong parameter type error in mysql_fetch_assoc ()

   Warning: mysql_fetch_assoc () expects parameter 1 to be resource, boolean given in C: \ xampp \ htdocs \ NEW \ admin \ alterfotos.php on line 16 $id_imagem = trim($_GET['id_imagem']); $dados = mysql_fetch_assoc( mysql_query("SELEC...
asked by 18.09.2014 / 01:56
1
answer

Registration amount per MySQL Data

I have the following scenario. I have a sales table, there is a data_vendas (datetime) field and a cliente_id Another client table, with the fields id , nome , data_cadastro etc. What I need to do is via...
asked by 19.06.2016 / 07:01
0
answers

Commit and Mysqli Rolback

Well, I'm using PHP's Mysqli class and I came across the following situation ... I have two tables, table A is the main one and table B is the daughter until then it is ok, what I need to do is to treat the commit and rollback to avoid failur...
asked by 20.06.2016 / 06:08
0
answers

Login and password verification

I need help checking for a login and password. If the login and password that I type in JTextField are the same as the one I have in the bank, I can not allow the registration, what I'm looking for is not a validation, but just a routi...
asked by 02.05.2016 / 02:20
0
answers

Secondary Table Column Sort

Categoria Segmento 1 Atendimento 1 Tempo de espera pela peça 1 Preço 2 Atendimento 2 Negociação 2 Tempo de entrega do veículo 3 Atendimento...
asked by 02.05.2016 / 15:16