Questions tagged as 'mysql'

Tagged questions
1
answer

How to insert the value of a checkbox inside my mysql table?

I have a table of requests and what I want to do is an UPDATE that when I check the checkbox of several of them, I update the database that all the selected ones are en route. but I do not understand how to capture the multiple values of the che...
asked by 29.05.2018 / 20:29
0
answers

Problems to remove a record from a table with ajax?

You see I am trying to delete the record of a table with Ajax, this table is made through DataTable, however the delete button does not want to work, it throws me the following error: ReferenceError: BorrarSeccion is not defined Here I...
asked by 30.05.2018 / 18:03
0
answers

How to insert checkbox inside my mysql table?

I have a table of requests and what I want to do is a UPDATE that when I mark the checkbox of several of them, I update the database that all the selected ones are en route. Launches me an error:    Notice: Undefined variable...
asked by 30.05.2018 / 17:54
1
answer

Multiply 2 Columns and Add to the MYSQL End

I would like you to help me, I have 2 tables, and my intention is as follows, I write it in the image: This is the query that I have: $query = "SELECT Nombre, Cedula, sum(HorasTrabajo) as HorasTrabajo, sum(VC) as VC, ValorVC, sum(VR)...
asked by 30.05.2018 / 22:12
1
answer

Get the id of a database column

I am trying to find the id of a sale in order to update the detail table Sale. This when that sale has already been charged. I have a function in this way, in the sale table it looks for and updates the id of the sale but in its detail it doe...
asked by 21.06.2018 / 18:50
1
answer

Stored Procedure Laravel

How do I insert records into two related tables from a stored procedure in laravel? That is, register the user and then retrieve the id to insert information in another table.     
asked by 31.05.2018 / 02:00
0
answers

PHP foreach Group and add results

I have the following case: I need to group results of a query in the field RS.id_servicio, according to an array and add the results of the fields RS.servicio_cantidad and RS.servicio_preciototal. I leave the code of what I did, the result...
asked by 29.05.2018 / 16:29
0
answers

How can I run .php file in response to an event

Hello, I'm all doing a job to finish the DAG CFGS and I want to add one thing to the project that I do not know very well how to tackle it. To summarize I have a website hosted in a hosting, a database in said hosting and a desktop program in...
asked by 01.06.2018 / 12:06
1
answer

Error UPDATE with PDO

I'm trying to update the data, but when I update it, I change the user_id, but I want to continue saving it. Function, public function actualizaPagador($id_pago,$id_usuario,$pago){ $db=BaseDatos::conectar(); try{...
asked by 01.06.2018 / 09:57
0
answers

mysql error installing a post pos

I'm trying to configure unicenta but I get the following error, the database is created in mysql but it's like I do not have access to help please. p> [     
asked by 29.05.2018 / 16:08