Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
-2
votes1
answer134
viewsLaravel 7, several variables in the same View
Good morning, I’m developing a little project on Laravel 7 and I’m having a little trouble. This is the first time I have used Foreign key and several variables in the same Controller and View…
-
-2
votes2
answers217
viewsNodejs and Mysql: Query 3 columns
I need to make sure that the user will not be able to register the registration: email, cpf or cnpj again. I have a code, which I can restrict email. How to implement the code to check in the table…
-
-2
votes1
answer122
viewsQuery error Warning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, Boolean Given in
I created a project in XAMPP where it is working perfectly. But when hosting on 000webhost, it emits this error. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given…
-
-2
votes1
answer55
viewsTake json array in ajax
Good afternoon, I have a problem to display the result in the json, I do an Insert of an array in the database with for, it inserts perfect in the database, but I’m not able to display the…
-
-2
votes1
answer32
viewshow to have a variable take a value from one page and move to another
I have this code below. <?php include '../conexao.php'; $sth = $pdo->prepare('SELECT * FROM comanda'); $sth->execute(); ?> <?php foreach ($sth as $res) { extract($res); ?>…
-
-2
votes2
answers74
viewsproblem in sending php form data to Mysql database
Hello, I am beginner in PDO and in my development of a form I can not send anything to the database and I can not identify the problem in my php form, someone could help me please? FILE…
-
-2
votes1
answer43
viewsHow to make a raise notification using ajax + php?
I’m just trying to increase the notification of an item. I want every time I add a new item to my cart, I have to see the cart notification increase number. in the javascript console I see that it…
-
-2
votes1
answer51
viewsKeep BD output when select with jquery
I have a form that shows the lines(departments) and the families(categories) of products. I’m trying to improve the register by populating the family combobox, so select the line, returning the…
-
-2
votes1
answer426
viewsUnknown column '' in 'Where clause'. Error mysql php
Below is the code I am using to try to make a login system, but it is failing Code: <?php $link = mysqli_query($con, "SELECT * FROM usuarios WHERE nome= $nome AND senha = $senha") or…
-
-2
votes1
answer36
viewsCheck if there are active products in this brand, if not, show brand
I have two tables in my bank, adm_marca and adm_produto, at the moment, is showing in my view all brands, regardless if there are active products or not, I need to show only brands that do not have…
-
-2
votes1
answer563
viewsPopular Chart.JS with Mysql data passed in the page render by an async function
Speak people, I’m wanting to popular a pie chart on my Dashboard page, but I’m not getting, can help me (I don’t want to use php, only javascript, jquery and html). Chart: Chart.JS BD: Mysql…
-
-2
votes1
answer78
viewsMenu with PHP and Mysql
I created a navigation system for my site. See: <nav class="navegacao" id="navegacao"> <ul class="menus"> <li><a href="#">Categoria 1</a></li> <li><a…
-
-2
votes1
answer133
viewsjava.lang.Nosuchmethooverthrow: No virtual method group(Ljava/lang/String;)Ljava/lang/String;
Oie I have a problem with an app in Android Studio, it compiles and runs on my phone, but when I click on some button it gives this error. Error: E/AndroidRuntime: FATAL EXCEPTION: main Process:…
-
-2
votes1
answer94
viewsError 1064 Mysql Workbench
I am a student of Analysis and Systems Development, and I am having trouble with the creation of the script below: the error shown is as follows:: Error Code: 1064. You have an error in your SQL…
-
-2
votes1
answer85
viewsHow to perform two functions from the same table
I have this Function to group values of two tables "sales" and "customers", but in addition to grouping this information, I need to perform a search in the database according to the parameters. I…
-
-2
votes1
answer42
viewsDifferent performance using limit less than 100 and greater than 100
I have a subselect that filters 16 records and there is a limit of 100. This consultation results in a time usually of 1:20 ~ 1:40 minutes. But when I change the limit to a number greater than 100,…
-
-2
votes1
answer34
viewsJavascript with async-await
I am using async-await in the SQL query function in the Model and I use the MVC standard. The problem is that when executing the function (select SQL) in the model it is executed but the return is:…
-
-2
votes1
answer35
viewsBase Bi - MYSQL
It’s a layman’s question for being a situation I hadn’t encountered before. I have an instance of RDS Mysql with at least 22 databases. The current company needs to build a bi-model to consume the…
-
-2
votes1
answer232
viewsError while trying to connect Mysql database to eclipse using JDBC
I’ve tried some solutions, I’ve reinstalled Mysql and Workbench, but it doesn’t seem to accept my password. It just keeps giving the same error. Note: I did not change the user name in the database,…
-
-2
votes1
answer30
viewsValidation of data with JS but if there is an error remain in the html page and do not proceed to the php page
Good afternoon I would like to know if someone knows how, after making the validations of the data in javascript show the error messages "failed to give the password" etc, or if everything is…
-
-2
votes1
answer108
viewsUpload Multifiles with Multer , express , nodejs and query to Mysql
How to query the name of two different images for mysql? I’m using a woman to upload more than one image, and the code I used is working perfectly. The images are loaded into my briefcase imgpost.…
-
-2
votes1
answer73
viewsMysql PHP query with filtering by various criteria
Good morning, fellas. I have a church membership database. I made a table to view these records, but as my BD has 39 columns, I took only the most important, and at the end of the line I put a link…
-
-2
votes2
answers57
viewsHow to make two queries using the same Mysqlconnection?
I have the following code snippet: using(MySqlConnection conn = new MySqlConnection(conexao)){ try { string consulta = "SELECT * FROM tb_Cliente WHERE ID_Cliente IN ("+listaClientes+")";…
-
-2
votes1
answer35
viewsCreate a Trigger with JOIN to duplicate the data
CREATE TRIGGER `copiadados`AFTER INSERT ON `wp_postmeta` AS DECLARE @nome NVARCHAR(50), @email NVARCHAR(50), @adicional NVARCHAR(255) SET @nome = (SELECT meta_value FROM wp_postmeta WHERE meta_key =…
-
-2
votes2
answers49
viewsHOW TO TREAT EMPTY VALUES IN SEVERAL COLUMNS?
I have a TB that has 15 telephone columns, where several rows are empty. I need to turn these 15 columns into only one. Using UNION ALL and putting a condition in WHERE to get rid of the empty…
-
-2
votes1
answer19
viewsList and count results that repeat within an array
I have the following table ID| nome | Tipo 1 | Teste, João, Maria | Indicação 2 | Teste, Maria, José | Projeto de Lei 3 | Maria, José, João, Teste | Indicação 4 | Maria, João, José | Denúncia I…
-
-2
votes1
answer126
viewsHow do I filter queries from my database by Python? Using mysql
I am making a system of "inventory", in it we have in the second screen a search screen and the third the screen that shows the results of the search. This search is a database search, but for now…
-
-2
votes2
answers51
viewsError connecting php to Mysql - Connection failed: No route to host
Hello I have a php site where he accesses the Mysql database everything worked perfectly until today the afternoon when out of nowhere he started to bring me the error whenever he tries to access…
-
-2
votes1
answer15
viewsShow database values in a Jlist on screen
Hello, I am creating an application that needs to show some registered elements in a list, which I will show through Defaultlistmodel. Unfortunately within the application it recognizes the elements…
-
-2
votes1
answer31
viewsCreate Query with Mysql
I’m having a problem, I have a search form with two inputs, and I want to build a query that will query either by employee number or by sector code. how to query? follows the code below. I thank…
-
-2
votes1
answer28
viewsYou’re not saving the picture on the way
I’m creating a field of ImageField no Jango, but when I put to save, it saves in the bank the name of the image but does not save the path to the image. models: class Cliente(models.Model): photo =…
-
-2
votes1
answer129
viewsQueries Mysql database
Currently I have studied SQL Server and My SQL in college, but having a lot of difficulty in making queries in the database. The bank has 3 tebelas (aluno, discuplina and matricula) Show the total…
-
-2
votes1
answer44
viewsHow to bring, in different columns, values from the same column of another table, with different conditions
Hi, what I need is something like this: SELECT users.[UsuarioId] , users.[Ativo] , users.[TipoFuncaoUsuarioId] , users.[ConcessionariaId] , users.[DataAdesao] (SELECT contato.[Contato] Celular FROM…
-
-2
votes1
answer26
viewsHow to render an asynchronous function in reactJS?
My problem is this: I have an asynchronous function that makes a mysql request and, depending on the result of the request, returns a different DIV. const GetData = async(idAluno,disciplina) => {…
-
-2
votes3
answers45
viewsSymfony Component Httpkernel Exception Methodnotallowedhttpexception The PUT method is not supported for this route. Supported methods: GET, HEAD, POS
My Blade <form action="{{route('Update.afiliados', $users->id)}}" method="POST"> @csrf @method('put') <button class="btn btn-block btn-flat btn-primary" method="post"> <span…
-
-2
votes1
answer26
viewsMYSQL query date range and any other date in the same query
I have the following dates as an example: 2021-06-01 2021-06-02 2021-06-03 2021-06-04 2021-06-05 would like to display 2021-06-01, 2021-06-02, 2021-06-03 and 2021-06-05 I am trying to do it this…
-
-2
votes1
answer31
viewsTrigger to check for data in another table
I’m trying to create a Trigger, using the following tables: The Trigger will be in the Table Carrier, and only need to check if in City.codcidade, there is some value equal to the…
-
-2
votes2
answers53
viewsHow to check if a variable received a new python value?
I have a Thread from a function that inserts data into the database and another Thread that every second receives a new value for a variable, however it may be the same previous value only "new". I…
-
-2
votes1
answer46
viewsCheckebox with database data
I rephrased the Personal Question I need to update vehicle, be presented all drivers who can drive the vehicle,( as well as in the registration table), but marking those who were chosen by the user…
-
-2
votes0
answers43
viewsQuery of SQL Count
In a certain algorithm routine, the following data is recorded in a table: Color Changed Led (Are two possible leds, code 2 to yellow, 3 to red) Reason for the Change (These are pre-defined reasons…
-
-2
votes1
answer23
viewsLaravel - Use JOIN + COUNT
I have two tables, one for users (users) and another for companies (Companies). I need to select the data of each company and know the amount of users per company. This select in mysql works the way…
-
-2
votes0
answers34
viewsSelect two tables at once
I got the city and neighborhood tables How do I display the city and neighborhood it belongs to ? tried to use a INNER JOIN but it didn’t work ? in that inner join has a $_GET that should fetch the…
-
-2
votes1
answer31
viewsSQL - COUNT and GROUP BY doubt
I have the following question: Select the first name (first_name) and title of the film (film) of all(s) the actors/actors/actresses (actor) associated(s) with the movies of the (Category) comedy…
-
-2
votes0
answers40
viewsProblem with Count() in the Laravel
I need to show the number of records belonging to a registered mobile number. in the log table have the columns NUMBER and MESSAGES need to show the user the amount of messages that the registered…
-
-2
votes0
answers23
viewsReturn larger date without repeating ids
I need to return to the highest date without repeating id. I need a table with: Customer id Date of last download Number of text messages sent to the ID Date of last text message Date of the signup…
-
-2
votes1
answer13
viewsSequelize returns error during api test
Good afternoon friends! I created a Rest api based on a youtube video using Node, express and sequelize. When sending an empty post, for one of the routes without access to the bank, I get return…
-
-2
votes0
answers25
viewsTable with foreing key does not send data to Phpadmin
I’m still a beginner in mysql and php but after some studies I’m trying to create a system and in case I’m having trouble with FOREING KEY, I have two tables a 'tb_students' and 'tb_notes' but I’m…
-
-2
votes0
answers18
viewsSolution for logging and logging access level with php and mysql
I am developing a website for my final project, but I am having a great difficulty related to access levels, in this site there will be 3 levels of access (student, teacher and company) all…
-
-3
votes1
answer236
viewsSearch between dates using two columns
What is wrong? SELECT ID_Contrato_Reserva, DATE_FORMAT(STR_TO_DATE(data_ini,"%d/%m/%Y" ), "%Y/%m/%d") AS dataIni, DATE_FORMAT(STR_TO_DATE(data_Fim,"%d/%m/%Y" ), "%Y/%m/%d") AS dataFim FROM…
-
-3
votes1
answer182
viewsHow to return the total value of items in a table?
I want to know how to return the total value of items, I use the mysqli to connect to the bank. Table ec_despesas have the following fields: (more details of the structure in this image) id, aba,…