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
answer57
viewsI need to change a table data with information from a different table
I have 2 tables I need that whenever a consultation is made or inves to show the tagname in Table 2 the data in the column mask and whenever a new tagname it already updates to mask Follows the…
-
-1
votes1
answer35
viewshtml and mysql special characters
People I have video registration system via IFRAME but when I want to show the iframe it is empty because the database converted Original iframe code…
-
-1
votes1
answer274
viewsLogin MYSQL in C#
I am a beginner in C#, I am trying to validate a user in a login form, but my code does not compare the result of SQL, allowing the access of the program without having the user and password…
-
-1
votes1
answer193
viewsImport excel to multiple tables - PHP and MYSQL (codeigniter)
Hello, with the function below, I can import the data from an excel spreadsheet to the database, via PHP. To tables client contains the following fields: `id` INT(11) NOT NULL AUTO_INCREMENT, `name`…
-
-1
votes1
answer64
viewsHow to pull information from the database in an organized way
Good morning, I am developing a web project using PHP and Mysql. And I came to a part of this project, where I need to get the information that was recorded in the comic book. For example: I…
-
-1
votes1
answer30
viewsQuery to return multiple records in Store Procedure
I do not know if it is possible to perform this procedure to return several records. I am developing an online game dissemination system in specific 'Mu Online'. But I came across the following…
mysqlasked 5 years, 1 month ago Rafael Rodrigues Alves teixeir 9 -
-1
votes2
answers451
viewsLoop in PHP to create a form dynamically
good pie. I’m having trouble creating a php function to create a checkbox list. I want to fill in the value attribute and HTML content of with information provided by PHP, through a loop. The final…
-
-1
votes1
answer199
viewsHow to join Datatables with PHP in a checkbox search?
Get ready because business is very complex. I’m using the library datatables of Jquery (I’m pretty new at this) to list a table from my bank, when listing, each record received a checkbox so I could…
-
-1
votes1
answer32
viewsQuery in a question bank that cannot return hits
I have a bank of questions organized as follows: questions: ID | pergunta | a | b | c | d | e | correta 1 | Qual meu nome? | joao | pedro | jose | mateus | lucas | pedro 2 | Qual a minha idade? | 15…
-
-1
votes1
answer440
viewsDate less day in Mysql
I’m having a little, boring problem that I can’t seem to solve. I am making a java application using Spring Framework and using Vuejs as front. The database is Mysql. The problem is that when I try…
-
-1
votes1
answer100
viewsI’m getting this error while trying to connect mysql: Fatal error: Uncaught Error: Call to a Member Function prepare() on null
php connection. try{ $conn = new PDO("mysql:host=$servidor;dbname=$banco;charset=utf8", $usuario, $senha); return $conn; }catch(PDOException $e){ throw new PDOException($e); } base php. require…
-
-1
votes1
answer103
viewsPull value from a column with select mysql to php
Hello! I have this bank: SELECT * FROM player_index WHERE player_index.empire Query return: https://prnt.sc/pk8k1u And I have this code below,: <?=$players[$i][1]?> <table…
-
-1
votes1
answer121
viewsConnect Laravel to Mysql
I’m trying to develop an Laravel application with Docker My Docker-Compose.yml file looks like this: version: "3.3" services: mysql: image: mysql:8.0.1 container_name: mysql environment:…
-
-1
votes1
answer176
viewsInserting a PROCEDURE in query() in PHP
Guys, I’ve been trying for a while to integrate a project together with PHP, but when calling it, PHP keeps showing errors: Overview: $database = null; function Conecta($server, $user, $port, $bd){…
-
-1
votes1
answer172
viewsList Mysql data in TABLES format within Bootstrap Tabs
Dear, I am creating a system of listing products in which they are presented according to their category. The system works as follows: The data are registered in the BD "market" in the product table…
-
-1
votes1
answer589
viewsPdostatement::execute(): SQLSTATE[HY093]: Invalid Parameter number
Good evening, Folks. I’m getting the following error: Pdostatement::execute(): SQLSTATE[HY093]: Invalid Parameter number: number of bound variables does not match number of tokens in C: xampp htdocs…
-
-1
votes1
answer195
viewsGroup two columns into two mysql tables
I have two tables that I am joining to recover the related data in this way: Tabela Processos: Tabela Anexos id | processos processoid | titulo 1 | Processo 1 1 | REQUERIMENTO 2 | Processo 2 1 |…
-
-1
votes2
answers267
viewssend array to database via php
Well, I have a form with a button to repeat it several times, so I had to create arrays in it. Only now I don’t know how to send it to the database. Searching I found that the way it is today is as…
-
-1
votes1
answer322
viewsInsert data into a foreign key database
I am doing a database course and we have made a database with several tables with Foreign key below. I would like to know how to enter the data correctly in this table, because when inserting the…
-
-1
votes1
answer57
viewsMysql to Sequelize
I would like to turn this code into Mysql SELECT pets.nome, pets.pulseira AS pets , localizacao.datahora, localizacao.latitude, localizacao.longitude AS localizacao FROM pets JOIN localizacao ON…
-
-1
votes1
answer42
viewsSelect time in Mysql
Good afternoon guys! All right? I am developing a plugin that pulls from a database the television programs, it should pull by the time and show in a table the programs that are playing live,…
-
-1
votes1
answer25
viewsHow to update a column of data each time someone enters a page? This is so they can show in the table
The error is in the code snippet where there is the $update variable below. I use Mysql and have this table and the goal is to show in an html table the totalranking points. When someone earns…
-
-1
votes2
answers377
viewsFetch stock balance on a given day (or day)
I have the table "saldo_dia" where I record the product (ID), the date and the balance. I need to generate a report (Kardex) and fetch the balance of a given day as "starting balance". My question…
-
-1
votes2
answers65
viewsWhy do I get a blank page instead of redirecting like this in the command (header: Location)?
Good evening guys, I recently took a PHP course and decided to venture a little creating a login system with $_COOKIE. When I manually set the variable, I can validate the login, but when I pass the…
-
-1
votes2
answers65
viewsSearch multiple tables at the same time Mysql
Well, I’ve got the tables professores, materias, turmas. To make it easier and simpler (because all I need is that data), say that there are the following data: turmas (2)…
-
-1
votes1
answer75
viewsHow to sum all data from a table
I have the 'orders' table where all the orders that were made are, I would just add all the orders and show on the screen. In the example above I have 8 orders, on the screen will simply have…
-
-1
votes1
answer106
viewsHow to play recovered bank values in inputs using Fullcalendar
I’m having a hard time playing recovered values from a bench to fields of a form for later edition, I’ve read the documentation, I’ve looked for examples and even then I couldn’t, I’ve even checked…
-
-1
votes1
answer110
viewsError: Subquery Returns more than 1 Row MYSQL
The column I’m adding to subquery has more than one record, but do not know how to solve: select productid,pb.pricebookid,(select bookname from vtiger_pricebook p inner join…
-
-1
votes2
answers701
viewsUpdate table of duplicate records with conditions
hello friends I have a table and I would like to update the records in order to take the NAMES that repeat and put as ACTIVE = 0 only which DATA_CADASTRO are old! table:…
-
-1
votes1
answer34
viewsCreate mysql table by php
I’m trying to create a table in the database through php but I’m not getting it. By the way, even using mysqli_error no error is shown if ($new_room != "" && $new_room != " ") {…
mysqlasked 4 years, 10 months ago CodegTech Sistemas 45 -
-1
votes1
answer123
views -
-1
votes1
answer108
viewsThe.pdf file is not sent to the server
I’m making a system to register the file name and some other information in the database, and also upload the file to the server, but only the database is registered, but when uploading the file to…
-
-1
votes1
answer329
viewsHow to select and validate encrypted password in PHP
Hello, I would like to know the best way to select and verify the password hash(password) in a database and compare with the password entered by the user in a login form. Is it more appropriate to…
-
-1
votes1
answer31
viewsError using class to filter by student names
I’m trying to do a function to search by student’s name in the databank. I’m having the following mistake: Notice: Undefined index: filter in C: meuphp test search_student.php on line 7 <?php…
-
-1
votes1
answer64
views"Like" and "Dislike" buttons don’t work without updating the page
I’m developing a post system, where in each post viewed, I put a "Like" button and a "Dislike". I implemented a code that updates the page when one of the buttons is clicked, worked perfectly,…
-
-1
votes1
answer152
viewsSort timestamp results just by time?
I am trying to make a time ranking system of a game. The game uses UNIX time as a measure of time. I need to put the minor times first in ascending order, but as UNIX time includes date as well,…
-
-1
votes2
answers217
viewsMigrate data from one table column to another table column
I work in a company where we implement a new functionality in our system, but previously a field of our table was bug_passos varchar(500), now with the new implementation, we create a new table with…
-
-1
votes1
answer383
viewsAccumulated balance with multiple accounts - SQL
I’m having trouble creating an account statement that has the option to filter all accounts and/or only a few accounts. I am using this SQL to appear these record this way select bancos.id,…
-
-1
votes1
answer368
viewsSequelize foreign key error
Well, I was trying to implement the relationships with sequelize, I don’t know if I misunderstood the documentation but from what I understood it should work, below the model I want to make the…
-
-1
votes1
answer50
viewsQuery with Left Join considering the most recent records from the auxiliary table
I have two tables: curriculo (cur_codigo,cur_nome) lembrete_envios (lem_codigo,lem_curriculo,lem_data,lem_tipo) The table resume stores candidate ID and candidate name The table reminete_shipments…
-
-1
votes2
answers89
viewsCan you help me optimize this SQL query?
I am having a problem with this sql query. Its return time is on average 10 seconds and ta using 100% cpu. Probably because it uses many subquery. However I’m not able to optimize it. Does anyone…
-
-1
votes1
answer24
viewsHow to handle special characters when entering data into a php+mysql database
So, guys, I’m trying to input some data from a log screen into the database, but when I input it, the special characters click into the database. Follow the code in php: <?php…
-
-1
votes1
answer164
viewsError 'System.Collections.Generic.Keynotfoundexception' occurred in mscorlib.dll
I created an application in visual studio 2017, I formatted the pc and installed the 2019 version and since then no application I try to connect to the database works. always appears this error: An…
c# mysql visual-studio-2015 mysql-workbench visual-studio-2017asked 4 years, 9 months ago Guilherme Costa 1 -
-1
votes1
answer24
viewsPage loads without query finish - Nodejs + Mysql
I need the page to render only when the query returns some value, I tried to use Promise, async, await... but nothing seems to work, the page always renders and then the data is retrieved.…
-
-1
votes1
answer50
viewsdatabase connection
Hello, I’m having a problem with mysql_connector, because it’s not returning me the connection string with DB, even though I’ve already included it in the Netbeans classpath, and have done other…
-
-1
votes1
answer64
viewsSeparate arrays in columns in an html table
I wanted to separate my array by columns in a table. When I enter the records you get a ',' but when I take the comma you get an Array to string Conversion error. Could you help me? How I wanted the…
-
-1
votes2
answers67
viewsHow do I get records from my database in ascending order(of id), but I want it to take one by one
<?php $conn = mysqli_connect('localhost', 'root', ''); if($conn){ $Selectdb = mysqli_select_db($conn, 'quiz'); } $sql = "SELECT * FROM perguntas ORDER BY…
-
-1
votes1
answer39
viewsHow do I print data by data in sql?(selects all data, but only prints one by one in array format)!
$sql = "SELECT * FROM perguntas ORDER BY id_pergunta"; $execsql = mysqli_query($conn, $sql) or die("Erro"); while($row = mysqli_fetch_array($execsql)){ # code... …
-
-1
votes1
answer391
viewsUpdate select after registration without refresh
Good afternoon, this is my first post, I would like the help of vcs, I have a select option that searches the data in the bd, just after this I have a button where I open a modal window to include…
-
-1
votes1
answer35
viewsProblems with Promisse: Promisse[Object]
I’m developing an application and I’m doing database queries with a predefined model, I’m trying to use an asynchronous function to store the value of this query in a variable. Below follows the…