Questions tagged as 'mysql'

Tagged questions
2
answers

Problem with MySQL discontinued for MySQLi [duplicate]

I have a problem on my site, it all started after I received a MySQL discontinuation message, and they asked me to change it to MySQLi, after I changed a series of codes appeared on my page, what should I do to to fix the errors? The initia...
asked by 31.10.2014 / 19:42
1
answer

Values that undergo calculations, if you store the value with the calculations in the database?

I'm developing a system where a product undergoes 3 changes before arriving at its final value: Individual Discount, Sale Bonus and Overall Discount I want to know if, I should store only the original value of the product in the database or if...
asked by 31.10.2014 / 23:23
1
answer

What causes "Call to a member function fetchAll () on a non-object in ..."?

I made a class to connect to the database using PDO and at the time I get the data from my table it gives this error. This is the code: require_once('../class/connection.class.php'); $db = conection::getInstancia(); $query = $db->query(...
asked by 10.06.2014 / 17:15
1
answer

Field 'lastiplog' does not have a default value

I'm having this error while registering Field 'lastiplog' does not have a default value: Code Register.php <? ob_start(); session_start(); ?> <left><left></left></left> <? include('header.php'); ?> <secti...
asked by 07.06.2014 / 16:48
2
answers

Java - MySQL Export and Import DB

Good afternoon. I created a DB in MySQL with Pizzaria name. I've tried several ways to create DB backup but I did not succeed. The last code I tried was: try { File file = new File("Backup"); file.mkdir(); String nomeBkp = tf...
asked by 17.06.2014 / 17:33
1
answer

Problem inserting data php mysql ID

I have a problem inserting data into mysql due to table id. Tb_Details_worker: id, Name, Function $sqlinsert = "INSERT INTO tb_detalhe_trabalhador VALUES ('','".$Nome1."','".$Funcao1."')    Error: Column count does not match value count...
asked by 11.06.2014 / 22:56
1
answer

How do I get foreign key values in a JFrame form

I'm creating a form in JFrame to insert data into a table that contains two foreign keys (these keys are not automatically generated). What do I have to put in the insert to get the foreign keys? public void inserir(Tratamento tratamento) {...
asked by 25.05.2014 / 16:47
2
answers

Requesting to download file in the middle of execution

I have a small problem, I have a PHP run that generates an average of 34,000 insert's in MySQL, this being done via stored procedure . But when I run it, it will run for about 5 minutes and nothing will ask you to download the file XPTO...
asked by 16.10.2014 / 14:46
2
answers

Get messages sent and received from MySQL

I'm developing a personal messaging system and I need to list the messages I've received and the messages I've sent, but I'm having difficulties, because the code I've just got can pick up all that I've sent or all that I've received and never b...
asked by 22.09.2014 / 19:48
1
answer

Error in class code connection function

I'm having trouble, see the code I made: <?php class banco { public function __construct() { $banco_hostremoto = "127.0.0.1"; $banco_hostname = "localhost"; $banco_usuario="root"; $banco_passwd="";...
asked by 06.08.2014 / 14:59