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
votes2
answers257
views -
-1
votes1
answer593
viewsNotice: Undefined variable: connection
Recently I changed all my code mysql for mysqli. It just gave me a lot of headaches. He gives me the following mistakes: Notice: Undefined variable: conexao in…
-
-1
votes1
answer955
viewsTrying to get Property of non-object
I have this form: <form class="login" name="login" method="post" action="../controle/usuario-controle.php?op=logar"> <input class="input" type="text" name="txtlogin"…
-
-1
votes1
answer725
viewsGrab clicked client id and write to a variable to recover in a modal
My PHP code has a while that lists registered users, from a query MYSQL. This list of users shows the photo, the id, the name and a link to open a modal. Follow the code of while: <?php…
-
-1
votes2
answers26
viewsHow do I get the field values?
My code $(document).ready(function(){ $('.formulario').submit(function(e){ e.preventDefault(); var inputId = $('.inputId').val(); $.ajax({ method: "GET"…
-
-1
votes2
answers2832
viewshow to do a mysql search with php and return the data in each input?
my system has to do a search, using a patient’s Cpf, then when he type his Cpf, have to have a search in the bank, where php will get all the information that the patient has with that Cpf that he…
-
-1
votes1
answer72
viewsError connecting to database
I try to make the connection in my comic, but keeps giving the error "Failed to connect!" The data in my comic book is: Data Base: a test Table: customers trying to connect by PHP <?php $conn =…
-
-1
votes2
answers68
viewsdatabase saving only password
This is my first post here, I’ve been following the forum for a long time but I never wanted to interact, today this desire arose along with a little problem ... I’m learning to html, css, php and…
-
-1
votes1
answer324
viewsMultiple buttons on the same page with different functions
I have the following code that has 3 buttons, when pressing a button, it should change a value in my table in Mysql, however, when I press one of the buttons, it is the same as having pressed all…
-
-1
votes1
answer963
viewsCreate stored Procedure with Mysql
I do bank EAD and have very little material to help me do my activities. I am with this question to resolve, if anyone can help me or help me with some way of study material I am very grateful.…
-
-1
votes2
answers2101
viewsChecking if registration already exists in the database
I am using this function in my form but I have a problem. It is validating the field and is not included in the comic, but the message instead of saying that the client already exists is saying that…
-
-1
votes1
answer137
viewsSending of Product Order
Guys, I’m putting together a product order shipping system, on the product selection page, we have the selection of them, where each one will have a input, however, undetermined, how do I send all…
-
-1
votes1
answer65
viewsProblem when inserting into mysql table
Good afternoon, I have this code: <?php $servername = "xxxxxxxxxxx"; $username = "xxxxxxx"; $password = "xxxxxxxx"; $dbname = "xxxxxxx"; $conn = new mysqli($servername, $username, $password,…
-
-1
votes1
answer1212
viewsHow to insert data from a textarea into the database?
I have a form with a textarea and I’m not able to send the data typed in it to the bank MySQL. How do I do? php form. <form id="cadastro" name="cadastro" method="post" action = cadastro.php>…
-
-1
votes3
answers1821
viewsEncrypt/ Decrypt MYSQL/ PHP autoincrement ID
I need to encrypt/decrypt the original Mysql ID printed in HTML, to later revert and receive the original ID in the back end. Ex: $var = $arr['id']; // 120 <table> <tr>…
-
-1
votes1
answer28
viewsproblems with installing wordpress on server with Cpanel
I am trying to help an NGO as a volunteer to: recover your website after an incident with your web hosting service (internal sabotage by someone who left the organization) the fact that I do not…
-
-1
votes1
answer25
views -
-1
votes1
answer379
viewsUpdate query data in php
I’ve been looking at dozens of topics, but I still can’t find a solution. I created a form that shows the database table data and when the data is changed I need to update the table row. this is the…
-
-1
votes1
answer882
viewsMysql + Python (Save Variable Login To Connect)
import the import getpass import mysql. class Acessdatabase(): UserName = "" PassWard = "" DataBase = "" def LoginDB(self): self.UserName = input("Username: ") os.system("cls") self.PassWard =…
-
-1
votes1
answer417
viewsPHP error while saving using quotes
I am trying to write a record in a Mysql database, however, it gives error because one of the fields receives the value Frantchelle's quotation marks. Fatal error: Uncaught Exception 'Exception'…
-
-1
votes1
answer70
viewsIs it safe to make mysql queries using cookie values?
Hello, next I made a system that works, but I am doubtful whether it is safe to use it to ensure that it has greater security or at least try to obtain it. I’m using a function that only reads…
-
-1
votes1
answer3783
viewsGENERATE PHP REPORT
I have a database in which there are two tables: CUSTOMERS BILLETS In my VIEW (Codeigniter), the user will select a period (Ex. 01/03/2018 to 31/03/2018) to generate a report of all billets that…
-
-1
votes2
answers177
viewsCreate combo with names within input value
have input with name contributor inside the while: while($rows_cursos = mysqli_fetch_array($resultado_cursos)) { $tabela1 .= '<tr>'; $tabela1 .=…
-
-1
votes1
answer1890
viewsHow to resolve ERROR 1452 (23000) in mysql
I’m trying to popular the following database: DROP DATABASE IF EXISTS library; CREATE DATABASE library; USE library; CREATE TABLE AUTHOR ( NAME VARCHAR(50) NOT NULL, COUNTRY VARCHAR(50) NOT NULL,…
mysqlasked 6 years, 8 months ago Renan Rosa 46 -
-1
votes2
answers706
viewsPlace form data in Array
Following guys, I have a database with some items and display the items of this database using this model: <?php $conexao = mysqli_connect("Host","User","Pass","banco"); if( !$conexao ){ echo…
-
-1
votes3
answers705
viewsAvoid duplicate records in a particular Mysql column
I have an auction system where several users can bid, but I have a problem when bids occur at the same time, as they are entered in the database with the same value in the column bidding_price, ex:…
-
-1
votes1
answer346
viewsDelete records with multiple conditions
I need to delete duplicate entries in the column bidding_price with the following conditions: Table: bid_account Columns to be checked: id = PRIMARY KEY auction_id = ID of each product bidding_price…
-
-1
votes1
answer69
viewsSearch in the Database
I’m in doubt on a role of how to do a comic search. It’s going to catch. Can anyone tell why? And how to solve? That is the function public void consultar(){ String sql ="select * from tbaluno where…
-
-1
votes1
answer2777
viewsSave Json to a mysql database
I don’t know how to process to save one JSON within the database. The whole process is thus: I am sending from another server through the script below: $sql = "SELECT * from mgs_castloang";…
-
-1
votes2
answers88
viewsUnrecognized keyword "as"
I am using MYSQL together with Phpmyadmin 4.7.4, and it accuses that the keyword 'as' is not recognizable, but when running it is in infinite loop, and shows no result. SELECT c.`nome`, case…
-
-1
votes1
answer89
views -
-1
votes1
answer45
viewsCreating an Identification Code with PHP and Mysql
I am starting to work with programming now and I have a lot of questions. I need to create a specific "TAG" for equipment registration. This TAG must have 4 letters + 4 digits, ex: CEME-0001. The…
-
-1
votes2
answers305
viewsHow to merge 4 tables into one and show text instead of INT - INNER JOIN
Hi, I know it’s kind of like this in the second print and with Inner Jay but I’m not getting it. I’m using Mysql Workbench and more when I finish this I want to go to C#. I have this doubt, I have…
-
-1
votes1
answer262
viewsI want to take a current balance and add with previous balance
This system and to make banking operations the user will have to make the deposit only he enters a value that he wants to deposit and in the bank he will have to add with the current balance only…
-
-1
votes1
answer18
viewsHow to insert an array of unknown size within the database?
I’m trying to insert into the database several rows of data that comes from an array. I’ve never done anything like this, because I always insert one line at a time. I wonder what I’m doing wrong?…
-
-1
votes3
answers2062
viewshtml form with PHP code to insert into mysql
I’m starting now with HTML, Mysql Phpe with Sublime using XAMPP. I am making a test form in HTML to include directly in Mysql. However it is not including the data. I’ve done several tests,…
-
-1
votes1
answer389
viewsHow to make an INNER JOIN in a single table with 3 keys?
I have a table that has the following structure: origem|papel|campo018|campo040|mercado|Master_key| The column Master_key can have two values: 'NY' OR 'MS', I would like to compare the lines where…
-
-1
votes1
answer44
viewsQuery that changes the amount of items in Mysql
I have a query that changes the amount in Mysql (below). Initially this query works perfectly, but when I register new items in the table, some of them do not change the quantity correctly, but some…
-
-1
votes1
answer857
viewsValidate PHP Login PDO MYSQL
Hello I’m starting with php already engaged in the world of PDO and I’m with a doubts in my code I want to check if the login exists and is the same that was entered, if for returns "existing login"…
-
-1
votes1
answer93
viewsHow to insert data from a form made in Angular2 in a database?
I’m starting to learn Angular 2, and I have to do a CRUD of a system over series, and I need to store data in a database, currently I know how to use Mysql using Xampp. I need to make the request…
-
-1
votes1
answer564
viewsERROR 1215 (HY000): Cannot add Foreign key Constraint
I am learning a little mysql and decided to do a market system, I have the following tables: CREATE TABLE IF NOT EXISTS cliente(cliente_cpf BIGINT NOT NULL PRIMARY KEY,cliente_nome VARCHAR(100) NOT…
mysqlasked 6 years, 4 months ago Erick R. Diogo 1 -
-1
votes1
answer55
viewsConfirmation email with password_hash
When registering on the site, the user receives an email activation of the registration, until then all right. The problem is in checking the password_hash, I know you have password_verify, but in…
-
-1
votes1
answer117
viewsProperty Hasrows in C#
I’m making a SELECT mysql with inner join within my application C# MySqlCommand _comandoDados = new MySqlCommand(String.Format( "select EMGroot.id, EMGroot.lbs_net, EMGroot.lbs_gross_aai,…
-
-1
votes1
answer2632
viewsFill table with database data. (Mysql and Bootstrap 4.1)
Save people, I’m trying to fill a table with data coming directly from the database (Mysql). I’m new to the web, I managed to put together a sketch of what I’m trying to do. If anyone can give some…
-
-1
votes2
answers353
viewsHow to edit Mysql records with an out-of-order PHP table
I’m creating a document request system, and on it is a page that shows all pending requests. These requests are recorded in a Mysql table and shown as in the image below. The problem is that in the…
-
-1
votes1
answer471
viewsProblems connecting Node.JS Express in Mysql
I know my project is correct that there is nothing wrong, I think the problem is my newly installed bank, how can I solve this problem? Unhandled rejection SequelizeConnectionError: Client does not…
-
-1
votes1
answer67
viewsHow to get information that is in 2 mysql tables
Table 01: $file Table 02: $users I want to do so, when a user is level ID = 30 display an msg EXAMPLE, File 01 ($file->userid = 20 that is, that user id is in table 02, $users->id) FILE TABLE…
-
-1
votes1
answer1287
viewsHow to receive data from an html form with PHP
Good afternoon, I am new in this area and I am having problems to receive data from my html form with my PHP code. My problem is I’m using for the name of Inputs the following format…
-
-1
votes1
answer282
viewsimporting Xml data into Mysql database - Only save the LAST record
In this code all XML records are read, but in the Mysql database only the last XML block is saved. I know that reading each record over-writes the previous one but the strange thing is that I gave…
-
-1
votes1
answer57
viewsI’m having difficulty formatting a date, it is in this format Mon Jul 30 2018 00:00:00 GMT+0000
I need to record the date and time in the bank, but the date returns me in this format 'Mon Jul 30 2018 00:00:00 GMT+0000' and in the bank is '0000-00-00 00 00:00', I recorded the same in a string…