Questions tagged as 'mysql'

Tagged questions
0
answers

Error executing trigger after insert

Trigger:    INSERT INTO payments SET identrada = NEW.id, idusuario = NEW.idusuario,   idcuenta = NEW.idcuenta, payment = 0, description = 'Entrada', sinpagar =   0, form = 'S / P', time = NEW.hour, date = NEW.date, postdate = NEW.date My...
asked by 21.04.2018 / 18:43
0
answers

Approve conditions written in PHP to MySQL SP

Good morning or nights for some. The following block of code works correctly and is written in PHP with the help of the Yii2 framework: $subQuery = (new \yii\db\Query) ->select([ 'p.FK_DOCUMENTO_ODC',...
asked by 13.04.2018 / 14:25
1
answer

Auto complete several text boxes 2

I found an example which works perfectly to auto complete several input text from a query to mysql. The example consisted of 5 input and I added a sixth. When doing the modification the sript was still working as in the beginning, it only add...
asked by 15.04.2018 / 16:36
0
answers

Consultation on passing Monoclonal system to multiclient

How are you doing? In this opportunity I would like to ask you about an application of your own that I am expanding. Initially I began to develop the idea of this system, as a kind of practice in my php course, and thus expand my knowledge. Now...
asked by 17.04.2018 / 22:34
1
answer

How to create a trigger that updates the fields of one table with another?

This is my first question here, well to the point, for the class of Databases II I need to create a trigger in MySQL that when inserting data in the student table the table of student support is also updated, I know it can be a Maybe it's very X...
asked by 14.04.2018 / 18:28
0
answers

Error mysqli_fetch_array ()

Error:    error mysqli_fetch_array () expects parameter 1 to be mysqli_result, boolean given in <?php if ($_SERVER['REQUEST_METHOD'] === 'POST'){ $conexion = mysqli_connect("localhost", "root", "","henkel"); $consulta ="SELECT DIS...
asked by 12.04.2018 / 19:47
2
answers

Subquery within a javascript and mysql callback

Good to all I try to get the details of a foreign table after making a query, I do a for cycle to go through all the results of the main query and make a sub query with the data of the foreign id, this from a server in express using mysql as sgd...
asked by 09.04.2018 / 20:36
0
answers

Insert data POST symfony3 method

I'm doing an app with symfony3, I have the CRUD methods in the controller, but I can not insert data in the DB, for now I'm just doing the backend and testing with Postman. This is the method that inserts: /** * @Route("/event/new", name=...
asked by 10.04.2018 / 01:34
0
answers

Insert in bd with cakephp

Each time I reload the page, it re-inserts the data, but when updating the page, the input left me with the information that had been entered, so I had to clean the input with js when loading the page. $(document).ready(function () { $("....
asked by 09.04.2018 / 21:51
1
answer

Problems with nested combo box

I have a combobox nested to another combobox and it works only on the first line; it turns out that I want the combobox to work for me in the other rows (below) that are the result of a request to the database, I hope I have explained, below a f...
asked by 18.04.2018 / 19:58