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
-
-1
votes1
answer89
viewsProblem insert into Mariadb database images
I am using Mariadb and a LONGBLOB field to store my images, when I have insert small images (300KB or less) normally inserts, however larger images that this gives this error here: Mariadb [-1]…
-
-1
votes1
answer32
viewsDelete in Foreign Key
I have three tables: Students, Courses and Teachers. I am trying to run a delete in the Courses table, but it has relation to other tables. How do I perform the deletion? create database flexPeak;…
mysqlasked 5 years, 8 months ago Guilherme Carvalho 55 -
-1
votes1
answer36
viewsHow To Make My Save, Change My Database Data
Guys, I’m trying to make a Button that normally Salva, also become a Button that saves the changes made... It’s all the same form and the same Button, for example when I click two DataGrid he brings…
-
-1
votes1
answer143
viewsChanging Mysql data with C#
I am trying to change data saved in my BD, however by having a certain error, if someone can give a light code I’m using to save the changes: private void btnSalvar_Click(object sender, EventArgs e)…
-
-1
votes1
answer36
viewsHelp with input with , and . php with myslq
I need the ACA and AIA field to return values with. or commas, the code saved in the data bank correctly but only shows the integer without comma. It is also rounding. Code: <?php $count = 1;…
-
-1
votes1
answer149
viewsExpired date alias in Mysql
I have a query select which receives the user date in the database MySQL and the shape of the field is datetime, and the PHP treats the output and in HTML data as the date of registration of a…
-
-1
votes1
answer76
viewsHow to perform an Insert from a select in a table of another PHP database
I have two databases and I have a table Table in the database Servor1 no data and another database Server2 with a table Tabelay. And I want to make one select on the table Tabelay and with your data…
-
-1
votes2
answers61
viewsLine break between record of a table
I’m having a hard time making the line break in a table query... For example I have 1 table with ID 1, 2, 3, ... I want when you give the select it shows 1 2 3 But it’s showing 1 2 3 follows the…
-
-1
votes1
answer26
viewssyntax error in login system - PHP
ERROR: Parse error: syntax error, Unexpected '$email' (T_VARIABLE) in C: xampp htdocs SUPPORT password.php on line 6 CODE: <?php session_start(); include("config/config.php") $email = $mysqli…
-
-1
votes2
answers520
viewsCapture session data with PHP and Mysql
I am trying to make a system in which in my user database has 4 fields: usuario_id, usuario_nome, usuario_senha and usuario_empresa_id. I need to capture the data of usuario_empresa_id (who receives…
-
-1
votes1
answer51
viewsHow to create an email resend after 30 days?
I am creating an email resend, I need it to work as follows, I want you to check the table and check all emails, if it is less than 30 days forward the email. I have this code below where before it…
-
-1
votes2
answers158
viewsSELECT COUNT with low performance in mysql
I use a query within PHP to display the list of related categories and subcategories, get back more than 10,000 results (right) in 3 seconds on average, but after I implemented a subquery to check…
-
-1
votes2
answers64
viewsI’m getting two errors when I try to search by name in a product table
I’m scheduling a product management page, and I want to include a search engine to give users a search engine that can save time while they’re looking for the desired product, but after following a…
-
-1
votes1
answer38
viewsHow to send the chosen value within an option that has a query in the database
<?php session_start(); include 'conexao.php'; ?> <form action="recebe.php" method="POST"> <select class="browser-default custom-select"> <option…
-
-1
votes1
answer43
viewsINSERTION COMMAND TOGETHER WITH THE PHP TEMPLATE
Good evening, I wonder if there is a way to put the sql commands for insertion in the same form as the inputs. Obrihado! INSERTION FORM <!DOCTYPE html> <html lang="en" > <head>…
-
-1
votes1
answer195
viewsWhat is the best practice for running select after PHP Insert?
After making an insert in the database, I return the newly created id and then make a get of this same id to perform another function. But as it is all very fast, the get comes before you have all…
-
-1
votes1
answer110
viewsMysql Date type field returning incorrect value in Java
I am trying to read data from a Mysql table with Java, but the Date field is returning the following code:…
-
-1
votes1
answer42
viewsSave multiple data with a single identifier in mysql and php
I’m making a screen to show the discounts in opencart admin, by sub store, I can already save in a table for testing, the biggest problem is: How should be done properly in this case to be saved in…
-
-1
votes1
answer45
viewsMysql data is not inserted
Hello, I am trying to insert data into mysql by netbeans, but it always returns the "null" error. When I refresh mysql the table continues without the entered data. There is no error in the syntax,…
-
-1
votes2
answers109
viewsHow can I view BD (Mysql) images(url) in Android Studio
How can I show images (url) of the Database (Mysql) in Android Studio? Mainactivity.java package com.example.APP; import android.os.Bundle; import android.os.StrictMode; import…
-
-1
votes1
answer54
viewsProduct quantity increasing as you update the page
I have a problem that every time I give F5 the quantity of the product increases... I would like that when updated it does not increase this index if the user does not click to buy more. }…
-
-1
votes1
answer681
viewsSelect with PHP PDO and Mysql with conditional query values
I have the following table, called 'animal'': And in my PHP application using PDO, I need to select values that are conditional. For example: The user will pass as a parameter only the 'TYPE' and…
-
-1
votes1
answer73
viewsTake last result and increment with php, javascript and mysql
As I do to take the last value inserted in SPAN and add another 10 to save in BD, the insertion is all ok, I need to delete the input and each time BD add another 10. Example: Product 100 by…
-
-1
votes1
answer152
viewsSave/maintain checkbox status (selected or not selected) after closing the browser
I’m making a page that has a table with values coming from the database. It has 4 columns and more than 300 rows. A column has a checkbox for each row, the other has the name of an object and the…
-
-1
votes1
answer97
viewsTRIGGER does not work in MYSQL
I’m trying to make a TRIGGER that inserts data into a table as soon as data is entered into another table. Original Table: CREATE TABLE tbGuia ( codigo_guia INT NOT NULL AUTO_INCREMENT,…
-
-1
votes1
answer28
viewsDisplay summed values of a column in html
I have the qtd_stock column in the cadastral table. In a div, I want to display the values of all lines summed. I tried this way, which does not show any value: <?php $sql2 =…
-
-1
votes1
answer73
viewsError while trying to show mysql data in html
I am wanting to pull some things that is in a table in the database, only that error is appearing in the connection line of the database. bd: Projects table: projects ERROR: Fatal error: Uncaught…
-
-1
votes1
answer585
viewsI cannot log into phpmyadmin on the project using Laradock (Laravel and Docker)
I’m a beginner and started a PHP project using the Laradock environment. Well, I have everything installed and configured, the containers all running and I can access the project under development…
-
-1
votes1
answer645
viewsHow to resolve: You have an error in your SQL syntax;
I am developing a login system, but this error is arresting me and I found no answers so far: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for…
-
-1
votes2
answers110
viewsMount "if"s according to criteria
I’m having a question on the condition I’m willing to put in my system. In case the site will check if the "Paid" is with the result 1; if you have 1, it will put "Delivered", but if you have 0 it…
-
-1
votes1
answer88
viewsPopular table using two that has no link
Guys I’m having a little problem I have the following situation: table escritorio where I have a field called id that I’m gonna need table etapas where I have the fields id that I’m gonna need; I…
-
-1
votes1
answer364
viewsUnhandledpromiserejectionwarning: Error: Cannot enqueue Query after fatal error
I have this mistake and I couldn’t find any questions on Stackoverflow that would help me... the error is being generated provable because of a promise Index.js const path = require('path') const…
-
-1
votes1
answer39
viewsMYSQL VIEW data listing
I made a view that lists me a record count in Day, Week, Month and Year, but when I add new records the Day record doesn’t just change the others. Follow the code of the day: SELECT COUNT(id) FROM…
-
-1
votes2
answers124
viewsError while trying to display error/success messages and page continues to reload with ajax
Hello, I am developing a "soon" page, where I have the functionality of registering email. I made this feature with ajax and php, using the database mysql, and I’m facing 2 problems. When typing the…
-
-1
votes1
answer1338
viewsmysql - Warning : mysqli_connect (): (HY000 / 1045)
<?php include"Conexao.php"; //============================================================================== $nroproduto = $_POST['nroproduto']; $nomeproduto = $_POST['nomeproduto']; $Categoria =…
-
-1
votes3
answers96
viewsSystem not identifying encrypted password
So I made a php system linked to my mysql where there is a table called authme and it has the login information, such as password, name and other things more when logging in the system not recognize…
-
-1
votes2
answers2170
viewsDocker mysql Error: Connection refused
Hi ! I’m creating my Docker development environment. But I’m having some problems: I can connect to the mysql container by an SGBD, but I can’t connect through php-fpm, it generates an error :…
-
-1
votes2
answers127
viewsPHP several Insert along with an update
I need to do several insert along with a update. On my application, I gave a print_r($_POST); to see all variables being sent. Array ( [matricula] => 10-03793383-19 [id_aluno] => 11 [id_curso]…
-
-1
votes2
answers81
viewsIs it correct to mix JSON format with Mysql?
I am helping to develop a web application in Laravel for a company. It has several Modals included in them (including modal that leads to another modal). To call these modals, I am using Jquery, as…
-
-1
votes1
answer58
viewsHow to make this condition work?
I need some help. What I’m trying to do is similar to the urban fish offerings, active while the time counter works and after the finish the information is replaced. but when use Lse does not work…
-
-1
votes1
answer348
views -
-1
votes1
answer66
viewsRegistration is not being recorded in the bank
Hello, I am creating a login/registration system for a college job, as a basis I am using some internet tutorials. I was able to develop well, but now I’m stuck... My registration form is not…
-
-1
votes1
answer67
viewsProblem with PHP in the edit form
Guys, I need some help. I’m doing a PHP job, but I can’t edit it through the form or log in. edita-usuario.php / <?php session_start(); include "conexao.php"; $id = $_GET['idusuario']; $sql =…
-
-1
votes1
answer221
viewsHow do I show a user ID through Sesssions?
I have the following file for user validation, and I would like to show the user ID, only the test paths, but it does not return me anything in the "menu.php" php validation. <?php // Verifica se…
-
-1
votes1
answer54
viewsTOP 5 PLAYERS
I’m trying problems in my code, I wanted him to get the 5 best players who most purchased products in the month, the problem is that I wanted him to catch the guy’s user and show the amount he paid,…
-
-1
votes2
answers1745
viewsHelp: Warning: mysqli_num_rows() expects Parameter 1 to be mysqli_result, Boolean Given in C: xampp htdocs redesocial login.php on line 7
<?php include("db.php"); if (isset($_POST['entrar'])) { $email = $_POST['email']; $pass = $_POST['pass']; $verifica = mysqli_query($connect, "SELECT * FROM users WHERE email = '$email' AND…
-
-1
votes1
answer1182
viewsError mysqli_fetch_array() expects Parameter 1 to be mysqli_result, bool Given
I’m having a problem with these mistakes: Warning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, bool Given in C: xampp htdocs hpveiculos index.php on line 512 Warning:…
-
-1
votes3
answers212
viewsRelational Algebra - Query in 3 tables
Good afternoon,I’m having a hard time returning a value from my bank when it has two attributes, I’m starting from this statement. Select the names of the parts that use the materials with the names…
-
-1
votes1
answer44
viewstake field name in query and popular other!
I’m doing a search at the bank. On the table, I have 6 dates: data1, data2, data3, data4, data5 e data6. I’m sweeping these dates to find out which one matches the current month. This is already…
-
-1
votes1
answer47
views