Questions tagged as 'mysql'

Tagged questions
1
answer

mysql search with only one of the selected fields

I have a question about how to organize this information, I have two selects in my code, that the user chooses the two, generates the table looking for who has the two information, but I would like the search to be done even if the user to selec...
asked by 14.03.2018 / 16:21
0
answers

Categories and subcategories in a single SELECT

I have the following table structure: CATEGORIAS id titulo SUBCATEGORIAS id id_categoria titulo I wanted to know if there is a way to bring all categories and subcategories at once into a single select as a two-dimensional array sort of li...
asked by 14.03.2018 / 15:33
0
answers

Write an array with a loop in the bank with ajax and php

I would like the help of you to insert into the bank with ajax, being that I have to do 3 insert, in 3 tables in the bank. There are several questions in a single insert, so it's an array. The answers pertaining to each question are also an arra...
asked by 14.03.2018 / 20:56
2
answers

View and modify items in the database with php

Ineedtodisplaythedatabasevaluesintheseinputfieldsandalsoeditthem,Ialreadyhavethecolumncreated,withTitle&AdsCodetablenameissite     
asked by 07.03.2018 / 19:32
0
answers

Statistical Functions in MySQL (eg Oracle)

Is it possible to use statistical functions in MySQL, such as those already in Oracle? Examples:    OVER / PARTITION BY    CORR    DENSE_VAR    FIRST    LAG    LAST    RANK    DENSE_RANK    I know they do not exist natively, but c...
asked by 08.03.2018 / 20:51
0
answers

Node.JS does not save the data of a form

Good afternoon everyone! I'm trying to save the data from a form, and I have no idea why it's not saving. I remember that I would have to use a stringify, or something like that, but I can not see it. Below are the view (ejs) and the index.js in...
asked by 08.03.2018 / 20:06
0
answers

Error registering data in the database

I'm having a hard time inserting some data into the database. At the time I click on register, the message appears at the end of the "error registering" code. I've reviewed the code and I've rolled the code almost completely and I can not get a...
asked by 08.03.2018 / 21:41
1
answer

How to make a cascade insert into several tables at once, when one works right the other?

I have a table with the name of the questionnaire, questions and answers. I need to do an insert in the questionnaire table, then receive the id of the questionnaire table, when to insert the questions I insert with the id of the questionnaire,...
asked by 08.03.2018 / 19:56
1
answer

How to echo the value of a variable from the query result

To automate my process of generating a JSON , I save the name of the variable in the database (Ex: $teste_value_1 ). In my file.php I have the value of this variable, for example $teste_value_1 = "Isso é um teste"; . Then I...
asked by 08.03.2018 / 19:56
0
answers

mysql php workbench Character Encoding

I have php system 5.4 and mysql configured in the default charset (not in UTF8) the tables are configured as UTF-8. When saved to the database and displayed on the system the information appears accented correctly. However when I open the...
asked by 22.03.2018 / 16:27