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
-
0
votes1
answer456
views -
0
votes1
answer131
viewsUpdate mysql problem
I have a function that performs an update: function alterarConta(){ $dataemissao = $_POST['dataemissao']; $id = $_POST['id']; $select_fornecedores = $_POST['select_fornecedores']; $valor =…
-
0
votes1
answer255
viewsDelete Registry in BD Mysql
Good afternoon. I need help deleting a Mysql BD record. I have a comic book that has a table called KEYS. I have a page called listing.php, this page gets the table values KEYS. On this page is a…
-
0
votes1
answer450
viewsI cannot recover id value through the POST method
I have the following functions: File registra_account.php: if(isset($_POST['acao'])){ if($_POST['acao'] == "inserir"){ inserirConta(); } if($_POST['acao'] == "alterar"){ alterarConta(); function…
-
0
votes1
answer56
viewsHow to generate query and add new input?
I have a field input of the kind date I want every time I click and view it generates a select with the date query I have set and generate a new input to add another date and so on. My code so far:…
-
0
votes1
answer41
viewsUse Rand and randomly assign to all columns
I have this table (centrodb.Infocontributors) that has the ids of all the other tables I do the join in the database with this data: I have this query: SELECT B.NomeColaborador, C.Ala, D.Grupo,…
-
0
votes1
answer264
viewsConstraint in a key Primary - SQL
I’m having a problem intender what the intention of this code below when putting a Constraint to create a primary key for a foreign key. CREATE TABLE Customer( IdCustomer integer PRIMARY KEY NOT…
-
0
votes1
answer125
viewsImport data in mysql from a layout
I am importing some data in the table "tb_usuario" that comes from a text file, it works as a layout for the import of these records, I used semicolon to delimit the position of these data in the…
-
0
votes2
answers410
viewsHow to merge these 2 SELECT into a single query
Good morning, I’m redoing the question because the last one I deleted was a little confused. I have these two select and would like to join them to return the result to a comparison chart. This…
-
0
votes1
answer114
viewsSelect result, and show only if all are equivalent
I’m maintaining a database, and I’m in the next situation; in the bank I have 5 columns in a table, are: ID(PK)|Idticket|Result|Prestadoconta|Date I have to filter for the user to see, only the…
-
0
votes1
answer36
viewsHow to select and assign the quantity
I’m trying to use mysql to select two tables and assign the number of rows to a field for example I have two tables: Grupo, Pessoa I want to make a Join in the Group table showing the number of…
-
0
votes0
answers28
viewsPhoto upload system, does not display name in database, but the image goes to the folder inside the server
hello, I’m trying to upload images to my site, through a php, with the script I can play the img inside the folder I want inside the server, however in my database it appears that a file has been…
-
0
votes1
answer307
viewsHow to join two tables in a JSON
I have two tables: Companies id: integer nome: string Imagery id: intger idEmpresa: integer url: string Do: select * from empresas where id = 1 select * from imagens where idempresa = 1 and I get a…
-
0
votes1
answer46
viewsCommandbutton does not register in SQL
I’m having trouble with my code, when I register a new vehicle, it says that the vehicle is not being instantiated and is returning null. Follow my settings: LAYER DAO: public void adicionar(Veiculo…
-
0
votes1
answer50
viewsDo not insert in table
I have this code: <?php $servername = "xxx.xxx.x.xx"; $username = "xxxxx"; $password = "xxxxxxx"; $dbname = "xxxxxxx"; $conn = new mysqli($servername, $username, $password, $dbname);…
-
0
votes1
answer114
viewsDate expiring from date of registration (datetime) - MYSQL
The field is of type datetime, how to display the date for 30 days from the registered date, example: <?php // `data_cad` = '2018-03-01 01:52:00' $instrucao = "SELECT `user_id`, `status`,…
-
0
votes2
answers45
viewsProblem in Query SQL
I am developing a C# application and I use a BD in Mysql. In a part of the system, I need to increase the stock of a certain product, test the command in Workbench and worked well, but when I run…
-
0
votes0
answers1590
viewsError Cannot read Property ' toString ' of Undefined
I am creating an application making use of Express, but I’m facing that mistake : ➜ Futiba git:(master) ✗ node index.js ➜ [ Server ] Online…
-
0
votes1
answer89
viewsAutocomplete/Suggestions/Mysql
Question 1: Does anyone have any functional examples of when someone types in an input pop up suggestions below? preferably coming from a table created in mysql. Bench: test Table: users (user_id,…
-
0
votes0
answers66
viewsProblem when logging in
To create a log for my system to know that changed the information, except that the way I rode is giving Fatal error: Call to Undefined Function anti_injection() in: can someone help or give me some…
-
0
votes1
answer80
viewsLogic of a Likes table
In a PHP + Mysql application in which I need to store how many Likes + id’s of who gave like in a publication, I came up with a question about the logic. Assuming that 2 users give like in the same…
-
0
votes0
answers62
viewsI cannot run a query inside a socket event using Node.js (socket.io), why?
Follow what I did initially: var http = require('http'), express = require('express'), mysql = require('promise-mysql'), mysql2 = require('mysql'), parser = require('body-parser'), path =…
-
0
votes1
answer28
viewsWebsite - User changes password even if there is an error between the new pass and the confirmation of the password
When a user wants to change his password there are 3 Labels, 1 for the old password and the other 2 for the new password and for its confirmation. If I enter all the fields correctly, everything…
-
0
votes1
answer1126
viewsError accessing data in Mysql with EF6
When I try to access data in Mysql via lambda(EF), Visual Studio returns the following error: Falha no método >'MySql.Data.Entity.EFMySqlCommand.set_DbConnection(System.Data.Common.DbConnection)'…
-
0
votes0
answers438
viewsTo display a mysql BLOB type field on the html page
I have searched several times but could not find a solution, I need to display an image that was saved as BLOB in the database. Part of the code that saves to the database and displays the data…
-
0
votes0
answers63
viewsPHP and Mysql - UPDATE error
On my client’s website, which is programmed in PHP and uses Mysql, users must fill out employee evaluation data. But in two moments, I received notifications from users who will continue the reviews…
-
0
votes1
answer49
viewsShow label data in radio instead of text
I have this appointment and I show it this way: <?php if(isset($_POST['data'])) { $servername = "xxx.xxx.x.xx"; $username = "xxxxx"; $password = "xxxxxxxx"; $dbname = "xxxxxxx"; $conn = new…
-
0
votes1
answer1304
viewsHow to do Onclick action in Select Option
I need to do an onclick action on each option of a select with a different link according to the id of each, but it’s not working. $label .= "<select size=\"1\" name=\"modulo\"…
-
0
votes1
answer248
views -
0
votes0
answers22
viewsIt says that it has been inserted on database, but Nothing appears there
I save the input information on the "Save" button and then it says that the information has been entered, but when I go to see the database, there’s nothing there, Someone can help me? <?php…
-
0
votes1
answer82
viewsRemove a mysql column configuration
I have a mysql column that has a key worthwhile MUL, how to remove this setting from the command line? My table has the following scheme:…
-
0
votes1
answer346
viewsRelationship between 4 tables
I have the tables: -- NORTE -- create table tb_indices_norte( id_norte int not null auto_increment, localidade varchar(30), sem_epi int not null, totOvos smallint, num_pos smallint, num_inst…
-
0
votes2
answers49
viewsPopular array on online server
I’m a beginner in programming and I’m developing an android application that uses PHP and requests with Mysql. I initially tested all the features on the local server to then migrate it to an online…
-
0
votes0
answers132
viewsBetween with varchar field type
I have two fields where an initial and final date is placed: <form name="filtroClientes" action="consulta_contas.php" method="POST"> <div class="form-group"> <label for="nomefiltrar"…
-
0
votes2
answers559
viewsUpload csv file with ajax, json, php and Mysql
I’m trying to make a import file csv to the MySQL dealing with errors with JSon but I’m not succeeding, even with a basic test I can return the message, always falls in the else of if. This is the…
-
0
votes1
answer53
viewsError in PHP login, registration is working normal, only login does not connect according to entries in the database
YOU ARE MAKING THAT MISTAKE WHEN YOU GO IN : Warning: mysqli_query() expects at least 2 Parameters, 1 Given in C: xampp htdocs hosste Login_v1 userauthentication.php on line 28 Warning:…
-
0
votes2
answers75
viewsWhy are you making this mistake and how do I reverse it?
I have this table: create table lagoa_azul( id_lagoa_azul int not null auto_increment, sem_epi int not null, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7…
-
0
votes0
answers24
viewsWhat is the best way to display an item rating without overloading the system?
Hello The site I am currently working on was developed using Laravel, using MYSQL as the database. The base currently has 500,000 registered players. Each player has a score. Currently the system…
-
0
votes0
answers42
viewsI can’t connect to the database
Hello good night I am studying php, but when it comes time to make connection with the BD, does not connect at all, the names of the bank are correct, the already imported the bank and nothing…
-
0
votes0
answers36
viewsWebsite - Edit a contact (form)
I am creating a website where every user has their contacts. If a contact is added, it can also be edited. But I’m getting two mistakes that say: Undefined variable: con e Fatal error: Uncaught…
-
0
votes1
answer840
viewsCalculate difference between timestamp field with specific timestamp
I’m trying to develop a ranking chart for a kind of questionnaire. Each day a question is asked at 4pm, which can be answered until 5:59:59 the next day. The table has to show the position of the…
-
0
votes1
answer125
viewsCrud with Edit inside the Own table and search for data + database
Could someone tell me how to make a CRUD with editing by the table itself ? Detail this table has to be linked in a database, I did it in PHP with Search, got ball show, but my boss did not want, he…
-
0
votes1
answer48
viewsProblems with JOIN and CONDITIONS - sql
I’m having to fetch in 2 table some data with certain conditions, follows the situation: table: tbTransmitted => Colunas: Code - Qty - On request table: tbEstoque => Colunas: Code - Qty -…
-
0
votes0
answers27
viewsAdministrative panel modifying/changing svg contents
I was imagining a page structure like this, but I do not know if it is possible to execute and wanted to know the paths and possibilities. In a div would have mysql table data and a svg. The objects…
-
0
votes1
answer42
viewsLaravel - Return values in master layout
I have an application using Laravel 5.5, arose the need to insert a dynamic field in the footer that is located in the layout master, however, I am not able to return the data in it, I could not…
-
0
votes1
answer40
viewsput a column in the table to mark as view
I have this query and show in a table: <form method="POST" action=""> <fieldset> <table cellspacing="10"> <tr> <td> <strong>Insira data de inicio:</strong>…
-
0
votes2
answers148
viewsUpdate in database table
I have this code to make updatand the countryside estado as completed and be the only field that can be edited: <?php $servername = "xxx.xxx.x.xx"; $username = "xxxxx"; $password = "xxxxxxx";…
-
0
votes1
answer90
viewsError Entity Framework WPF Client
I installed my application in client environment but am getting the following error: Nome do Evento de Problema: CLR20r3 Assinatura do Problema 01: eLogBook.exe Assinatura do Problema 02: 1.0.0.0…
-
0
votes1
answer66
viewsError When Registering in Database
I’m getting the following error when trying to insert some data into the database: Unknown column 'F' in 'field list' In case the column and the type Enum and can receive’M', or 'F', testing…
-
0
votes0
answers75
viewsError Connect to Database?
Well I’m trying to make a connection to a database and is giving the following error "ERROR: SQLSTATE[HY000] [2003] Can’t connect to Mysql server on '167.114.173.210' (13)" And I have a program…