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
answer320
viewsError while executing POST method
I am facing a problem regarding the POST method, when triggering this method it normally inserts in the database, but the application (Node index.js) is finished, at the command prompt I get this…
-
0
votes1
answer6739
viewsCreate database in mysql
I am trying to create the second precedure in mysql, but when I enter the first line of the declare the following error: ERROR 1064 (42000) CREATE PROCEDURE finaliza_expedicao (IN expedicao_id INT)…
mysqlasked 6 years, 10 months ago Marcius Leandro 462 -
0
votes0
answers41
viewsPHP Injections from Mysql
Good evening everyone. In the framework of exploring the vulnerabilities of my code I decided to test an injection of Mysql, first to escape the strings and right now without escaping them... It…
-
0
votes3
answers156
viewsCondition in a select
I need to create a SELECT which contain only records of a value x onwards. For example, return only movies with number of copies greater than 5 My Select router.get('/filmes', (req, res) =>{…
-
0
votes2
answers124
viewsList Category and sub-egoria
Good afternoon, I am developing a framework in the Mvc model and wanted to list the categories and subcategories I am using a single table CATEGORY. with the following fields. mysql> select *…
mysqlasked 6 years, 10 months ago Philipe Silva 45 -
0
votes3
answers49
viewsRemove character to search in database
I’m having trouble creating a Function to make a search in the database and from the zip code complete the fields related to it, as address, neighborhood, city and state. Obs: I have a mask in the…
-
0
votes2
answers105
viewsHow to define table that will receive the Insert using PHP variable?
I have some tables that follow a pattern: NomeUsuário_SobreomeUsuário_IDUsuário_sementes Jefferson_carlos_1_seeds Carlos_drummond_2_seeds the name, surname and ID are stored in the session and I…
-
0
votes0
answers255
viewsCalling data from a form on the same HTML page
I want to call data already inserted in a form and use them on the same page HTML in which I will use them in a consultation SQL. Because depending on the number of municipalities will be generated…
-
0
votes1
answer72
viewsError with jquery UI Autocomplete
Good afternoon, I’m getting an error that particularly I’ve never seen, when trying to use jquery autocomplete, follows the image, and the encoding: PHP: (I used as an example, because I didn’t add…
-
0
votes0
answers37
viewsChanging PHP URL
Personal I have a pagination system that to each page it pulls a content from the database. In this case it pulls the ID "ID of each element of my database", I’m trying to change it to take the…
-
0
votes2
answers6052
viewsHow to access another machine’s database
You guys, good night. It is as follows: I am with a PHP project with Mysql to be delivered. However, I am doing it this way: I created 3 virtual machines in Vmware Workstation Pro, the Client is…
-
0
votes1
answer1542
viewsBring up column values and add up the total with php + mysql
I have the following script that brings the values I need, as I do for it also bring the total sum of $Row['value']? $results = $mysqli->query("SELECT * FROM cv_contratos_dependentes WHERE…
-
0
votes1
answer1060
viewsERROR CODE 1215 - You cannot add foreign key
Table 1: Table 2: Commando: ALTER TABLE extras ADD FOREIGN KEY (login) REFERENCES usuario(login); Answer: Error Code: 1215. Cannot add foreign key constraint Cannot find an index in the referenced…
-
0
votes3
answers285
viewsCompare and replace Intel array
The problem and the following, I am creating daily OS chart, only that comes from the bank with day in English, I would like to replace each index with the value in Portuguese My code public…
-
0
votes1
answer130
viewsMysql query to display records not linked to a particular company
I need to create a query on SQL. I have three tables: TABELA 1: EMPRESA emp_codigo (chave primaria) emp_nome TABELA 2: PALAVRAS_CHAVE pal_codigo (chave primaria) pal_nome TABELA 3: VINCULO…
-
0
votes1
answer112
views -
0
votes2
answers47
viewsHow to pull a die from the same field?
Come on, guys, I know my question might be silly... But how can I pull data from a field only in SQL. It’s just that I’m actually putting together a report of the company’s products... There are…
-
0
votes1
answer4727
viewsHow do I use the "LOAD DATA INFILE" command?
It is the following guys, I have a database and in it a table called "people" which contains "id_people" as attribute and I want to test an import of information using this command of the title, I…
-
0
votes1
answer499
viewsCreate Procedure in phpmyadmin
I am trying to create a precedent that changes between Insert and update in phpmyadmin but returns me an error in the line of if EXISTS, then I tried to create by the graphical panel and returns me…
-
0
votes1
answer45
viewsI have an excel report, how do I extract by date?
I have an excel report that does a BD search and brings all the information. how do I put in the form in php the user inform the date and search in the BD only between those dates and mount excel?…
-
0
votes1
answer254
viewsWindows with php the utf-8 characters are correct and not in Linux?
I created php pages in windows 2012 with php (to migrate from Asp to php) The pages in php are: HTML5 (made in Notpad++ in UTF-8 Encoding) Has < meta charset="UTF-8" > in the head Accesses in…
-
0
votes1
answer72
viewsUse a column as a header
I have a table in mysql of products, and need in select or php turns a column into header, example: cod produto valor pagina 123 caderno 1,00 pagina 1 456 lápis 1,00 pagina 1 789 borracha 1,00…
-
0
votes1
answer72
viewsSelect the value of a field depending on a date
I have a table with the fields DT_FIMCALCULO, VL_DEPREREVVIDAUTILACUMULADA e CD_SEQUENCIALBEM. And for each CD_SEQUENCIALBEM I have several DT_FIMCALCULO each with a VL_DEPREREVVIDAUTILACUMULADA…
-
0
votes1
answer548
viewsRecord sequential number per year PHP
I wanted to create an automatic numbering record but reset each year. Getting for example 170001...170002 and for the year 180001...180002 But with this code, I always register 1700001 <?php…
-
0
votes3
answers149
viewsFind a certain number inside a mysql string
Good morning, everyone. I’m having a question I can’t seem to solve. In a given table of a BD I have a column that saves a string as follows: 1,2,3,4,5 Line 1 11,22,33,44,55 Line 2 Now I need to do…
-
0
votes1
answer1194
viewsReturn query result with Node
When I make a select in my bank MYSQL, I get the answer and I can display it to the user, but the problem is that this is not enough,just take the result and display it, I need for example to check…
-
0
votes0
answers2365
viewsWarning: mysqli_num_rows() expects Parameter 1 to be mysqli_result,
I just climbed my application to do a test on the server, sq always gives the error the following error Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in…
-
0
votes1
answer42
viewsHow can I pick up items not viewed?
Use the following select to pick up items already seen: $sql = $conn->query("SELECT * FROM views b, news a WHERE a.status = 'true' AND a.id = b.id_news AND b.ip = '$ip' ORDER BY a.id DESC LIMIT…
-
0
votes0
answers50
viewsError parameter always null
I’m trying to make a registration system when I click the button, everything goes right but the parameter is getting null always. (Even if I define in a string) String url = ""; String parametros =…
-
0
votes1
answer398
viewsInner Join returning empty
I have a SELECT to return a list of products, but I want them to be differentiated by input and output, contains and does not contain... Obs: I WANT TO TAKE THE LAST MOVEMENT OF EACH PRODUCT Select…
mysqlasked 6 years, 10 months ago Demetrios Felipe 3 -
0
votes0
answers380
viewsHow to insert Json data in mysql using php
I have a document with data of json format that I want to insert in the BD phpmyadmin, I am able to insert the first data in the table that are inside "Results", but I am not able to enter in…
-
0
votes0
answers249
viewsUpload image to BD Mysql using PHP
1. My Phpupload Image Script <?php // SERVIDOR ONDE AS IMAGENS ESTÃO SALVAS $caminhonoservidor='imagens'; // este caminho será gravado na variável imagem $caminhotemporario=…
-
0
votes0
answers31
viewsbackground-image does not change the CSS file on the server
I have a bakckground in a CSS file that works well in the browser, but when I put it on the WAMP server the CSS changes don’t happen. Can someone help me? On the Index <link href="estilo.css"…
-
0
votes2
answers111
viewsSecure delivery of digital products in PHP
Speaking personally, I am developing a system where the customer can make the purchase and receives a link to download the product. The system has a registration area in which it is possible to…
-
0
votes0
answers54
viewsHow do I turn mysql into Pdo?
I have this Function in mysql. public function get_logst(){ $this->connect_database(DAT5); $querygetl = mysql_query("select HeroName, ObjIdx from ObjLog where LogType = '5' and LogSubType = '2'…
-
0
votes1
answer104
viewsMysql query in phpMyAdmin
I’ve searched here and other sites but, the result of my query only returns false and do not know the pq of this. here is the code of the consultation <?php…
-
0
votes0
answers71
viewsHow do sum with php or SQL?
Hello I want to add the total values of the result of a PDO query. However, when executing the command the following message appears in the console: Object of class Pdostatement could not be…
-
0
votes1
answer34
viewsUnexpected result in database query
<?php class Login{ public function logar($email,$senha){ $connect=new DB; $connect=$connect->conectar(); $sql="select * from usuarios where email='$email' and senha='$senha' and status='1'…
-
0
votes1
answer1824
viewsTime calculation for PHP + Mysql point
I am creating a table for the calculation of working hours of employees, but I am not able to do the calculation to know if the correct amount of hours was worked in the day. In the database is that…
-
0
votes1
answer319
viewsDocker-Compose to create Lamp with phpunit
I am trying to use Docker-Compose to create a LAMP environment along with phpunit to run php TDD and what I intend to do is the following: run a mysql image 5; run a phpunit image 5; run a php 5.6…
-
0
votes1
answer592
viewsHow to use Mysql in Java EE?
I have a java (desktop) application that does some operations in writing the logs to a table in Mysql, I need to do a page that will show me this log. I did some tests, but did not succeed. I am…
-
0
votes0
answers152
viewsWhere do I start to integrate my database game?
I want users of mine Mobile game can log in and save game information, and have the option to share some information (for example a created character) for other users to download and use. The…
-
0
votes0
answers50
viewsProblems saving information to the Database
I have this code, but for some reason you’re not saving the information in the database. Can someone explain to me what’s wrong with the code ? <?php require_once('functions.php'); add(); ?>…
-
0
votes1
answer184
viewsChanging field type Mariadb(Mysql)
Staff created a table called entries in a test database. In it was inserting data from a.txt register file. until then the id primary key when I created it was not auto_increment so for testing…
-
0
votes1
answer43
viewsExport fopen without ""
I’m using the fopen , to export the return of a select, it is exporting correctly, more in certain fields this appearing "" as I remove the "" of export, leaving only the , because it’s coming out…
-
0
votes1
answer566
viewsdoubt with open and close connection
I would like your help with the link below, when I close I have the following error below, am I doing it the right way? regarding the opening and closing of the connection? my pool public class…
-
0
votes1
answer1014
viewsInsert records from one table into another in Mysql?
I’m having difficulty entering data from one table into another, for example I have the budget table that has the items, but the items may be from different suppliers, and when approved this budget…
-
0
votes1
answer96
viewsGet sales average for a given month
I would like to take the average sales of the month by product description and not by date with day, month and year, but I don’t know how to get. SELECT AVG(vend_qtde) AS qtde_vendas from tb_vendas…
-
0
votes1
answer51
viewsTake a value from another field other than id
I have the following tables: 1 - Assignments with the following fields: Id, Request, Collaborator and Date Assignment. 2 - States with the following fields: id, State and State. Numpedido is equal…
-
0
votes3
answers1410
viewsDisplay more than one information in the same table with PHP and MYSQL
I would like to display in the table the information of the enrolled student and also the courses that he is enrolled. Final result that I would like to be shown: Nome Aluno | Telefone Aluno |…