Questions tagged as 'mysql'

Tagged questions
2
answers

Will not let me connect to mysql using mysqli

The code is as follows: $logID = checkParam($_GET["id"]); $database = mysqli_connect($config["db_server"], $config["db_user"], $config["db_password"], $config["db_name"]); if($database) { if($logID != null) { $log = $database-...
asked by 02.05.2018 / 19:14
1
answer

What is the error in this MySQL-PHP code?

I am trying to extract the value of a form so that it is added to a value of a row in a table in mysql, by means of a string that extracts the value of a query and this value is used to update the information of the record, but it does not. What...
asked by 02.05.2018 / 04:09
1
answer

Verify if you have a foreign key and if not delete it. Codeigniter

I have my table proveedor with a field called status 1 active 0 removed, I only update when removing delete: $data => array('status' => 0); $this->db->update('proveedor',$data); Try changing the update to del...
asked by 01.05.2018 / 23:45
1
answer

Trigger does not update the field

Greetings friend I created a Trigger but it does not update me, what I would like to achieve is the following when you make an insertion in the advance table I update the amount that is in the table transvalue example if in amount_trans_values_c...
asked by 14.07.2017 / 15:48
1
answer

Help with Mysql query?

I have two tables, a Sales, and Other Subscriptions_sales, the sales of the clients are saved with their total value and everything is on credit in the day several sales can be made to a client as no, the client can pay to the total balance you...
asked by 29.10.2017 / 01:13
1
answer

Notice: Undefined variable: query_mysql in [closed]

<?php include 'connection.php'; //dame tareas para el combobox function dameproducto(){ $consulta_mysql=" SELECT tbproducto.nvchproducto, tbproducto.intidproducto, tbproducto.nvchcantidad...
asked by 18.04.2018 / 15:17
1
answer

How to insert the id that was generated from one table into another in PHP AND MYSQL?

Hello community today I have a small problem that I have tried to solve but I do not get to the point, I read that this has nothing to do with the database but with the programming that I have in php and well, I have some tables relate example:...
asked by 29.04.2017 / 00:49
1
answer

Problem MYSQL sql_mode = only_full_group_by

When I make queries with some tables I get this error. (In ubuntu)    this is incompatible with sql_mode = only_full_group_by My teacher says it's an installation error .. Thanks for the help     
asked by 29.03.2017 / 08:12
1
answer

Help with array sample error in PHP

I have to consult a MySQL database (Server version: 5.5.55-38.8-log - Percona Server (GPL), Release 38.8, Revision 11f5bbd) that carries the barrels of a brewery.  The fields are few and simple: barrel number, lot, location and date of last move...
asked by 23.08.2018 / 01:28
1
answer

Error with query adding fields from different tables in MySql

What I'm looking for is for me to add up the total amount of each field and show it to me but what it shows is a text, I do not understand why this happens CODE: SELECT totales_bonos.idEmpleado, 'bonos.pmonto' Bonos,...
asked by 24.04.2018 / 07:16