Questions tagged as 'mysql'

Tagged questions
1
answer

Syntax error in Insert Mysql

I can not solve the error below: Notice: Undefined index: HTML_cor_TAREFA in C: \ Users \ User \ Desktop \ pi Fe \ Order2 \ CadastraTarefa.php on line 14 You have an error in your SQL syntax; '', '', '', '', '', '') 'at line 1 (check the...
asked by 28.11.2017 / 12:40
1
answer

WildFly 11 does not recognize MySQL driver when deploying

I set up my Java Web project to use JTA when transacting with the Database. My project has 4 Maven modules, one is unique to the model classes and to the persistence layer. When I compile in Maven the result is success, but when trying to upload...
asked by 09.02.2018 / 03:07
1
answer

Can I create an event in PhpMyAdmin?

I want to create an event in PhpMyAdmin, where every day it implements +1 in a field of type int , but in my local server it works normally, in the hosting it says that I need the user super global , all right until then, the head I...
asked by 06.11.2017 / 07:23
1
answer

Average on the database in MySQL

Personal I have the following scenario in the database: Tables: mdl_question_attempts (slot, questionid, rightanswer, responsesummary) mdl_quiz_slots (slot, quizid, questionid) In the mdl_question_attempts table, attempts to resp...
asked by 03.11.2017 / 23:15
2
answers

Doubt with SELECT and SUB SELECT in MySQL

I have a question regarding SQL, I have never worked with sub-selects and I ended up getting lost with it. My SQL: SELECT CLI.id, CLI.nome, CLI.senha, CLI.email, CLI.cpf, CLI.celular, CLI.data_nasc, CLI.genero, CLI.data_cadastro, CLI.stat...
asked by 22.05.2018 / 14:54
1
answer

Insert multiple type file records into Mysql

I'm making a form, where you have a part of registering images for a photo gallery. In this field I use a script with a add field button so that a new field can be inserted for each photo <label>Galeria de Foto</label> <...
asked by 22.05.2018 / 20:47
1
answer

compare dates within the sql query

I need to compare the date entered in the bank +10 days with the current date and display the student that the current date is greater than the 10 days, but this within the sql query. Is there any function for this? I tried this, without success...
asked by 14.11.2018 / 14:29
1
answer

Loading login data into another subdomain

In the system I'm doing there are 3 panels, being a users table for each panel and the public site. When the user logs into any of the three panels, and re-accesses the public site, more information would appear. Summing up is a "sign in to see"...
asked by 02.01.2018 / 07:07
1
answer

Edit select showing bank value and showing other table options

   I have the table that registers a user (gr_entidade) and that has a connection with a user status table (gr_entidade_status). I want the edit form (editing_user.php) to display the value in the database, but I can see the other items in the t...
asked by 28.12.2017 / 14:51
1
answer

Error saving directory image with PHP

I made a page that administers a website that is responsible for including new lawyers in a 'bootstrap carousel'. On my machine it works perfectly, but on the server it is impossible to save the image that is loaded. I will explain: The image...
asked by 21.09.2017 / 21:00