Questions tagged as 'mysql'

Tagged questions
0
answers

Register that has been changed with Trigger

I'm doing a history of updating the records in my mysql database I have two tables in phpmyadmin equal, one that is in which I record data and the other just created called updateLogs where the trigger acts on the changes made in the first...
asked by 09.11.2018 / 09:45
1
answer

I want to extract the autoincrementable id when inserting the record

I need to save the id's in the variable $ last [], but it keeps me empty or zero. The sp_ins_ott_registro () is a sp that inserts in a table of 5 attributes, which are seen there and the AI. This way it returns zero to me. for (...
asked by 06.11.2018 / 06:04
1
answer

How to capture in an SESSION variable an element when clicking on it?

I do not know how to express my question but the issue is this, I'm doing a job for a course which I'm taking but I'm at a standstill, the work basically consists in making a simple "copy" of a social network, These are the requirements that the...
asked by 25.11.2018 / 23:46
0
answers

Save user id of web application in MySQL audit table

I have the following TRIGGER which inserts certain specific data for the purpose of auditing. I need that in the field Audit user the id of the user who started the session in the system and not the one in the database is saved. DELIMITER //...
asked by 26.11.2018 / 00:31
0
answers

MySQL - join 2 or more tables with null fields

Good morning, I currently have an online questionnaire which to qualify you I must make a union of 2 tables, however, since no person has selected a particular option there is no value to associate and this does not allow me to do the union of b...
asked by 26.11.2018 / 03:17
2
answers

sql query (mysql) and timestamp

I want to consult the results in a range of dates and perform joins. Currently my query is: SELECT fichapagos.cantidad, users.name as nombreRecibe, modopagos.nombre as tipoDePago, clientes.nombre as elCliente, conceptopagos.concepto as elC...
asked by 05.11.2018 / 20:17
0
answers

Help I try to create a record of an autoincrement value which is a primary key and is a foreign key

I try to enter a value register autoincrement but I get the following error    You have an error in your SQL syntax; check the manual that   corresponds to your MariaDB server version for the right syntax to use   near '"",' Jose Queza...
asked by 25.11.2018 / 22:29
0
answers

# 1055 - Expression # 1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

I have the following query: SELECT DISTINCT pedidos.id, pedidos.correlativo, pedidos.tipo_trat, pedidos.nombres, pedidos.apellidos, pedidos.estado, pedidos.token, etapas.estado_etapa, etapas.etapa, hijos.opcion, (SELECT COUNT(*) FROM etapas W...
asked by 05.11.2018 / 17:37
1
answer

validate user

Good I have a doubt I have made a login but the problem is that if a user has not logged in you can enter the page by putting the extension; How can I verify if that person has logged in and if he has not already sent him to login?? <?php...
asked by 05.11.2018 / 15:38
0
answers

display data from a mysql query in input text

good morning I'm trying to make a type search engine by rut which consists of the user entering the rut and displaying the user's values in the input text of an example form: name: felipe, email: felipe @ gmail. com etc so far it works fine for...
asked by 05.11.2018 / 13:23